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 |
|
ann06
Posting Yak Master
171 Posts |
 Posted - 2010-11-01 : 06:42:18
|
| hi,i have a website and sqlserver on the same box, the website using windows integrated authentication.when access the website using netbios name its authenticating and working finewhen using the ip address instead its not authenticating and giving the below error:Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.please help is this related to dns and how to fixthanks folks |
|
|
shaggy
Posting Yak Master
248 Posts |
Posted - 2010-11-01 : 07:57:10
|
| select sid from sys.database_principals where name = USER nameselect sid from sys.server_principals where name = Login namecheck whether both sid column data is same |
 |
|
|
|
|
|
Login failed for user '(null)'. Reason ...