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 |
|
chichicabron
Starting Member
1 Post |
 Posted - 2008-11-10 : 17:02:38
|
| OK, I am sure there is a simple explanation for this, but it is driving me crazy.We have 2 SQL Server 2000 servers, both in the same Windows 2003 domain. Both are set for mixed-mode authentication.Using SQL Query Analyzer, I can connect to either server using windows authentication. BUT when I connect to Server1 (using windows authentication) and try to run "SELECT * FROM [Server2].Database1.dbo.Table1" I get the following error:Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.Permissions are correct for both servers. My question: why is it "user'(null)'"? Even if the permissions are wrong, shouldn't it at least see my windows login? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-10 : 17:09:36
|
| You need to setup linked server and logins should be trusted with Windows authentication to work. |
 |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-11-10 : 17:10:16
|
| How is the security setup for your linked server or is it?- Edit - Sorry, sodeep beat me to it.Terry |
|
|
|
|
|
|
Login failed for user '(null)'