by dotnetpete
8. December 2008 15:04
A few of our clients have only 1 or 2 PCs (no server) and as our apps all use SQL Server as a backend data store I have often attempted to configure the firewall to allow SQLServer traffic. And failed. I decided to find out the correct way to do it the other day.
1. Add an exception for C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlserver.exe. Assuming the first instance and installed on the C Drive.
2. Add an exception for C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe.
3. Ensure that the sql browser service is started and set to start automatically.
4. Via Surface Area Configuration for Services and Connections, allow local and remote connections.
That's it! Pretty easy and logical in the end.
Subscribe