recordset dtc cant connect to SQL7 SP3

[ruelmercado]

when i connect to a SQL Server 7.0 SP3 i get this message...

Microsoft OLE DB Provider for SQL Server error '80040e4d'

Login failed for user 'IPI\IUSR_SOL4_MAIN'.

/solomon/test entry.asp, line 75

but when i connect with a server with no SP's everything is working well. what's the problem with my setup?

 

[MerlinB]

Search MSDN for your error (

http://www.msdn.microsoft.com/default.asp

)

Results include:

http://support.microsoft.com/support/kb/articles/Q222/8/28.ASP

I think perhaps the service pack tightens up the default login method from SQLServer to NT-authentication.

Adjust the ODBC-DSN attributes, or add the Anon Web user as a user of the SQLServer database.

Hope this helps!

http://www.websitedesign.co.uk

http://www.zentext.com

(Content Management)