CORE PC uses SQL Server Authentication to connect to SQL Server. Please ensure that the SQL Server is set to "mixed mode" authentication (RH Click on server in Enterprise Manager > Properties > Security > Server Authentication > "SQL Server and Windows Authentication mode").

CORE PC uses the TCP/IP network protocol to communicate with SQL Server. You should configure any firewall between the client and the server to allow traffic on TCP port 1433 and UDP 1434.

SQL 2000: Use svrnetcn.exe to check TCP/IP network protocol is enabled.

SQL 2005: In SQL Server configuration manager ensure TCP/IP protocol is enabled. In sql server 2005 surface area configuration, choose "surface area configuration for services and connections" and ensure remote connections for TCP/IP are allowed. Ensure the SQL Browser service is enabled and running.

If data is to be moved from an existing workstation please first see Moving data from a Workstation to a dedicated SQL Server

A blank copy of the SQL Server datafiles may be found in the .cab file on the CORE PC CDROM. The files you need are corepc_data.mdf and corepc_log.ldf.

1. Attach the datafiles

Using SQL Server Enterprise Manager connected to the SQL Server in question, expand the server tree, Right-Click on "Databases" > "All Tasks" > "Attach Database". Browse to the "corepc_data.mdf" file, then click on "attach". Set the database name to "corepc", if there is more than one CORE PC database on the SQL Server add a suitable suffix to enable you to differentiate between the databases.

2. Create the SQL Server login

Expand the SQL Server in Enterprise Manager, go to Security > Logins, RH Click and select New Login. Enter the user name in the space provided (the default user name is "corepc"), click "OK" and the server will prompt for a password for the new login. (For the default password used in the CORE PC front-end software, please call the support number - 07814 001498 - as we do not expose the password in any email communications or documentation. )

3. Give the new login ownership of the corepc database

Navigate to Security > Users under the database you created in step 1. Then RH Click on the "corepc" User and select Properties > Database role membership, and check the "db_owner" box. Click OK.

4. Configure Client workstations

See Connecting CORE PC client workstations to the SQL Server

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