Verify that you have the proper authority level to complete registration and SQL Server configuration tasks.
The following user authority levels are required:
To enable transactional replication on the publication database, you must have System Administrator authority, or the SA role.
To create registration groups and capture registrations from the PowerExchange Navigator, you must have DB_OWNER authority.
The first time you add a registration group in the PowerExchange Navigator, PowerExchange creates a publication named "PowerExchange Change Capture." If you did not previously enable transactional replication on the publication database, PowerExchange also attempts to enable transactional replication. In this situation, you must have System Administrator authority, or the SA role, to enable transactional replication and create the first registration group. Thereafter, users with DB_OWNER authority can add registration groups under their own user IDs and passwords and add capture registrations.
To run change data extractions against a SQL Server distribution database, you must have read access to that database.
If you do not specify a user ID and password when creating a registration group, the PowerExchange Navigator and the extraction processes attempt to use your Windows user ID and password to connect to the SQL Server distribution database.