How to create a Zed Office database on Microsoft SQL 2005

Follow these steps to create a new Zed Office database when setting up Zed Office for self hosting

On your database server install Microsoft SQL database and management studio

1. Download and install Microsoft SQL 2005
2. Download and install Microsoft SQL Management Studio Express

Open Microsoft SQL Management Studio Express

1. Authentication = Windows Authentication

Create a new login for the Zed Office database

1. Right click the Security folder in the Object Explorer and select New Login
2. Enter a login name “zedoffice”
3. Select the SQL Server Authentication
4. Uncheck the Enforce Password Policy
5. Create a password and confirm that.

Create a Zed Office database

1. Right click on the Database Folder
2. Click New Database
3. Enter a database name as “zedoffice”
4. Click the Browse button to Select the Database Owner and select the “zedoffice” user you created above. 
5. Right click on the zedoffice database and select New Query
6. Copy of the contents of the new database script into the window and click Execute