SQL Server Performance Forum – Threads Archive
Can’t recognize SQL serverHello, I have a SQL server in the company that is on a differnet domain than where I want to connect to it from in Enterprise Manager. When I try to connect, I put in the servername, user and password and it does not find the server. Is there a way to do this successfully, or does the SQL server have to be on the same domain as where I connect to? Thanks.
I guess v need to link to the server first before connecting…correct me if iam wrong Regards
I’m not sure what you mean by "link". Thanks.
Depends on what (kind of) login you’re trying to access the server. If it’s a Windows login, then there must be a trust between the two domains. If it’s an SQL login, you should be able to access the server. Can you ping the server? On IP and on server name? With and without the domain name?
If you are submitting username and password detail it implies the server is accepting SQL Logins. In this case it does not matter which domain either party belongs to as the authentication is handled by SQL Server only. Post your error message.
i meant u need to create a linked server … Regards
I ping’d the server with server name, I did not try IP address and did not use the domain name. Also, I was using SQL authentication. I had a feeling is was due to security, so I set up a test account with SQL login wil full rights and this still would not work. I was at a client and I did not save the error message, but it said something like "Unable to locate" server. It did not say the credentials were incorrect, it said it could not locate the server. When I map to the server in EM, do I need to add the domain into the name, for example, "domain/SQLserver" instead of just the servername? Thanks.
Okay, but did you get any replies when you pinged the server?
Yes, I could ping the servername without the domain.
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by rweinstein</i><br /><br />Yes, I could ping the servername without the domain.<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />Hi,<br />if you can get ping reply then try this ,<br /><br />sp_addlinkedserver @server = ‘servername’ , ‘SQL SERVER'<br /><br />sp_addlinkedsrvlogin @rmtsrvname = ‘rmtsrvname’ <br />,@useself = ‘false’ <br />,@locallogin = ‘sa/yruser'<br />,@rmtuser = ‘sa/yruser’ <br />,@rmtpassword = ‘password’ <br /><br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />]<br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami<br />
And do you know if an instance name is used and which port SQL is listening on? If you could post the exact error it would speed a correct answer.