SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Remote login question		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

masterdineen
Aged Yak Warrior

United Kingdom
517 Posts
Posted - 02/22/2013 :  02:20:23  Show Profile  Reply with Quote
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)

Singapore
16746 Posts
Posted - 02/22/2013 :  03:16:19  Show Profile  Reply with Quote
yes you can

KH
Time is always against us
Go to Top of Page

masterdineen
Aged Yak Warrior

United Kingdom
517 Posts
Posted - 02/22/2013 :  03:31:38  Show Profile  Reply with Quote
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)

Singapore
16746 Posts
Posted - 02/22/2013 :  05:47:34  Show Profile  Reply with Quote
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
Time is always against us
Edited by - khtan on 02/22/2013 05:48:30
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000