Hi,
(First, I should explain that I am not sure whether this is the right part of the forum for this message. My apologies if I'm in the wrong place. If this is the case, could you please let me know where this post should be? Thank you.)
I have a vew that accesses data from a linked server. The view works properly in Query Analyzer but fails when run by a .Net application. The message returned is:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
The linked server has the following attributes:
Server Type: SQL Server
Security: No local logins listed. Connections are made using the login's current security context.
Any help would be appreciated. Thank you.
Resolved. The problem was in two places: I had to remove Anonymous access from the directory in ISS (ISS/Directory/Properties/Directory Security/Edit) and change the login in the SQL Server service from Local Account to my login information (Start/Run/Services.msc/MSSQLSERVER/Log On/This Account). These changes allowed the link server to recognize and authenticate the login.
No comments:
Post a Comment