Solved

Sharepoint 2010 Products Configuration Wizard SQL Error

Posted on 2014-03-27
3
573 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 18

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

Forrester Webinar: xMatters Delivers 261% ROI

Guest speaker Dean Davison, Forrester Principal Consultant, explains how a Fortune 500 communication company using xMatters found these results: Achieved a 261% ROI, Experienced $753,280 in net present value benefits over 3 years and Reduced MTTR by 91% for tier 1 incidents.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
EF5: Update Model from Database not working 3 83
User Folder Creation and Permissions 3 49
What does "Between" mean? 6 49
Active Directory Replication 1 27
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
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 locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

710 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