Sharepoint 2010 install tutorial w/SQL (Pt.1)

Installing SQL Server on Windows Server 2008 R2

Windows Server 2008 R2

Add the Application Server role in your server manager. Add the required features if prompted.

Add the Web Server (IIS) role in your server manager.

Add the following role services to the Application Server role:

Add the following role services to the Web Server (IIS) role:

Administrative and Service Accounts

Create the following accounts on the Domain Controller and make them members of the Domain Admins Group.  These accounts will be utilized for configuring SQL Server and when installing SharePoint 2010:

Basic Installation Accounts
Required Account	Example
SQL Server Service Account	sqlSvcAcc
SharePoint Farm Account	spFarmAcc

SQL Server 2008 R2

Now you need to use the SQL Server Service Account (sqlSvcAcc).  Login to the server with the sqlSvcAcc account created earlier and use the password that you created.  Before installing SQL Server you need to make sure that the appropriate user accounts are added to the local administrator account.

Backup files and directories
Debug Programs
Manage auditing and security log

To add the rights to the local administrator account to the above listed security policies, follow these steps:

1. Log on to the computer as a user who has administrative credentials.
2. Click Start, click Run, type Control admintools, and then click OK.
3. Double-click Local Security Policy.
4. In the Local Security Settings dialog box, click Local Policies, double-click User Rights Assignment, and then double-click Backup Files and Directories.
5. In the Backup Files and Directories Properties dialog box, click Add User or Group.
6. In the Select User or Groups dialog box, type the user account that is being used for setup, and then click OK two times. Make sure that the "sqlsvcacc" and "administrators" are listed
7. Repeat the procedure for the other two policies that are mentioned above.
8. On the File menu, click Exit to close the Local Security Settings dialog box.

Now you're ready to install SQL Server

You will need to turn off the firewall settings for "Domain networks".  This will allow the SharePoint server to communicate with the SQL Server later when you get to the SharePoint installation.

When the SQL Server Installation Center menu pops up click on the "Installation" that is listed on the left side.  Then in the right column select "New Installation or add features to an existing installation"

The program goes through  a setup support rules to identify any problems that might occur during the installation.  Once completed go ahead and select "OK" at the bottom.

Click on "Next" at the bottom after you enter the key.

Select I accept the license terms and select "Next".

At the Setup Support Files click on "Install".

Once the Setup Support Rules has been completed you should get a results page with mostly everything passing with the exception of Microsoft .NET Application Security and Windows Firewall giving you a "Warning Status", unless you turned off the firewall settings previously.  You can disregard these warnings.

In the Setup Role, select SQL Server Feature Installation and click "Next".

Install SQL Server using at least the following features:

Keep the default directory settings as they are and select "Next"

The Installation Rules will run again to see if there will be any problems with the installation.  When it has completed go ahead and select "Next".

At the Instance Configuration stage keep all default settings and select "Next".

Select "Next" at the Disk Space Requirements page.

At the Server Configuration page insert the domain name and the sqlSvcAcc account and password like the example below.  In the example the domain name is AGLASER but you would put your domain name in its place.

At the Database Engine Configuration page keep the Windows authentication mode selected and in the Specify SQL Server administrators select "Add Current User" if you are logged in with the sqlSvcAcc account.

Do not send error reports back to Windows so keep it unselected and select "Next".

Select "Next" at the Installation Configuration Rules window.

The Installation Progress does take awhile.

If there are no errors the installation should be completed.

After you have installed SQL Server 2008 you need to add permissions to the sqlSvcAcc account:

Enable TCP/IP if it’s not yet enabled: