SP 2010 Installation Part (12) – SQL Server Configuration

This Post is part of  SharePoint 2010 Installation Series

Assign Permissions

Setup Admin and Fo-Dev-07-SP-Farm accounts must be assign the following roles in the sql server : dbcreator and securityadmin.

Open Start, Programs, Sql Server Management Studio

  1. Connect to your Server Instance my case ( FO-DEVELOPER-07\GEMINIBI )
  2. Pen the security / logins node
  3. Located the Admin account if doesn’t exist create it
  4. Right click properties / Server Roles
  5. Check Security admin and dbcreator
  6. Click ok
  7. And then restart your server


Configure networking

At the end you need to configure networking if you are planning to deploy a farm with multiple SharePoint Server 2010 servers.

According to TechNet [1] you need to "ensure that SQL Server 2005 or SQL Server 2008 is updated to the required level and configured as follows":

SQL Server 2005: Local and remote connections are enabled and are configured to use the TCP/IP protocol.

SQL Server 2008: The TCP/IP protocol is enabled for the network configuration.

Digg This
Reddit This
Stumble Now!
Buzz This
Vote on DZone
Share on Facebook
Bookmark this on Delicious
Kick It on DotNetKicks.com
Shout it
Share on LinkedIn
Bookmark this on Technorati
Post on Twitter
Google Buzz (aka. Google Reader)

 

View Abdel-Rahman Awad's profile on LinkedIn

Archives

 

Rss Feed Tweeter button Facebook button Linkedin button Delicious button Digg button