MS SQL Server Monitor

Question

MS SQL Server Monitor

Guy Peay

Grasshopper

Points: 17
More actions
September 14, 2010 at 9:41 am

#226879

I have been mandated to active MS SQL Server monitor on a certain port for security reasons but am not familiar with where it is. I tried looking in Configuration manager and surface configuration manager and can't seem to find it. Any help you could give me would be great.

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

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

Lowell SSC Guru Points: 323547 More actions · Answer 1

for SQL 2005, you'll need to open the SQL Server Configuration Manager, i think:(not the Surface Area Config)

from there, you can assign which port the instance will listen to in the future; i think it requires a start and stop, but I'm not sure on that part...i've only rarely done it.

In SQL 2008, I beleive you right click on the server in SSMS object explorer and chose "Facets" to find the equivilent screen.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Guy Peay Grasshopper Points: 17 More actions · Answer 2

Thanks I am familiar with that section but how do I configure the monitor? I guess based on your diagram, do I choose a certain port and the monitor will listen on that port will the SQL Server instance will function on the other (sorry if this is poorly asked)?

Derrick Smith SSChampion Points: 10833 More actions · Answer 3

When you say SQL Server Monitor..do you mean the Listener? As in the port it uses for incoming connections? The only Monitor I know of would be a replication or mirroring monitor, which doesn't sound like what you're referring to.

Lowell SSC Guru Points: 323547 More actions · Answer 4

i took the question about "ports" and "monitor" to be:

how do i tell SQL Server which specific port to listen to...

so if i wanted to make SQL server listen to port 44143 as a security precaution, how/where do i change that.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!