Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
guaro5555
Starting Member
16 Posts |
 Posted - 2015-01-16 : 11:28:12
|
| 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 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2015-01-19 : 01:49:09
|
| If you're attempting to logon as Windows , you'll need a valid Windows account. Do you have a valid SQL authentication login you can use? How are you attempting to logon - via a web server or direct onto SQL Server?Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-01-19 : 12:28:06
|
| Is your query using a linked server?Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Login Failed for user NT Authority/Anonymous