April 13, 2012 at 5:54 am
Hi
I was trying to create a linked server on ServerA. This linked server is supposed to get data from ServerB.
So I tried to create a linked server with Name XYZ assuming that XYZ will point to ServerB. But when I checked IP, I found that it is actually pointing to ServerC.
I went on ServerC and checked if any alias is created with name XYZ. it was not. I also checked host file entries of serverC to make sure if any entry there is pointing XYZ to IP of ServerC.But it was also not there.
My question is : what are the other places I should check to see what makes XYZ point to IP of serverC instead of serverB?
Thanks
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.
April 13, 2012 at 7:14 am
Can you detail the exact steps you are taking and the options you are using to create the linked server?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 13, 2012 at 7:30 am
I got it resolved. Looks like it has to do with the Local Loging I was giving while creating the linked server. I used an administrator id there and it worked.
Thanks for your time....
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply