Connection Error '8004e4d' - NT AUTHORITY\ ANONYMOUS LOGON. what????

[timtom]

Our development phase is nearly done, and we want to move our SQL database from the test server to the real one we're going to use. Transfering the database and installing sql worked fine, and we changed just the one word in our connection script,

( from "Provider=SqlOledb;database=blah;uid=blah;pwd=blah;server=one" to "Provider=SqlOledb;database=blah;uid=blah;pwd=blah;server=two"

But it didn't work. Accessing the database through an asp page we get the error '8004e4d' - NT AUTHORITY\ ANONYMOUS LOGON

Has anyone had experience of this error? Unfortionately we didn't set up the original test setup, so we don't know what's different.

Any help gratefully appreciated, half our intranet's down!


Cheers
Sarah

_{WASN'T FIT ENOUGH FOR THE POLICE FORCE}​

 

[Jonax]

Well, I'm not sure, but does the MachineNameIUSR account have the required permissions?

 

[Geee]

Looks like that the development machine had SQL server set up to use SQL authentication, where you supply a different username and password for SQL Server to authenticate. Server 2 looks like it is set up use NT authentication, try changing it to SQL authentication!

G -GTM Solutions, Home of USITE-
-=

http://www.gtmsolutions.com=-