| Author |
Topic |
|
mfemenel
Professor Frink
1421 Posts |
 Posted - 2005-05-04 : 15:39:52
|
| I need to setup a linked server on a different domain than what I normally use. When I set up a linked server I set the datasource to domainname\servername where normally I'd just put in the server name. Then I fill in my catalog and security info as I would on a local domain. I keep getting "server does not exist or access denied". Before I go back to the company that provided me with the login information i wanted to check to see if I was doing this right. Can't find any posts related to this and google thus far is pretty sparse with help. I'm open to suggestions. Let me know if you need more info.Mike"oh, that monkey is going to pay" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-05-04 : 15:44:29
|
| For the datasource, use the ServerName. Do not use DomainName\ServerName. If you still get this error, you'll need to create an alias on the database server that uses the ServerName as the AliasName. Make sure to use TCP/IP for the alias.If you are going to use Windows Authentication for the linked server, then a trust relationship must exist between the two domains. What I would do before even bothering with the linked server is logging into the database server directly and checking to see if you can even register this other server via Enterprise Manager. Once you get it to work from there, it should work as a linked server.Tara |
 |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2005-05-04 : 15:52:55
|
| Still not liking me. From EM when I try to register it, I've tried just the db name(that shouldn't work because we're not on the same domain) and the domain\servername, same error. I'm beginning to suspect they gave me a bad login name. Would my domain\username need to have rights on the other domain to create the registration? They get me a sql login for the remote server.Mike"oh, that monkey is going to pay" |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-05-04 : 15:58:45
|
| Yes just the server name should work. I've never used Domain\Servername. I've only ever used Domain\ when dealing with userids never with servers.Did you try setting up an alias?I don't think this is a permissions issue as the error that you are getting just means that the database server is unable to communicate with the other server. This is typically due to network issues such as DNS not resolving the hostname to an IP address (hence the alias suggestion).But yes your Windows account will need permissions on the other domain, this is done via a trust relationship. The server admins should be able to handle that for you. If the DBA of the other server is able to add your Windows account to this other server, then I think that means the trust relationship exists.Tara |
|
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2005-05-04 : 16:14:10
|
| Tried the alias, didn't help. Of course that assumes they're listening on 1433. And my login doesn't have permissions to this other domain so I'm pretty much shooting myself in the foot right now. I think it's time to get someone from the other group on the phone who has some rights and work through this thing. Thanks for trying.Mike"oh, that monkey is going to pay" |
|
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2005-05-04 : 16:28:38
|
| Turns out the user name/pwd they gave me is a domain account on the other domain. Doesn't do me a whole lot of good!Mike"oh, that monkey is going to pay" |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-05-04 : 16:40:52
|
| You should still be able to use it, that is if they setup a trust relationship. It seems like that's doubtful though.Tara |
|
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2005-05-04 : 16:50:17
|
| If I'm registering a server though, windows auth would use my login and sql server login doesn't work.Mike"oh, that monkey is going to pay" |
|
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2005-05-04 : 17:04:22
|
| Ok, I quit. They just informed me that right now they just have named pipes and will turn on ports tonight. Killing me.Mike"oh, that monkey is going to pay" |
|
|
|
nishithrn
Yak Posting Veteran
58 Posts |
Posted - 2005-05-05 : 01:17:25
|
| I think a trust should exists between the two domains. Ask you System Admin guy to chekc for the same. |
|
|
|
|
Linked Server on Different Domain