Friday, February 24, 2012

Again a "Login failed for user 'null"

Hi,
I'm trying to setup replication between 2 SQL server on 2 different sites.
SQL server A is a W2k SP4 server with SQL7.0 with SQL2000 client tools
SQL server B is a W2k SP4 server with SQL2000
Servers are in mixed mode.
Servers both have MDAC version 2.6 sp2
Username used to login to the server is the administrator and for connection
to SQL is use the sa account.
When I try to start a snapshot agent I get the message "Login failed for
user 'null'. Reason: Not associated with a trusted SQL Server connection"
How can I solve this problem.
kind regards
Michiel BoerHow are you launching the snapshot agent? through command line or sql server
agent?
What is the exact command that you are using?
What account is the SQL agent service running under?
Thanks,
Bala.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Michiel" <meme@.ikkus.com> wrote in message
news:403b5fc8$0$32978$e4fe514c@.dreader15
.news.xs4all.nl...
> Hi,
> I'm trying to setup replication between 2 SQL server on 2 different sites.
> SQL server A is a W2k SP4 server with SQL7.0 with SQL2000 client tools
> SQL server B is a W2k SP4 server with SQL2000
> Servers are in mixed mode.
> Servers both have MDAC version 2.6 sp2
> Username used to login to the server is the administrator and for
connection
> to SQL is use the sa account.
> When I try to start a snapshot agent I get the message "Login failed for
> user 'null'. Reason: Not associated with a trusted SQL Server connection"
> How can I solve this problem.
> kind regards
> Michiel Boer
>
>

No comments:

Post a Comment