sql server connect: Again a "Login failed for user 'null" -- sql server connect

Again a "Login failed for user 'null"

Michiel
2/24/2004 3:28:38 PM

sql server connect:

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

Re: Again a "Login failed for user 'null"

Bala Neerumalla[MSFT]
2/27/2004 4:20:20 PM

How 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

[quoted text, click to view]