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 v2 from the CDROM using the "Typical" option. Make sure the installation is complete by starting CORE PC, allowing it to configure the SQL Server. Once that's done run CORE PC again and either the login screen will appear, or the users will be prompted to enter their license details. Do not enter any license details at this stage just close out of CORE PC.

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. 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 any firewall to allow TCP port 1433 and UDP 1434.

2. Configure Client workstations

Follow the instructions for connecting client workstations to server

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