How to disable SQL Browser service without impacting SCSP Server?

book

Article ID: 157014

calendar_today

Updated On:

Products

Critical System Protection

Issue/Introduction

For specific reasons (i.e. internal security policies), you need to disable SQL Browser service on your SQL Server, which hosts SCSP instance/database. However, you noticed SCSP Server cannot work anymore as soon as Browser service is stopped.

The behavior is the same in all scenario:
 - local or remote database
 - static or dynamic port
 - default or customized port

 

sis-server.0.log

[ERROR] [StartupServlet:1] Server initialization has failed!!
java.lang.Exception: Failed to connect to database after trying 20 times, please start the database!!

 

Cause

By default, SCSP will try to connect to SQL Server using UDP port 1434 (http://www.symantec.com/docs/TECH114796), to ask SQL Browser service for the port to use in order to reach SCSP instance (http://msdn.microsoft.com/en-us/library/ms165724(v=sql.90).aspx). Once it is received, SCSP Server will be able to connect to its dedicated instance using proper port.

If you disable Browser service, all SCSP Server attempts to know what is the port to use will fail, and result into connection failure, even if SQL Server is using default port and is installed locally.

 

This connection to 1434 is due to default URL used by SCSP Server, stored into %CSPSERVER%\Tomcat\conf\server.xml. By default, URL used looks like the following:

url="jdbc:jtds:sqlserver://{YOURSQLSERVERNAME.EN_US}/SCSPDB;instance={YOURINSTANCENAME.EN_US}"

 

Resolution

1. Make a copy of server.xml

2. Edit server.xml

3. Replace both URL lines by the following:

url="jdbc:jtds:sqlserver://{YOURSQLSERVERNAME.EN_US}:{SCSPINSTANCEPORT.EN_US}/SCSPDB"

4. Save changes

5. Stop SQL Browser service

6. Restart SCSP Server service

 

To configure SCSP instance port, you can use SQL Server Configuration Manager on SQL Server. It is recommended to use static port to avoid reconfiguring server.xml frequently.

 


Applies To

SCSP 5.2.8.