multiple instance on same server?

Question

Post reply

multiple instance on same server?

SQL Galaxy

One Orange Chip

Points: 29472
More actions
August 5, 2012 at 10:59 pm

#279234

Hi,
First I had installed one SQL 2K8 with default instance on server,
I need installed one more named instance on that server, Is it possible?
thanks
ananda

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

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

Dhirju SSCrazy Points: 2018 More actions · Answer 1

Dhirju

SSCrazy

Points: 2018

August 5, 2012 at 11:11 pm

#1521817

Yes.

Robin Sasson Hall of Fame Points: 3359 More actions · Answer 2

Yes you can. I have 3 instances on my development PC.

To connect to an instance in SSMS, use ServerName\InstanceName

:exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation:

SQL Galaxy One Orange Chip Points: 29472 More actions · Answer 3

yes. I have installed named instance on same server which was already installed default instance MSSQLSEVER on that server.

After installed Both instances are connected with SSMS.

Default Instance - sllways connect default TCP/IP port 1433.

Named Instance - allways connect UDP port 1434

both are managed by SQL Browsing services.

Configuration manager->Network configuration -> TCP/IP protocol

Physical IP concfigured at IP2 and then UDP Port number not available. it showing such as use dynamic port - 0., IPAll column showing dynamic port -64954.

thanks

SQL Galaxy One Orange Chip Points: 29472 More actions · Answer 4

In Default instance showing like this

USE master

GO

xp_readerrorlog 0, 1, N'Server is listening on', 'any', NULL, NULL, N'asc'

GO

Server is listening on [ 'any' <ipv6> 1433].

Server is listening on [ 'any' <ipv4> 1433].

Server is listening on [ 'any' <ipv6> 1434].

Server is listening on [ 'any' <ipv4> 1434].

Named Instance showing like this

Server is listening on [ 'any' <ipv6> 64954].

Server is listening on [ 'any' <ipv4> 64954].

But here named instance not using UDP port 1434

thanks

Ant-Green SSC Guru Points: 113507 More actions · Answer 5

No it wont use UDP 1434, thats the browser port.

The whole part of the browser is that it diverts the traffic to the correct ports, so you dont need to worry about it, as your not always going to get the same port for the same instance, they are dynamic, unless you configure it otherwise.