Sql connection with port number

Question

Sql connection with port number

PRAMANA.DBA

SSCertifiable

Points: 5507
More actions
November 19, 2013 at 3:15 am

#286435

Hi all,
In My machine i have two instances i.e. one is default and named instance ,
How i can connect named instance by using port number
named instance name : dbagroup\sql2012 ; prot number 1434
default instance name : dbagroup ; port number 1433

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 1

PRR.DB (11/19/2013)
Hi all,
In My machine i have two instances i.e. one is default and named instance ,
How i can connect named instance by using port number
named instance name : dbagroup\sql2012 ; prot number 1434
default instance name : dbagroup ; port number 1433

From where you going to connect it. SSMS or APP?

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 2

Using SSMS:

dbagroup,portnumber (add a comma between)

Make sure the TCP/IP protocol is enabled.

edit: instance name is not needed

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

sqlmunkee SSCommitted Points: 1949 More actions · Answer 3

Do you really need the instance name and the port number ?

I've always used (for an instance on port 666):

Servername,666 not servername\instancename,666

..or is it special for SQL 2012 ?

[font="Courier New"]sqlmunkee[/font]
[font="Courier New"]Bringing joy and happiness via SQL Server since 1998[/font]

PRAMANA.DBA SSCertifiable Points: 5507 More actions · Answer 4

muthukkumaran Kaliyamoorthy (11/19/2013)
PRR.DB (11/19/2013)
Hi all,
In My machine i have two instances i.e. one is default and named instance ,
How i can connect named instance by using port number
named instance name : dbagroup\sql2012 ; prot number 1434
default instance name : dbagroup ; port number 1433
From where you going to connect it. SSMS or APP?

I am connecting from ssms

As per above comments , i used this one sqldba,1434 so it is connected.

Perry Whittle SSC Guru Points: 234013 More actions · Answer 5

sqlmunkee (11/19/2013)
Do you really need the instance name and the port number ?

No, you dont.

use either

server\instancename

server, portnumber

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉