Create databases and database user

In Microsoft SQL Server Management Studio:

1. Right-click databases, and select New Database…

2. In Database name, enter ZyDB, and click OK.

3. Right-click databases, and select New Database…

4. In Database name, enter ZyStatDB, and click OK.

In Microsoft SQL Server Management Studio:

1. Right-click security, and select New > Login…

2. In Login name, enter ZyUser

3. Select SQL Server authentication

4. Clear User must change password at next login, Enforce password expiration, and Enforce password policy

5. Enter the password for MSSQL user ZyUser

6. In Default Language, select English

7. Click User Mapping

8. In Users mapped to this login, select ZyDB

9. In Database role membership for ZyDB, select db_owner

10. In Users mapped to this login, select ZyStatDB

11. In Database role membership for ZyStatDB, select db_owner

12. Click OK