CIRCUTOR SQL Data Export - Manual (Page 15)

SQL Data Export for PS/PSS
15
2. Activate the SQL Server browser service.
- Click on “Start  Programs  Microsoft SQL Server 2005 
Configuration Tools  SQL Server surface configuration”.
- In Surface configuration of SQL Server, select the surface
configuration option for services and connections.
- Expand the option SQL Server Browser and select automatic start
mode, apply the changes and click on Start.
3. Configure the Windows firewall (this step is usually not necessary)
- Create an exception for SQL Server:
1. In Windows Firewall, click on the exceptions tab and then click on
Add program.
2. In the Add program window, click on Browse.
3. Locate the “…\MSSQL.X\MSSQL\Binn\sqlservr.exe” executable
program in the folder where MS SQL Server is installed, click
Open, then click OK.
4. Repeat steps 1 to 3 for each instance of SQL Server 2005 that
requires an exception.
- Create an exception for SQL Server Browser:
1. In Windows Firewall, click on the exceptions tab and then click on
Add program.
2. In the Add program window, click on Browse.