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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Only comment provided by expert was not relevant to solution
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