February 17, 2011 at 10:08 am
I am trying to select data from linked server and get an error message:
Login failed for user 'SUN_Link_Srv'
Why is that? My linked server is regestered under this name and I am ok to save link server when it was created.
February 17, 2011 at 10:11 am
Can you login on the remote box with that user?
February 17, 2011 at 10:30 am
yes
February 17, 2011 at 10:32 am
Krasavita (2/17/2011)
I am trying to select data from linked server and get an error message:Login failed for user 'SUN_Link_Srv'
Why is that? My linked server is regestered under this name and I am ok to save link server when it was created.
When you say 'registered', do you mean that you've set the linked server security to impersonate that user on all connections?
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 17, 2011 at 10:36 am
yes
February 17, 2011 at 10:48 am
That's strange then. When you login to the foreign box, using that user, and connect to the database that you're trying to pull data from... does it give you security complaints?
Also, is there any more to the login failure error message? Do you get it when running a script or when setting up the linked server? Does the script have any other linked servers involved in it?
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply