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 |
|
soorya14
Starting Member
2 Posts |
 Posted - 2009-07-13 : 03:52:32
|
| When i try to connect to a remote sql server am getting the following error- "Login failed for user ''. The user is not associated with a trusted SQL Server connection. "Can anyone please tell me how can i rectify this error.?? My application files reside in one server while database resides in another.I verified the connection strings and it seems ok..Any suggestions would be greatly appreciated. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-07-13 : 04:44:58
|
| Make a connection with a sql server account rather than trying with a windows domain account as on a remote server, your windows account is about as useful as a foam hammer. |
 |
|
|
soorya14
Starting Member
2 Posts |
Posted - 2009-07-13 : 05:45:44
|
quote:
Originally posted by RickD
Make a connection with a sql server account rather than trying with a windows domain account as on a remote server, your windows account is about as useful as a foam hammer.
I'm using a sql server account though connecting through remotely. Thanx 4 ur time.Can u find anything more.. |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-07-13 : 06:05:54
|
| How are you connecting? Is it a linked sever by any chance? |
|
|
|
|
|
|
Login Failed for user null Error: Need Help