Connection error

[Paully1999]

I have two servers 1 NT4 trying to access a Win2000 SQL 2000 server. They are in the same Workgroup not domain. when I attempt to connect I get the following

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

The test DSN connection works fine though. This is my connection string

Conn.Open "DSN=MyDSN;UID=sa;PWD=test;TRUSTED_CONNECTION=NO;APP=ASP script"

Please help!

 

[fluteplr]

Run the sql server client network utility on the client machines and make sure you are connecting with tcp/ip not named pipes. Named pipes requires security authentication or allowing guest logons.