Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Sharepoint 2010 Products Configuration Wizard SQL Error

Posted on 2014-03-27
3
Medium Priority
?
590 Views
Last Modified: 2014-04-05
Performing a Sharepoint 2010 in place upgrade of 2007.  Install completes successfully.  When running the SharePoint Products Configuration Wizard, I get the error:

The configuration wizard cannot continue due to insufficient permissions on the database server.  Ensure that the following account <DOMAIN>\<USER> has been assigned the 'dbcreator' and 'securityadmin' roles on the following database server(s).

<SQL SERVER>

I tried the upgrade using a couple of different IDs.  I have checked on the sql server and both IDs have dbcreator and securityadmin roles on the server.

Anybody have an idea.  Kind of stuck
0
Comment
Question by:Todd Naliboff
  • 2
3 Comments
 
LVL 20

Expert Comment

by:Walter Curtis
ID: 39963845
Here are a few standard and basic troubleshooting steps to try:

Check in the log file folder for the most recent PSCDiagnostics_date for errors

Check uls log as well as server event viewer

Often messages are misleading. Is this a possible connection problem between App server and SQL server

SQL Server also have an event viewer. Check that.

If allowed by security, also grant the install user sql role sysadmin.

Hope that helps
0
 

Accepted Solution

by:
Todd Naliboff earned 0 total points
ID: 39967020
0
 

Author Closing Comment

by:Todd Naliboff
ID: 39979859
Only comment provided by expert was not relevant to solution
0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

These days socially coordinated efforts have turned into a critical requirement for enterprises.
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

782 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question