January 16, 2015 at 11:27 am
Hi gurus
I am in need of some serious help, and I hope you gurus can help me.
I have a sql server with one instance and I can connect to it using windows auth but not sql server auth, I have checked an the server is config to do both sql and win mode,that is one, but when I log as win auth every time I try to run a query I get this error
" LOGIN failed for user "NT authority\Anonymous logon"
Can I get some help and thanks a bunch
January 19, 2015 at 8:13 am
guaro5555 (1/16/2015)
Hi gurusI am in need of some serious help, and I hope you gurus can help me.
I have a sql server with one instance and I can connect to it using windows auth but not sql server auth, I have checked an the server is config to do both sql and win mode,that is one, but when I log as win auth every time I try to run a query I get this error
" LOGIN failed for user "NT authority\Anonymous logon"
Can I get some help and thanks a bunch
What application are you trying to connect to the SQL server with? SSMS, sqlcmd, something else?
The failure message you are getting indicates you are trying to connect using windows authentication, and not SQL authentication as a login failure with SQL Authentication would not state that particular user unless you have actually tried that as a user name.
Past experience tells me that you are probably connecting via a service that is running under the local system account rather than a AD login hence the "NT Authority\Anonomous" login, but this is pure speculation without knowing how you are connecting.
MCITP SQL 2005, MCSA SQL 2012
January 19, 2015 at 8:18 am
The Windows Login still has to be present on the SQL Server or the AD Group that the login belongs to has to be present on the SQL Server.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply