July 30, 2008 at 4:57 pm
I have added a Linked server to one of my production box sucesfully. but when run a simple query like
select * from prod..master.syslogins --- system is running this for like 5 minutes with no response? Is there anything i need to do?
appreciated feedback.
Many thanks,
Cali
July 30, 2008 at 5:10 pm
Maybe it's just a typo, but the 4 part name should be:
server.database.owner.table
which I think, in your case would be prod.master.dbo.syslogins.
Is there an error message in the log of either server??
July 30, 2008 at 5:16 pm
Unfortunately no error... it's weird. its runing for like 15 minutes now without any errors.
July 30, 2008 at 5:22 pm
So, did you change the query to use prod.master.dbo.syslogins?
Can you see the connection being made on the linked server? If so, what database is the spid using?
Does the account you are using have the correct permissions to access and select from the master database on the linked server?
July 30, 2008 at 5:32 pm
Yes i changed the query to use prod.master.dbo.syslogins. I dont see the connection. all what i see is - its executing the query.
I.E - when I execute the query I could see the little circle spinning on lower left side of the screen. that's it. it's been going on for like 10 minutes without any results. The user what i have given in the security context is SA.
Dont know - why this doesnt work. i did in the past on a different server and it was working great.
July 30, 2008 at 5:38 pm
So, if you go to the linked server, you don't see the connection you're starting from the original server. Sounds like it's having trouble logging in.
Could you post the linked server definition? Are you using sql server authentication? Is the SA password the same on both servers?
July 30, 2008 at 6:02 pm
Well SA password is different and in the security connection syntax i am giving connect using SA login and providing the right SA password. weird dont know - whats going on.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply