How can we help you today? How can we help you today?

How to add monitoring for specific ports?

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.
oderks
0

Comments

2 comments

Sort by
  • priyasinha
    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
    priyasinha
    0
  • oderks
    Found it! Missed the 'edit properties' in there when looking for it.
    oderks
    0

Add comment

Please sign in to leave a comment.