Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Remote login question

Author  Topic 

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2013-02-22 : 02:20:23
i have been given user credentials and IP address to create
a linked server toi work with a clients server.
but could I just login just using ssms as you would
with a server on site.

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2013-02-22 : 03:16:19
yes you can


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2013-02-22 : 03:31:38
yep just done it. cheers

when do you have to insert servername then port number ie servername/2044

i have had to do that before
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2013-02-22 : 05:47:34
when the SQL Server is configured to listening on that port instead of the default port no

or the remote server may be behind a firewall and that is the port no configured in the firewall for access


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page
   

- Advertisement -