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.

Configuration problems

Hi,
I am trying to configure my serwer (local computer) as a distributor and
publisher to see how it works. I have created sample database with one table
and few filelds. One of them is unique primary key.
During Configuring and Selecting Distributor or Creating Publication I get
an error:
Error 14114: '(null)' is not configured as a Distributor.
What can be the problem? I was trying to configure transactional
replication, but I think that it has no influence, because error occures
during configuring distributor. Also I have used fo snapshot folder admin
share C$ ans normal share with full rights for all users C.
Software versions are:
Windows XP Professional SP1
SQL 2000 Developer SP3 version 8.00.760
Thank you
Przemo
Have a look at http://support.microsoft.com/kb/q302223/
You may have changed the name of the machine since installing replication
and there is no entry in sysservers with the new machine name
--
Mary Bray [SQL Server MVP]
Please only reply to newsgroups
"Przemo" <Przemo@.discussions.microsoft.com> wrote in message
news:3473CCB4-6C0B-4ED4-833E-73CEC5E2E1DB@.microsoft.com...
> Hi,
> I am trying to configure my serwer (local computer) as a distributor and
> publisher to see how it works. I have created sample database with one
> table
> and few filelds. One of them is unique primary key.
> During Configuring and Selecting Distributor or Creating Publication I get
> an error:
> Error 14114: '(null)' is not configured as a Distributor.
> What can be the problem? I was trying to configure transactional
> replication, but I think that it has no influence, because error occures
> during configuring distributor. Also I have used fo snapshot folder admin
> share C$ ans normal share with full rights for all users C.
> Software versions are:
> Windows XP Professional SP1
> SQL 2000 Developer SP3 version 8.00.760
> Thank you
> Przemo