Link to home
Start Free TrialLog in
Avatar of Todd Naliboff
Todd Naliboff

asked on

Sharepoint 2010 Products Configuration Wizard SQL Error

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
Avatar of Walter Curtis
Walter Curtis
Flag of United States of America image

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
ASKER CERTIFIED SOLUTION
Avatar of Todd Naliboff
Todd Naliboff

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Todd Naliboff
Todd Naliboff

ASKER

Only comment provided by expert was not relevant to solution