You are here: CORE PC Support Home > CORE PC V2 Client Server Configuration > Connecting CORE PC client workstations to the SQL Server

Connecting CORE PC client workstations to the SQL Server

Additional client workstations can be configured to connect to either

i) a manually configured, dedicated SQL Server.

or

ii) a workstation that has been installed from the CORE PC installer 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 SQL server.

For Windows XP: add rules to allow inbound connections to the TCP port 1433 and UDP port 1434 on the server.
For Windows 7: add rule to allow indound 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)"

1. Installing CORE PC on the client workstation

CORE PC client installations should be installed using the "Custom" or "Network Client" setup.

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

If your server was setup automatically by CORE PC you only need change the server name to either computername (for installations using 2.63 or earlier) or computername\corepc (for installations using later versions) (where computername is the name of the computer that is acting as the database server) and leaving all the other values as their defaults. To find the name of the server computer right click the "My Computer" icon or the "Computer" menu item in the main menu, and click Properties.

Enter the correct details and Click OK

NOTES

1.If your server was configured by installing from the CORE PC installer 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 01788297130)

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.

e.If using a SQL named instance (for example SQL Express), ensure the SQL Browser service is enabled and running.

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 01788 297130, or email support@coreims.co.uk