2

There are two instances of SQL Server installed on my PC.

SQl server instance

Version 11 and 13.

  • for accessing version 11, I enter .\ in a server name
  • for accessing version 13, I enter (LocalDB)\MSSQLLocalDB

When it comes to IP address I enter 192.168.1.104 (my IP) in the server name and it directly opens SQL Server Express (v11)

So what I need to enter in server name so I can access SQL Server (v13) through IP address?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
abhi
  • 45
  • 2
  • 10
  • You need to find out the server ip for your MSSQL 13 . Then use that IP to connect to the desired server you want when you open SSMS. – Cookie Monster Nov 17 '17 at 07:44
  • MSSQL IP? what is it? how it can be different from my Machine ( IPv4 Address) IP – abhi Nov 17 '17 at 08:26
  • When you open SQL server, it will prompt you to enter a server IP or name to log into it. So you need to know the IP for your localdb and use that IP to connect to it. – Cookie Monster Nov 17 '17 at 09:11

1 Answers1

1

LocalDB only works local via named pipes and does not support connections via TCP/IP, thus you won't be able to connect via IP-address.

Remark: There was a declined feature request some years ago.

MatSnow
  • 7,357
  • 3
  • 19
  • 31
  • so you mean there is no way to connect another instance are u sure? – abhi Nov 17 '17 at 08:27
  • 1
    Yes it's possible to connect multiple instances via TCP/IP in SSMS. But you can't connect the (LocalDB) instance via TCP/IP. If you have multiple SQL Express instances (not LocalDB's) on your computer you can connect to them via [Servername\Instancename] or [IPAdress\Instancename]. If you have only one SQL Express instance installed on your computer you can connect to it via IP, without providing the instance name. – MatSnow Nov 17 '17 at 08:33
  • Currently, I have SQL server 2016 so is there any way to change default instance? – abhi Nov 17 '17 at 08:40
  • And I have no idea why it is opening directly 11 version and not 13 – abhi Nov 17 '17 at 08:43