Thursday, March 29, 2012

Configure Distributor error

I am trying to "Configure Distributor" prior to setting up the publications. When I go through the wizard, at the very last step I get the following error:

******************************************************************************************

SQL Server could not configure 'serverName' as a Distributor.


ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Cannot find the principal 'sa', because it does not exist or you do not have permission.
'distribution' is not configured as a distribution database.
Changed database context to 'master'. (Microsoft SQL Server, Error: 15151)

******************************************************************************************

I have renamed the 'sa' account. Is there a place I need to change it to the new name for the distributor to work? Thanks.

Currently in SQL Server 2005, replication doesn't support renamed sa login. To make it work, you must change renamed sa login name back to 'sa'. However, this is a valid request and we will consider it in SQL Server 2005 service pack or next release of SQL Server.

Thanks for reporting the problem.

Zhiqiang

This posting is provided "AS IS" with no warranties, and confers no rights.

No comments:

Post a Comment