TITLE: Microsoft.SqlServer.ConnectionInfo
SQL Server could not configure 'RemoteHost\REPL_DIST' as a Distributor.
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
An error occurred during decryption.
There is no remote user 'distributor_admin' mapped to local user '(null)'
from the remote server 'repl_distributor'.
Changed database context to 'master'. (Microsoft SQL Server, Error: 15466)
For help, click:
http://go.microsoft.com/fwlink?ProdN...LinkId=20 476
in CTP2 the following worked fine.
--OnRemoteHost
use master
exec sp_adddistributor
@.distributor = N'RemoteHost\REPL_DIST',
@.password = N'PassWord1'
GO
I get the same error when using the Wizard to create a remote distributor.
I'm and Admin on both LocalHost & RemoteHost
The RemoteHost XP-SP2 has firewall disabled.
Just looking for some clues (The help link isn't)
Cheers
Gryphyn
One of the most well-known reasons behind the error that you saw has to do
with changes in the SQL Server service account after replication has been set
up (account name and\or password). But given that multiple people have
reported similar issues with the latest CTP (April), I tend to suspect that
there is something more behind this. Unfortunately, we have so far been
unable to duplicate the error in our lab and so it would be great if you can
tell us whether any of the following apply to your scenario:
1) Was the remote distributor sevrvice account changed in any way?
2) Are the remote distributor and the publisher machines in the same domain?
3) Did you attach the old master\distribution database files to the latest
CTP server when you upgraded?
4) Are the remote distributor and the publisher running the same version of
the CTP?
5) Are the distributor and publisher SQL Server Service running under domain
accounts or local system accounts?
6) Have you ever been told to turn on certain server trace flags?
7) Are you using any virtualization products such as VirtualPC by any chance?
If you have done 3) at the distributor during upgrade, it would be
interesting to see if dropping and re-establishing the remote publisher at
the distributor resolves the issue (reseting the password etc.). BTW, we do
have newsgroups set up for everything related to SQL2005 @.
http://communities.microsoft.com/new...r2005&slcid=us
(it is fully accessible to me but may require Passport\beta account sign-up
etc. from you) which are preferred for reporting problems in SQL2005.
HTH
-Raymond
"Gryphyn" wrote:
> TITLE: Microsoft.SqlServer.ConnectionInfo
> SQL Server could not configure 'RemoteHost\REPL_DIST' as a Distributor.
> ADDITIONAL INFORMATION:
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> An error occurred during decryption.
> There is no remote user 'distributor_admin' mapped to local user '(null)'
> from the remote server 'repl_distributor'.
> Changed database context to 'master'. (Microsoft SQL Server, Error: 15466)
> For help, click:
> http://go.microsoft.com/fwlink?ProdN...LinkId=20 476
> in CTP2 the following worked fine.
> --OnRemoteHost
> use master
> exec sp_adddistributor
> @.distributor = N'RemoteHost\REPL_DIST',
> @.password = N'PassWord1'
> GO
> I get the same error when using the Wizard to create a remote distributor.
> I'm and Admin on both LocalHost & RemoteHost
> The RemoteHost XP-SP2 has firewall disabled.
> Just looking for some clues (The help link isn't)
> Cheers
> Gryphyn
>
