SQL Express Configuration Issue
You can manually configure SQL Express and the Windows Firewall to allow remote access. Use the following steps to enable remote access to SQL Express:
- Open the SQL Server Configuration Manager by clicking Start, All Programs, Microsoft SQL Server 2005, Configuration Tools, SQL Server Configuration Manager.
- In the left pane of the SQL Server Configuration Manger, expand the node for SQL Server 2005 Network Configuration and select Protocols for SQLEXPRESS.
- In the right pane, right-click Named Pipes and choose Enable.
- Right-click TCIP/IP and choose Enable.
- In the left pane, select SQL Server 2005 Services.
- In the right pane, right-click SQL Server Browser and choose Properties.
- Click the Services tab in the Properties dialog box.
- On the Services page, set the Start Mode property to Automatic and click OK.
- Right-click SQL Server Browser and choose Start.
- Right-click SQL Server (SQLEXPRESS) and choose Restart.
Use the following steps to configure the Windows Firewall:
- Open the Windows Firewall dialog box and click the Exceptions tab.
- Click Add Program and Browse to find sqlbrowser.exe and click OK.
- Click Add Program and Browse to find sqlservr.exe. Click OK.
- Click Add Port and enter “SQL Service” for Name, 1433 for Port number, and select the TCP radio button.
- Click OK on the Windows Firewall dialog.