Microsoft SQL Server 2008 R2 Express Edition

See SQL Server 2005 Express Edition for more information about SQL Server Express Editions.

Installing SQL Server 2008 R2 Express Edition

1. Download SQL Server 2008 R2 with Service Pack 2 Express Edition. Choose the version that suits you (32- or 64-bit).

2. By default the current user will be added as a SQL Server administrator. It is suggested the Administrators group also be added (or Domain Admins, as appropriate).

3. Apply the latest service pack.

4. Install Windows Management Framework Core (includes PowerShell 2.0) and Microsoft SQL Server 2008 R2 Management Studio Express.

Configuring SQL Server 2008 R2 Express Edition

Run the SQL Server Configuration Manager from Start → Programs → Microsoft SQL Server 2008 R2 → Configuration Tools:

1. In the left pane, click SQL Server Network Configuration.

2. In the right pane, double-click Protocols for SQLEXPRESS.

3. Right-click TCP/IP and choose Enable.

   You will receive a message that changes are saved but will not take effect until the service is restarted.

4. Double-click TCP/IP.

5. Click the IP Addresses tab.

6. Under IPAll, set TCP Dynamic Ports to blank and TCP Port to 1433.

   Alternatively, if you have a special requirement, set the parameters as desired.

7. Click OK.

   You will receive a message that changes are saved but will not take effect until the service is restarted.

8. In the left pane, click SQL Server Services.

9. In the right pane, right-click SQL Server (SQLEXPRESS) and choose Restart.

Restoring a Database Backup

1. Copy the database backup file to a local drive. (SQL Server cannot restore databases from network drives and usually not from removable drives.)

2. Open SQL Server Management Studio Express from Start → Programs → Microsoft SQL Server 2008 R2.

3. Enter <COMPUTERNAME>\SQLEXPRESS as the Server Name and click Connect.

4. In the left pane, right-click Databases and choose Restore Database.

5. Choose From Device and click the browser button […].

6. In the Specify Backup dialog, click Add and choose the database backup file.

7. Click OK.

   The database backup details will be shown.

8. Place a tick next to the backup by clicking the box in Restore column.

9. In To Database, choose the name of the database to restore into from the drop-down list, or enter a new name (eg. CadzowDB).

10. If you wish to put the database files into a non-default location, click Options in the left pane, and change the filenames for the database and the log file.

11. Click OK.

    The database file will be restored.

Configuring Cadzow 2000

By default SQL Server 2008 R2 Express Edition is installed as an “instance”, so the format for the Cadzow 2000 GO.BAT script is:

SET CADZOWDATA=SQL;CadzowDB;Server\SQLEXPRESS;1433

Substitute your database name, server name (or address) and port number as required.