Don’t use the SQL Browser service.


The SQL Browser service is not required to use SQL Server. You may recall that it was the target of the attackers. Turning off this service eliminates possible attacks.

How SQL Browser works

SQL Server Browser listens for all incoming requests for SQL Server and provides info about SQL Server instances installed on the PC.

  • Browsing a list of all servers
  • Connecting to the correct instance

For Database Engine and SSAS, the SQL Server Browser service provides instance name & the version number. SQL Server Browser can be configured using SQL Server Configuration Manager or during a setup. By default, the SQL Server Browser service starts automatically.

More info about starting & stopping the SQL Server Browser service, http://msdn.microsoft.com/en-us/library/ms189093.aspx

If the SQL Server Browser service is not running, you are able to connect to SQL Server if you have the correct port number. If you are using SQL Server in a client-server when your application is accessing SQL Server across a network, if you stop the SQL Server Browser service, you must assign a specific port number to each instance and write to your application code to always use that port number.

Advertisements

About Buja Atdhe

CEO of the platform
Gallery | This entry was posted in Personal Blogs, SQL Server 2008 and tagged , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s