Date: Fri, 29 Mar 2024 11:31:43 +0000 (UTC) Message-ID: <598006461.5731.1711711903799@ip-10-0-1-161.ec2.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_5730_1421897197.1711711903796" ------=_Part_5730_1421897197.1711711903796 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
If you would like to monitor SQL Server with the SQL Server Brow= ser service disabled (for security or other reasons), you must configure yo= ur database to use a static port assignment. If SQL Server is configu= red 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, ens= ure that SQL browser is runnning as it provides the connection information = about the database engine to the the client. If the SQL browser servi= ce 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 th= e database engine.
If the client has been configured to use port 1433 to connect and the da= tabase 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 i= f SQL browser is not running.
Additional details on SQL Server static vs. dynamic port allocation are = available in this Microsoft KB article.