Versions Compared

Old Version 1

changes.mady.by.user Nadja Pollard

Saved on

compared with

New Version Current

changes.mady.by.user Nadja Pollard

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 running 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 in this Microsoft KB article.