Solved

Sharepoint 2010 Products Configuration Wizard SQL Error

Posted on 2014-03-27
3
563 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 16

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
A procedure for exporting installed hotfix details of remote computers using powershell
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…

816 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now