March 27, 2012 at 1:10 am
I have two laptops and I installed sql server on both of them. I connected them using RJ45 and configured the LAN such that I am able to ping to each machine.
The Issue I want to connect to the instace installed on the remote system. How do I do that. I have a login on the second server.
What do I need give in the "Server name:" field on my source server to connect to the remote machine.
I mean do I need to connect using an IP and port num. If it is the case what is the format I need to give?
I did go search in the newtwork instances and I was able to detect the remote server. My question is how do I login using the IP address?
March 27, 2012 at 1:19 am
If you are able to get to your server by searching for the network instances, is there a specific need as to why you need to connect using the IP?
In any case, yes, you can use the IP address and the SQL Server port # to connect using SSMS to your remote server.
Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Follow me on
Twitter: @sqltwins
March 27, 2012 at 1:59 am
can you telnet to remote instance IP on port 1433 ?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 27, 2012 at 4:19 am
Hi ,
you can connect sql server using ip address.
use this >> ipaddress\instancename --> if it is named instance of sql server
use this >> ipaddress --> if it is default instance of sql server
use this >> ipaddress\instancename, port number..>> if it is listen on specific port rather than default port like(xxx.xxx.xxx.xxx\instancename,56456)
and ensure that tcp ip is enable in sql server network configuration on your remote system.
hope so it will be work for u.......
March 27, 2012 at 11:37 am
Thank U very much. It Did solve my problem.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply