Simple, flexible product lifecycle management software for growing companies™
Simple, flexible product lifecycle management software for growing companies™
The SQL Server Browser service lets users connect to instances of the SQL Server database engine that are not listening on port 1433 (which may occur, for example, if another named SQL Server instance has been previously installed). Depending on your Windows configuration, you may need to open UDP port 1434 to expose the SQL Server Browser service.
Go to Windows Start menu, select Control Panel, then open Security Center.
Near the bottom of the window (XP) or along the left side (Vista/7), click Windows Firewall.
In Vista/Windows 7, you'll then click on the Allow a program through Windows Firewall link along the left side of the Windows Firewall window.
You may see that SQL Server Browser is already listed, but it may not be selected as an exception. Mark the check box to enable the 1434 port for UDP requests.
More likely, you will not see any reference to SQL Server Browser. In this case, perform these steps:
Click Add Port, which opens the Add a Port dialog
Type SQL Server Browser in the Name text box.
Type 1434 in the Port number text box.
Select UDP as the protocol.
Click the OK button to add to the list of open ports.
3009-100516.2113