April 2, 2009 at 8:35 am
We have SQL Server 2005 Standard edition installed. The instance is a default instance. The port is the default 1433. We want to disable SQL Server Browser. Will clients still be able to access SQL Server ?
April 2, 2009 at 8:41 am
Yes.
http://msdn.microsoft.com/en-us/library/ms165724(SQL.90).aspx
Read full -
"
If the SQL Server Browser service is not running, you can still connect to SQL Server if you provide the correct port number or named pipe. For example, you can connect to the default instance of SQL Server with TCP/IP if it is running on port 1433.
The following connections will not work:
* Any component that tries to connect to a named instance without fully specifying all the parameters, such as the TCP/IP port or a named pipe.
* Any component that generates or passes server or instance information that could later be used by other components to reconnect.
* Connecting to a named instance without providing the port number or pipe. This includes Data Mirroring to a named instance and clustering a named instance.
* Dedicated Administrator Connections to a named instance, or the default instance if not using TCP/IP port 1434.
* The OLAP redirector service.
* Enumerating servers in SQL Server Management Studio, Enterprise Manager, or Query Analyzer.
"
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply