I have a File/Sharing Server which is Server 2008 SP2 and SQL Server 2008 is installed on it.
My system which is on the same workgroup, was running Windows 2003 Server, which I have saved Server 2008 login credential on it and used that credential to login to SQL Server on Server 2008 system in Windows Authentication mode using SQL management studio.
Recently I installed Windows 7 on that system, and I have also saved that Server 2008 credential in Windows 7 Credential Manager.
The problem is here when I want to login in Windows Authentication mode using SQL management studio like past, and I will get below Error:
Cannot connect to [SERVER]
Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. (.Net SqlClient Data Provider)
Error Number: 18452
Line Number: 65536
I tried that registry solution (DisableLoopbackCheck=0x01
this thread), but no luck with that.
I have checked the outgoing packets when I click on connect, and I found out that SQL management studio tried to send my local windows credential instead of Server 2008 saved credential.
I don't want to login in SQL Mode, and also I don't want to convert my server to Domain controller.
Is there any other solution with this issue?
View Complete Post