Create user: WordPressUser
- Access SQL Server 2008 Management Studio
- Connect to the database server
- Go to:
- Security > Logins
- Create new user: WordPressUser
- Select SQL Server Authentication
- Untick: Enforce password expiration
- Accept defaults
- Click OK button
Create database: wordpress
- Go to: Database > wordpress
- Add WordPressUser as Owner of wordpress database
Install: SQL Server Native Client
- Download Web Platform Installer from website, go to: http://www.microsoft.com/web/downloads/platform.aspx
- Locate: SQL Server Native Client
- Install this as well