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
asked Jul 07, 2017 at 11:58 AM in Default
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:
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.
Hope that helps.
answered Jul 07, 2017 at 03:05 PM