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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-07-21 : 09:38:23
|
| td writes "I have two SQL servers one set to mixed mode and the other set to windows authentication only. Trying to set up a link server connection between the two with no luck. receive:Login failed for user '(null)'. Reason: Not associated with a trusted SQLServer connection. Need to get at least the two servers speaking and then figure how to get an app to do this without the double hop." |
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2006-07-22 : 17:18:34
|
| Check the login is assigned to the database.(put this to yourdatabase) not master as you will not see all the tables views etc only master ones.Try a sql login first and see if that works...For sql login...(choose the security and pick 4th be made using this security context..If the sql login works....Try just putting in domain\login (hmm looking now need password) ...? try itElse try doing..sql login...use 3rd one down be made using current logins...then impersonate.I have always used sql login.....(but im know i have a sql login with the 3rd option selected as nt) |
 |
|
|
|
|
|
Link Server issue