When you run the SharePoint Products Configuration Wizard for the first time, you get the following error:
System.Data.SqlClient.SqlException: CREATE DATABASE permission denied in database ‘master’.
This means that the domain account you specified to connect to the SQL Server does not have permissions to create the SharePoint config database. So go to your SQL Server and add the dbcreator role to your SharePoint Service account.
Please don’t make the SharePoint Service account elevated to domain admin level in AD or SysAdmin in SQL Server! It’s not necessary!
When installing SharePoint, you have to install prerequisites first. If you launch the SharePoint Prerequisites Installer from the SharePoint setup GUI (clicking the link), you may notice that most prerequisites (like IIS) installs correctly but there are some that wouldn’t install correctly. Some of the errors that I experienced:
- Error: Startup task doesn’t exist. This is not a continuation after a restart.
- Error: This file does not exist
- Error: The tool was unable to install Hotfix for Microsoft Windows (KB976462).
I searched the Web for the errors I got and it seem that a common recommendation is to simply run prerequisiteinstaller.exe from the command-line:
- Open up a command window
- Go to your SharePoint setup location (like D:\ if running from CD drive)
- Enter “prerequisiteinstaller.exe” and then press enter
- A GUI would popup but just go ahead and proceed. It should finish installation.
- Review the log file, located in %DEFAULTUSERPROFILE%\Temp and named PrerequisiteInstaller.[datetime].log. Make sure there are no errors on the latest log file.
If no more errors, proceed with SharePoint 2010 installation.
Posted by: Gabe Hilado in
SharePoint on June 11th, 2010
The hardest part in installing SharePoint 2010 on Windows 7 is the installation process itself and then configuring the Complete installation on a single-server of the SharePoint Config Database while using local accounts. Once the SharePoint Content DB and the SharePoint Admin Content Databases are created, you can now run psconfigui.exe, SharePoint Products Configuration Wizard.
When you run the PSCONFIGUI, since you already configured the SharePoint config database, will start-off at the following step of the Configuration Wizard. Notice that my database-server and database-name have already been pre-populated. Click Next.
SP Configuration Wizard - DB Selection
You get to specify additional information such as Authentication provider (choose NTLM, especially if you do not have domain controller in your network). You can also choose the port number where Central Admin will run.
SharePoint Configuration Wizard -Completing
Click Next until it runs the actual configuration of the Central Admin:
SP Configuration Wizard -Configuring
Once the Wizard is finished, run your Central Admin. If things were installed and configured correctly, you should be able to launch Central Admin:
1st Time in Central Admin 2010
