The following document is an attempt to provide simple, convenient settings to ensure Workstation to Server connectivity for the GlasPac LX application.
Configuring the server under Windows 7 to allow for connections from remote workstations requires configuring three system components.
- SQL Server 2005 Configuration
- Windows Firewall
- File sharing and Security Settings
SQL Server Configuration
SQL Server must be configured to support Named Pipes and TCP/IP Connections to the Database from remote clients. These configuration changes are made in the SQL Server Manager application in All Programs > Microsoft SQL Server 2005. Make sure all the clients are logged out of GlasPac LX before proceeding.
- Enable Named Pipes. This is accomplished by expanding SQL Server 2005 Network Configuration in the left pane. Selecting Protocols for GTS. Then enabling Named Pipes in the right pane by right clicking and selecting enable.
- Configure TCP/IP Connections. Enable TCP/IP if it isn’t. Right click on the line and select enable. Then, right click again and select properties for TCP/IP.
- Ensure the SQL Server and SQL Browser services Run As a LocalSystem You can do this right within the SQL Server Manager by selecting SQL Server 2005 Services from the left panel. Right click on the SQL serice and select Properties. There is a Run As drop down menu.
- When complete with the above, restart the SQL Service. Right click on the SQL Server (GTS) process and select restart.
Windows Firewall Settings
Set the Firewall on the server to allow the SQL Server executable access inbound access. This is an application exception. In additional, manually add Ports 1433-1434 TCP and UDP to cover MSDE installs and the SQL Browser. Adding the specific ports requires setting up two Inbound Rules in Advanced Settings in the Windows Firewall control panel.
- Add an exception for the SQL Server process by finding the executable.
- Open the Windows Firewall Control Panel. Select the option to Allow a program or feature through Windows firewall from the left side of the window.
- B. In the subsequent window, select Allow Another Program button at the bottom of the window.
- C. In the Add a Program window click on the Browse… button at the bottom and navigate to one of the following locations and Open the sqlsevr.exe executable.
C:\Program Files\Microsoft SQL Server\MSSQL.1\Binn\
C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\Binn\
- Enable the SQL Server for connections from all networks.
- Create Inbound Rule by selecting Inbound Rules from the left panel of the Advanced Settings window. Then select New Rule from the far right panel. Walk through the Wizard setting it to Allow ports 1433-1434 TCP and then selecting a name like SQL_TCP. Repeat for 1433-1434 and UDP with an example name like SQL_UDP.