article Is SQL Server Browser service required to monitor MS SQL?

If you would like to monitor SQL Server with the SQL Server Browser service disabled (for security or other reasons), you must configure your database to use a static port assignment.  If SQL Server is configured with static port allocation, an Instance Name value is not required for the SQL Server tablespace monitor to work.

 

If you configure the database engine to use dynamic port allocation, ensure that SQL browser is runnning as it provides the connection information about the database engine to the the client.  If the SQL browser service is not running and you have restarted SQL Server and port 1433 is being used by other applications, a different port number will be allocated to the database engine.

 

If the client has been configured to use port 1433 to connect and the database engine is using a different port number, the client will not be able to get the connection properties to the database engine from SQL browser if SQL browser is not running.

 

Additional details on SQL Server static vs. dynamic port allocation are available in this Microsoft KB article.

Related Articles


Unable to access up.time from a web browser

RatingViews
article

By: uptime Support | Date Created: 10-25-2005 | Last Modified: 7-14-2011 | Index: 030

  3478

Is Performance Monitor Interface required to monitor WebSphere?

RatingViews
article

Yes, up.time utilizes the information provided by pmi in order to produce performance graphs so it is required to be installed on the target WebSphere server.

By: uptime Support | Date Created: 8-20-2010 | Last Modified: 8-10-2011 | Index: 492

  2395

Required Ports for the up.time Monitoring Station

RatingViews
article

By: uptime Support | Date Created: 10-28-2005 | Last Modified: 6-26-2013 | Index: 021

  8594

What ports are required for WMI agentless monitoring?

RatingViews
article

Full details on ports required for WMI remote monitoring can be found on the Microsoft website: http://msdn.microsoft.com/en-us/library/aa389286(VS.85).aspx In addition to this, any up.time...

By: uptime Support | Date Created: 9-10-2010 | Last Modified: 8-13-2011 | Index: 501

  3568

Supported Browsers in up.time

RatingViews
article

A full listing of supported browser versions

By: uptime Support | Date Created: 5-25-2011 | Last Modified: 4-7-2014 | Index: 519

  2542

User Comments



No comments have been posted.

Copyright © 2021 IDERA, Inc.   Legal   Privacy Statement