You are here: CORE PC Support Home > CORE PC V2 Client Server Configuration > Configuring a workstation as a CORE PC database server

Configuring a workstation as a CORE PC database server

If you have upto 10 client workstations (or a dedicated central SQL Server is not available) you can configure one of your workstations to act as the CORE PC server.

When chosing which workstation you'd like to act as the server, take the following into consideration

1. The server will need to be switched on for client workstations to access the data
2. Since all the data will be held on this one workstation it should be in a physically secure location. Ideally not in a publicly accessible part of your office.
3. Since all CORE PC users will be requesting data from the server workstation it should be as fast and reliable a machine as possible.

1. Install the server workstation

a. Install CORE PC using the "Typical" option. Following the instructions provided.

b. For Windows XP: On the database server run svrnetcn.exe to enable TCP/IP network protocol.
For Windows 7 or Vista: Run "SQL Server Configuration Manager" (Start > Programs > SQL Server 2005), under SQL Server 2005 Network Configuration > Protocols, ensure TCP/IP protocol is enabled. Also under "SQL Server 2005 Services" ensure that the SQL Browser service is running and set to automatically start. Then run "SQL Server Surface Area Configuration", choose "surface area configuration for services and connections" and ensure remote connections for TCP/IP are allowed.

c. Configure firewall
For Windows XP: allow TCP port 1433 and UDP 1434.
For Windows 7: allow connections to the program C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe and C:\Program Files\Microsoft SQL Server\90\shared\sqlbrowser.exe
For 64bit operating systems replace "Program Files" with "Program Files(x86)"

2. Configure Client workstations

Follow the instructions for connecting client workstations to server

 

For additional Support Information, please call CORE PC Support on 01788297130, or email support@coreims.co.uk