February 6, 2008 at 5:21 pm
Hello - I'm trying to setup a linkedservers from Sql2005 to Sql2000 across trusted domain using Sql security. But it's not working and somewhat baffled. I don't believe it's a port issue because i was able to connect to the linkedserver if i remotely into the server. However, from my laptop or other remote server, this linkedserver setup would time-out. thanks in advance for any help.
February 7, 2008 at 2:04 pm
What is the error?
Have you tried opendatasource?
Can you connect to the destination server from the source server?
Can you connect to the source server from the destination server?
February 7, 2008 at 5:16 pm
Are both the servers running under localsystem account then u wil not be able use the linked server. yo can do the way given below.
1. create a windows user account named sql service with same password in both the servers
2. grant the account necessary permissions mostly admin rights in the server
3. use this account as startup account in your sql server
4. then create a linked server in both the servers.
the problem is with windows authentication across diff domains.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 7, 2008 at 9:12 pm
He's using SQL authentication - the user account of the SQL server and the fact it's across Windows domains has nothing to do with it at all.
Firewalls?
As already asked, what error are you receiving? Can you use the SQL tools on each server to connect to the other server (ie, point SSMS at the other server)? Make sure you use the same SQL login. How far do you get in the process? ie, can you create the linked server but then not query it? If so, what query are you trying to execute?
February 7, 2008 at 11:28 pm
My interpretation of this is a) the error is timeout (query timeout or login timeout?), and b) it only happens when he connects to one of the servers with SSMS or Query Analyzer from his laptop and queries a linked server, but not when he RDPs into that same server and runs the same query locally (using the same tool?).
As long as Scorpvo is sure he's using the same login credentials in both scenarios, I think the only thing that is different between them is that the resultset data has to travel one hop farther to get to his laptop. Can you get a timeout while a resultset is being sent back to the client? I'm not sure I've ever had that happen.
I agree with Ian, it would be helpful to see more details, the problem query & the error msg.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply