| Author |
Topic |
|
rohans
Posting Yak Master
194 Posts |
 Posted - 2004-08-12 : 11:09:19
|
| I need to know if the linked servers have to be in the same domain as I am trying this with a sql server that I connect to using an IP address on a different domain, but it is saying the login is invalid. The remote user and password have been set from within EM by right-clicking on the linked server and selecting properties then the security tab.It says error; login failed for user 'username'; The username display is that of the remote server which was set in the security section of the properties.All help appreciated. |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-12 : 11:55:45
|
| You can. Check the "Be made using this remote context" radio button. Type in the username and password there. Also, is this using the default port? If not, you have a little bit more work to do.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
rohans
Posting Yak Master
194 Posts |
Posted - 2004-08-12 : 12:05:30
|
| Derrick, I took the option that says,be made using this security context. However I am still getting the error "login failed for user 'username'.All help appreciated. |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-12 : 12:06:40
|
| Can you ping that IP address from the computer you're setting this linked server up on?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
rohans
Posting Yak Master
194 Posts |
Posted - 2004-08-12 : 12:07:16
|
| Not sure if I told you that the error comes when I click on the table icon under the linked server tree. Hope this helps.All help appreciated. |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-12 : 12:08:06
|
| Can you ping the server?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-12 : 12:08:37
|
| Is there a trust relationship setup between the two domains?Tara |
|
|
|
rohans
Posting Yak Master
194 Posts |
Posted - 2004-08-12 : 12:08:43
|
| No I cannot. Very starnage as i can connect through EM to that server. I will check with my network admins.All help appreciated. |
|
|
|
rohans
Posting Yak Master
194 Posts |
Posted - 2004-08-12 : 12:48:50
|
| I got it working, the IP was also in the catalog field.All help appreciated. |
|
|
|
|
Linked server using IP address