January 14, 2009 at 12:36 pm
Hello,
Question for anyone who can help. If i create a linked server from server A (windows server 2003 and sql 2005) to Sql server B same dimensions, it works just fine, i can access server B data. Problem is when i use my windows xp desktop management studio to do the same thing, and access server b, by creating a linked server, it won't let me, kinda new to sql , if anyone can tell me if it is possible to do this from my remote windows xp. Thank you in advance.
RMoe
January 15, 2009 at 1:48 pm
What's the error when you run the T-SQL query like OPENROWSET?
Server not found, or login/security issue?
January 15, 2009 at 1:55 pm
I was able to login ok and get it to work for me by changing a few of the settings around, but my head programmer wants to use the sql to sql linked server data, and even though i login just fine, he still can't. meaning when i open the linked server i created he still gets an error of null account, doesnt' seem to be a sql error, was thinking it had something to do with his login to windows authentication perrmissions, but i'm not sure.
January 15, 2009 at 2:07 pm
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply