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 - 2008-07-12 : 09:56:17
|
| Hi guys.i have a case that is puzzling me.i wanted to configure backup database server as a back end for asp.net application which is on another machine.i installed sql2000 with sp4. the application is using windows integration and the backup server is part of the domain. when accessing the system its giving Login failed for user '(null)',Reason: Not associated with a trusted SQL Server connectioni installed sql 2000 on different machine (also part of the domain )just to test and left everything as default (user running the service) it worked finequestion why its not working on win2003 server while its working on xp computer although it took me no configuration on xp just attached the databases i.e no security addings, setting spns nothing at all while same configurations are not working on the back up serverplease help me |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-12 : 13:50:21
|
| Did you add windows account as sql login in sql server yet? How did you connect to that sql server? |
 |
|
|
ann06
Posting Yak Master
171 Posts |
Posted - 2008-07-19 : 04:20:00
|
| today i got it fixed :DDDDspn was registered under local system account but as FQDN so just putting the alias name was giving the above errorso it was the dam error thanks you i just wanted to post my b some1 will get the benefit somedaynourann@hotmail.com thanks best sql site ever :D |
|
|
|
|
|
|
Login failed for user '(null)'