Database Setup

This covers MS SQL Server. For MySQL or Access, see the separate documentation.

1. Install SQL 2005 with the default instance.

2. Apply the latest service pack — for SP1 the file is about 250 MB; search for it on the Microsoft website using the keywords SQL2005 SP1 or KB913090. The file name is SQLServer2005SP1-KB913090-x86-ENU.exe.

3. Configure SQL 2005 to enable Named Pipes and TCP/IP.

Figure — SQL Server Configuration Manager, Client Protocols: Shared Memory (Enabled), TCP/IP (Enabled), Named Pipes (Enabled), VIA (Disabled)

1. Attach the database.

   a. Copy MMIReport.mdf and MMIReport_log.log to c:\SQLData.

   b. Open Microsoft SQL Server Management Studio.

   c. Connect to the server.

   d. Right-click Database and select Attach.

   e. Click Add, browse to c:\SQLData and choose MMIReport.

   f. Click OK through to the end.

2. Create the user.

   a. In Microsoft SQL Server Management Studio,

   b. go to Security → Logins,

   c. right-click Logins and choose New Login,

   d. enter ssuser with the password 1234 (enter both without the quotes).

Figure — Login – New dialog; Login name: ssuser; ● SQL Server authentication; Default database: MMIReport

e. Click OK.

1. Give the user access to the database.

   a. In Microsoft SQL Server Management Studio,

   b. go to Databases → MMIReport → Security → Users,

   c. remove ssuser from this tree if it is already there,

   d. right-click Users and choose New User.

Figure — Database User – New dialog; User name: ssuser; Login name: ssuser; Default schema: dbo; Role membership: ☑ db_owner

e. Click OK.

1. Test logging in as ssuser with its password; the login should complete successfully.

2. If it does not, work through these instructions again alongside the error message.