How to add monitoring for specific ports?

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

How to add monitoring for specific ports?

Postby oderks » Thu Mar 28, 2013 11:35 am

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
 
Posts: 46
Joined: Wed Jul 30, 2008 9:57 am

Postby priyasinha » Thu Mar 28, 2013 2:50 pm

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
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm

Postby oderks » Thu Mar 28, 2013 4:15 pm

Found it! Missed the 'edit properties' in there when looking for it.
oderks
 
Posts: 46
Joined: Wed Jul 30, 2008 9:57 am


Return to SQL Monitor 3

Who is online

Users browsing this forum: No registered users and 0 guests