CODEWITHSUNDEEP
sql-server
user9864738
user9864738

Reputation: 27

Finding the IP address and port of local SQL Server Express

I followed this documentation and I am not not sure what my IP address and port number of my local SQL Server is. I enabled TCP/IP for ip4 for SQL Server Express, and restarted the service in SQL Server Configuration Manager. I can ping my local IP which is 127.0.0.1 but I don't know my port number.

Upvotes: 1

Views: 4881

Answers (1)

Ilyes
Ilyes

Reputation: 14928

For the IP address it's your machine IP address.

To get the ports which the server listening on run this query:

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

Upvotes: 3

Related Questions