0

I have my VPS server in a remote location with ip address 172.16.11.2 (for example) having two instances of sql-server express running.

one instance is Microsoft SQL Server 2008 R2 (SP2) where I connect from my local PC using remote desktop with the following credentials:

 servername : 172.16.11.2
 authentication : sql - server authentication
 userid: xx
 password:xx

the other instance is:

Microsoft SQL Server 2008 R2 (SP2) with advanced services. To connect to this machine I remote desktop to the server and type in

 servername : machinename\sql-express
 authentication : sql - server authentication
 userid: xx
 password:xx

now using remote desktop from my local machine how will I connect to this instance of sql-server.

I tried

 172.16.11.2\sqlexpress 

but this failed. I also enabled sharedmemory/namedpipes/tcp-ip but still I am not able to connect. When I go to the machine where sql-express is installed and then type machinename\sqlexpress I am able to connect the sql-express instance, but from my local machine using sql-management studio if i type in ipaddress\sqlexpress I am not able to connect. It gives me network related issue error.

  • @Paul white . I edited the issue. This is not a duplicate one as mentioned by you. – Venkat Mar 25 '15 at 15:55
  • What are the TCP ports for both instances set as? – LowlyDBA Mar 25 '15 at 16:20
  • MSSqlserver - 1433 for sqlexpress - none – Venkat Mar 25 '15 at 16:29
  • 2
    Try setting one for Sqlexpress and then connecting to it as 172.16.11.2\sqlexpress,port – LowlyDBA Mar 25 '15 at 16:30
  • can i set any port number ? is it ipadress\sqlexpress, port?? – Venkat Mar 25 '15 at 16:33
2

Ensure that the secondary instance (in this case SQL Express) has a TCP port set.

  1. Under SQL Server Configuration Manager, go to SQL Server Network Configuration, then Protocols for [INSTANCENAME].
  2. Right click TCP/IP and under the IP Addresses tab make sure the field "TCP Port" has a value (for example 1533).

Then try to connect to the instance with the newly assigned port:

172.16.11.2\sqlexpress,1533

Voila!

0

type in run command -> mstsc

then remote desktop connection window will be pop-up. That window will ask your Computer and User Name

In "Computer Name" field there will be your "Remote Desktop IP address"

and "User Name" field type your local computer UserID, from which userid your did login in your local computer.

After again new "Windows Security" window will be pop-up. It will ask your credential details because these credentials will be used to connect to your Remote Server IP address.

Here UserID & password will be your local computer userid & password through which you had logged in your computer

UserID automatically comes from Windows and your password will be your local computer password

After providing these credential again new windows will be popup for "certificate authentication". That window will ask you "The identify of the remote computer can not be verified. Do you want to connect anyway?" click "yes".

Hope your remote connection will be established.

  • I think you misunderstood my question. Please read again. I didnot ask the steps for connecting to remote desktop. I was asking for steps to connect to sql-express instance through sql-management studio – Venkat Mar 25 '15 at 15:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.