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 |
|
cjblake
Starting Member
2 Posts |
 Posted - 2006-04-07 : 16:07:13
|
| On one of my SQL Server installations I have a linked server defined. I have created a stored proc that queries the linked server. If I log into the server as me (I'm an administrator) and use Query Analyzer to run the SP, it runs fine. If I am using QA from my own PC, I get: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. Any ideas on what is causing this? I will be wanting to have this sp run from a .net application with another (non admin account), but I figured I'd start here at this point. Thanks so much for any input! CJ |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-04-08 : 08:57:08
|
| firewall?--------------------keeping it simple... |
 |
|
|
cjblake
Starting Member
2 Posts |
Posted - 2006-04-10 : 17:29:22
|
| Here's the cause of the problem:You need to setup the linked server to use a SQL Account when logging into the remote SQL Server.You are butting up against the NTLM double hop.I just added a mapping for the clients on server A to a standard security login on server B, on the Security tab of the Linked Server Properties dialog box in Enterprise Manager as per: http://support.microsoft.com/kb/238477/en-usCJ |
|
|
|
|
|
|
trusted connection error from Query Analyzer