Problems connecting to a remote SQL Server

[Stoomis]

I have IIS 5.0 running on Server A. SQL Server is running on both Server A and Server B. For Server A I can get both SQL Server Authentication and Windows NT Authentication to work depending on how the DSN is setup. For the entire site I have disabled Anonymous Logons and have only allowed Integrated Windows Authentication. However I cannot get Windows NT Authentication working with the Remote SQL Server. When I try to connect I get the following.
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
This remote server is using Windows Only Authentication by design. Is there something I am missing to allow Windows NT Authentication to work with a remote server? Any ideas are greatly appreciated.

 

[Chopstik]

You might try forum41.

------------------------------------------------------------------------------------------------------------------------
If you don't have a sense of humor, you probably don't have any sense at all.
- Anonymous

 

[DreXor]

sounds like domain issues, ensure both machines are on the same workgroup/domain and that IWAM_MachineName for each machine is allowed on both machines in both directions.

if all else fails, for simple testing use the SQL install disc to just install the client tools on the other machine to try and find/connect to the other machine, uninstall them when you're done.

and last thoughts, be sure you dont have any software/hardware firewalls interfering as well between the machines

also your question seems a little vague, you trying to connect server a to server b or just server b to itself?

DreX
aKa - Robert