How to add monitoring for specific ports?

oderks · March 28, 2013 6:35AM

Just a question as I seem to oversee seomthing:

We're working with 3.2.0.219.
Now we have a new cluster which is also having SQL Browser service turned off.

How do I add my named instances running on specified ports?

I've tried:
hostname\instancename,portnumber
hostname\instancename:portnumber
hostname\instancename;portnumber

All to no avail.

priyasinha · March 28, 2013 9:50AM

Hello,

You can first add the SQL Server instance using 'machine name\*' syntax. Then select the SQL Server instance which is running on non-default port and click 'Edit Credentials'. Then click 'Edit Properties' on the 'Edit Credentials' windows. You should be able to enter Port number here.

I am not very sure but as far as I am aware, you would need 'SQL Server Browser' service to be running in order to connect to a named instance remotely.

Thanks,
Priya

oderks · March 28, 2013 11:15AM

Found it! Missed the 'edit properties' in there when looking for it.

How to add monitoring for specific ports?

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk