Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
You may receive error messages when you use the Configure Distribution Wizard in SQL Server 2005
Article ID: 914779 - View products that this article applies to.
BUG #: 422648 (SQLBUDT)
When you use the Configure Distribution Wizard to configure a distributor in Microsoft SQL Server 2005, you may receive the following error messages.
SQL Server could not configure 'InstanceName' as a Distributor. (Microsoft.SqlServer.ConnectionInfo)
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Note InstanceName is a placeholder for the instance name.
Cannot find the principal 'sa', because it does not exist or you do not have permission.
This problem occurs because the SQL Server system administrator account name is changed. The Configure Distribution Wizard requires the account name to be sa.
Service pack informationTo resolve this problem, obtain the latest service pack for Microsoft SQL Server 2005. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/913089/ )How to obtain the latest service pack for SQL Server 2005
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. This problem was first corrected in Microsoft SQL Server 2005 Service Pack 1.
To access the Configure Distribution Wizard, follow these steps:
For more information about the Configure Distribution Wizard, visit the following Microsoft Developer Network (MSDN) Web site:
http://msdn2.microsoft.com/en-us/library/ms190082.aspxFor more information about how to view and modify distributor properties, visit the following MSDN Web site:
Article ID: 914779 - Last Review: April 18, 2006 - Revision: 2.4