I have SQL server installed in a Windows 7 box. I have my website which accessed the SQL server installed in Windows Server 2008 R2. The problem is the WIndows & box wont accept the credentials from the NT Server...
Windows 7 user with admin rights called SQLWIN7/bob
Logged into Server 2008 as SVR/admin
I did an experiment and attempted to access SQLWIN7/c$ it asked for credentials so I entered SQLWIN7/bob and pw - access denied
I then attempted to access SVR/C$ from SQLWIN7 as SVR/admin - success
So it appears SQL server cannot access the Windows 7 Machine using a Windows 7 admin account!! This is why I can get SQL server authentication working
Any suggestions for this?
ASP.NET Impersonation disabled
Server=192.168.1.6;Database=socks;User ID=SQLWIN7\bob;Password=●●●●
Login failed for user 'SQLWIN7\bob'.