Solved

Sharepoint 2010 Products Configuration Wizard SQL Error

Posted on 2014-03-27
3
558 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 14

Expert Comment

by:SneekCo
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

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
OfficeMate Freezes on login or does not load after login credentials are input.
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
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…

746 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

12 Experts available now in Live!

Get 1:1 Help Now