x

SQL server 2000 replication information

Hello,

I am creating a server report for sql 2000. I need to get sql port number and sql replication information along with other info like services etc.

i have found other information, but am stuck on the port number and replication.

Can anyone please help me with this by providing a script etc

more ▼

asked Jul 07 at 11:58 AM in Default

avatar image

Tauseef_jan
81 3 4 5

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

1 answer: sort voted first

Hi Tauseef_jan

You can find out the port in use by looking in the error logs, SQL writes everything it sets when starting up. You can open the log to view or query the as follows:

 USE master
 GO
 xp_readerrorlog 0, 1, N'Server is listening on'
 GO

You can also open SQL Server Configuration Manager to view the settings there. It will generally be port 1433 for a default instance but a named instance will be different as it makes use of the browser service, which listens on 1434 by default.

Replication will negotiate over the standard ports, I've never had to change anything for it to work.

https://docs.microsoft.com/en-us/sql/sql-server/install/configure-the-windows-firewall-to-allow-sql-server-access

Hope that helps.

more ▼

answered Jul 07 at 03:05 PM

avatar image

Mart
529 1 6 10

(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.

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:

x377
x3

asked: Jul 07 at 11:58 AM

Seen: 25 times

Last Updated: Jul 07 at 03:05 PM

Copyright 2017 Redgate Software. Privacy Policy