November 30, 2008 at 2:34 pm
Hi,
I am trying to establish a linked server connection to a new SQL server (x64) from our preexisting SQL Servers (x86); however am getting the following message:
------------------------------------------------
Login failed for user 'DOMAIN\MYUSERNAME'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)
------------------------------------------------
The server is setup to allow remote connections on both TCP and Named Pipes
The server is setup to be ONLY Windows accounts; ie no SQL users
The user has been given permissions to read the databases; in fact I tried it as a sysadmin too, but no difference.
The Linked server has been setup as a SQL Native connection, using a specific windows/AD account; so therefore wouldn't expect it to be subject to the usual suspects of 1 hop/2 hop issues (as no delegation etc)
I am stumped; can anyone offer any pointers please?
Thanks in advance
Troy
November 30, 2008 at 7:21 pm
Okay, so it looks like I have been sadly fooling myself in thinking that this LinkedServer might work with a windows account....it looks as though these only work with SQL logins when choosing the "be made with this security context" option...
*sigh*
November 30, 2008 at 10:28 pm
Take a look at this thread and see if it sheds any light on your situation: http://www.sqlservercentral.com/Forums/Topic471172-359-1.aspx
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply