x

Default Port for Mirroring in SQLSERVER

What is the Default Port No for Mirroring in SQL Server

more ▼

asked May 03, 2010 at 06:06 AM in Default

Mohan gravatar image

Mohan
324 39 56 60

(comments are locked)
10|1200 characters needed characters left

4 answers: sort voted first

5022 .

more ▼

answered May 03, 2010 at 06:19 AM

Fatherjack gravatar image

Fatherjack ♦♦
42.8k 75 79 108

Thank you for quick answer
May 03, 2010 at 06:21 AM Mohan
(comments are locked)
10|1200 characters needed characters left
Actually there is no default port for database mirroring endpoint, if we use TSQL to create endpoint, we need to supply the port number. It's the SSMS wizard, which sets port number to 5022.
more ▼

answered Apr 17, 2013 at 09:16 AM

ChintakChhapia gravatar image

ChintakChhapia
0

(comments are locked)
10|1200 characters needed characters left

What is the exact answer. Does database mirroring has any default port or only while using SSMS wizard default listener port no is 5022. I am getting confused with this answers. Please someone resolve this query.

I think SQL SERVER database mirroring does not have any default port, it is the adminstrator who decides the port no.

Thanks and Regards, Pankaj Kota
more ▼

answered Dec 02, 2013 at 08:42 AM

pankaj.kota gravatar image

pankaj.kota
80 3 5 6

(comments are locked)
10|1200 characters needed characters left

5022 is default port number for mirroring in sql server

more ▼

answered May 03, 2010 at 07:27 AM

sari gravatar image

sari
51 1 2 4

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1951
x57
x5

asked: May 03, 2010 at 06:06 AM

Seen: 5300 times

Last Updated: Dec 02, 2013 at 08:42 AM