You are here: CORE PC Support Home > CORE PC V2 Client Server Configuration > Configuring a dedicated SQL Server for use with CORE PC

Configuring a dedicated SQL Server for use with CORE PC

CORE PC v2 client will work with any edition of SQL Server 2000 or newer.

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. For Windows Server 2003 and newer you should configure any firewall between the client and the server to allow traffic on TCP port 1433 and UDP 1434. For Windows 7 you should add a firewall rule allowing connections to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe (note your instance number for MSSQL may vary e.g MSSQL.1 or MSSQL.2 etc) and C:\Program Files\Microsoft SQL Server\90\shared\sqlbrowser.exe (note for 64bit operating systems replace "Program Files" with "Program Files(x86)")

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

SQL 2005 and up: In SQL Server configuration manager ensure TCP/IP protocol is enabled. In SQL Server 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 requested by emailing support@coreims.co.uk or by installing CORE PC and retrieving the data files from the c:\program files\coreims\corepc2\database directory. 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. (You can use a password of your choive but for convenience you may want to use the default password used in the CORE PC client software, which can be requested by calling 01788 297130

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