About the database, Database installation, Working with microsoft sql server 2000 – Welch Allyn Cardioperfect Workstation, Software Version 1.6.5 - Installation Guide User Manual

Page 26: Working with sql server 2005 express, Working with sql server 2008 r2 express

Advertising
background image

CardioPerfect Workstation

DIR 80013928, Ver. F

26 / 56

12. About the database

CPWS can use these database engines:

Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2008 R2 Express

Microsoft SQL Server 2008 and Microsoft SQL Server 2008 Express

Microsoft SQL Server 2005 and Microsoft SQL Server 2005 Express

Microsoft SQL Server 2000

Microsoft SQL Server 7

Microsoft MSDE database (a runtime version of MS SQL Server 7 / 2000)

Note: To use with CardioPerfect, existing SQL Server installations must have mixed-mode

authentication enabled.

Database installation

The database installation process installs the Microsoft MSDE database engine, the Microsoft SQL Server
2005 Express engine, or the Microsoft SQL Server 2008 R2 Express engine depending on your
installation selection, and creates a database named ccdb in an instance named CARDIOPERFECT. This
database contains all information generated by CPWS. A second database called ccdbaudit is installed for
maintaining an audit trail when enabled.

Working with Microsoft SQL Server 2000

To work with CPWS, the database engine must be running. By default, the database engine starts
automatically when you start the computer. However, you can also manually start the SQL server.
1. Click Start and point to Programs.
2. Point to the MSDE (or MSSQL7 or MSDE SQL Server 2000) folder and click Service Manager. The

SQL Server Service Manager appears.

3. From the Services list, select SQLServer.
4. Click Start/Continue to start SQL Server.

You have successfully started the MS SQL Server when the SQL Server Service Manager icon
displays a green triangle instead of a red square.

MS SQL Server is running

MS SQL Server is not running

Working with SQL Server 2005 Express

1. Click Start and point to All Programs.
2. Point to the SQL Server 2005 folder and the Configuration Tools folder and the SQL Configuration

Manager. The SQL Server Configuration Manager appears.

3. From the Services list, double-click SQL Server 2005 Services.
4. Select SQL Server (CARDIOPERFECT), point to the Action button, and click Start.

Working with SQL Server 2008 R2 Express

1. Go to All Apps (Windows 8) or All Programs (Windows 7).
2. Go to the Microsoft SQL Server 2008 R2 Express engine folder and the Configuration Tools folder and

the SQL Server Configuration Manager. The SQL Server Service Manager appears.

3. From the Services list (Items), double-click SQL Server Services.
4. Select SQL Server (CARDIOPERFECT), go to the Action button, and click Start.

Advertising