i) a manually configured, dedicated SQL Server.

or

ii) a workstation that has been installed from the CORE PC CDROM using the "Typical" option.

If firewall software is present on the server or firewall hardware is in place between the clients and the server you may need to configure it to allow any client PCs to access to the TCP port 1433 and UDP port 1434 on the server.

1. Installing CORE PC on the client workstation

CORE PC client installations should be installed using the "Custom" or "Network Client" setup from the CDROM. (Do not re-tick the "Server" option)

To connect to an SQL Server on another machine, CORE PC Client PCs will require the following networking components installed on the network adapter that it uses to connect to the server; Internet Protocol (TCP/IP), File and printer sharing for Microsoft Networks and Client for Microsoft Networks. This are usually present by default but may have been removed if your network is Novell based.

2. Enter connection information

On first running CORE PC you will be prompted to enter details to connect to the SQL Server, Click OK and the red "DB Owner Connection Info" window will open, enter the connection information;

SQL Server Name (WINS / NETBIOS / DNS name or Static IP address of the server)
Database Name
User Name
Password

Enter the correct details and Click OK

NOTES

1.If your server was configured by installing from the CORE PC CD using the "Typical" option you should leave the auto-completed values for Database Name, User Name and Password.

2.If you have in the past moved data between workstations you should change the User Name to sa

3.If you are using a dedicated SQL Server your database administrator should be able to provide you with the correct connection information.

3. Test the connection to the server from the CORE PC client workstation

Run CORE PC again to test the connection to the server, then either

a) a login screen will appear prompting for a CORE PC User Name / Password (the default values are given in the original printed install documentation, if you do not have this document please call us on the support no 07814001498)

or

b) the system will immediately ask for license details.

4. Problems Connecting to the Server

If the connection cannot be made the "CORE PC could not find database corepc on server local" error will appear. To re-enter the connection information click on "OK" to the error message and then quickly click on the "connection" button that appears at the bottom right-hand corner of the splash screen behind it. (Note: each time the connection info screen appears it will return the default settings; Server Name: corepc Datebase Name: corepc etc).

If the details are entered correctly and the client still won't connect try the following troubleshooting steps:

a.Check the server is accessible from the client via IP address and/or Net BIOS name, using ping, or by setting up a test ODBC connection on the client.

b.Check SQL Server service is running on the server is running and is set to start automatically.

c.On the database server use svrnetcn.exe to ensure TCP/IP network protocol is enabled, on the clients use cliconfg.exe to ensure TCP/IP network protocol is enabled.

d.Check any firewalls on the client, server or anywhere between the two allow traffic on TCP port 1433 and UDP 1434.

5. Entering License Details

Email the Product ID (shown in the "Enter License Information" window) for the client workstation(s) in question to support@coreims.co.uk along with the name of the licensee / head of service. Please also send a contact number so we can contact you if we require any further information.

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