Configure SQL Server 2005 for umbraco

Install and setup
A step-by-step guide to install and configure everything you need to run umbraco 3.0 on Windows Server 2003 with SQL Server 2005.

Chapters

• Chapter 1: Introduction
• Chapter 2: Configure SQL Server 2005 for umbraco
• Chapter 3: Install umbraco 3.0 Files
• Chapter 4: Configure IIS for umbraco
• Chapter 5: Configure umbraco 3.0
• Chapter 6: Congratulations!

Configure SQL Server 2005 for umbraco

SQL Server Management Studio

1. Click Start, click All Programs, click Microsoft SQL Server 2005, and click SQL Server Management Studio.
2. Connect to the database server with an account that has sufficient permissions to create a new database. Contact your database system administrator if you are unsure how to log in.
   
3. Click Connect.
4. Right-click on the Databases folder, and select New Database.
   
5. Enter a Database name.
   (we’ll use ‘umbracoCMS’ in these instructions)
6. Leave the Owner as <default>.
   
7. Click OK.
8. Expand the Security folder.
9. Right-click on the Logins folder, and select New Login.
   
10. Select the General page:
1. Enter a Login name.
   (we’ll use ‘umbracoUser’ in these instructions)
2. Select the radio button next to “SQL Server authentication”, and enter and confirm a Password.
3. Remove the check mark in the box next to “Enforce password policy”.
   (note: this is optional and should not be done in a production environment)
   
11. Select the User Mapping page:
1. Place a check mark in the box next to the Database you created.
   (‘umbracoCMS’ in these instructions)
2. Place a check mark in the boxes next to the following Database role memberships:
   db_datareader
   db_datawriter
   db_owner
   public
   
3. Click OK.
12. Right-click on the root server folder (the parent of Databases, Security, etc.), and select Properties.
    
13. Select the Security page:
1. Select the radio button next to “SQL Server and Windows Authentication mode”.
   
2. Click OK.

Test the configuration by disconnecting and logging in as the user you just created.

1. Click File, click Disconnect Object Explorer.
2. Click File, click Connect Object Explorer.
3. Select SQL Server Authentication, enter the name of the login user you create (‘umbracoUser’ in these instructions), and type the password you specified when you created the login user, above..
   
4. Click Options.
5. Select the Connections Properties tab.
6. Select TCP/IP as the Network Protocol.
   
7. Click Connect.

If you cannot log in with SQL Server authentication…

• Check the log files after a failed attempt.
• The default log location is C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG and can be opened with Notepad.
• Look for an entry in the ERRORLOG such as:
  2007-05-16 16:43:42.75 Logon Error: 18456, Severity: 14, State: 8.
• “State: 8” indicates a problem with the user password.
• You can find a list of the meaning of each state message at
  http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx