I'm trying to set up WFO on a single VM for our lab system. I've gone through the install guide multiple times, yet Postinstall fails to get past the initial System Database step and throws this error: Schema program failed: Could not run script to update users.
The user "wfo" has all the rights to create DBs and if I look at the SQL server after the error is displayed, I can see the SQMDB has been created.
QM 9.0.1 SR4 ES0
Win 2008 R2
SQL 2008 SP3 Standard default instance MSSQLSERVER
(Also tested SQL 2008 R2 SP1 Express, but made no difference)
Has anyone seen this issue?
Thanks in advance,
Have you tried with full sysadmin privileges? It might be trying to update some system-level permissions for the users it creates on the DB
Can you upload the logs from the install folder in the program files directory?
I see in the logs (postinstall.log/dbg) attempts to connect to various instance names (LAB, SQLEXPRESS) which fail as they don't exist - did you enter these or is the program trying them automatically?
Have you tried leaving the instance name empty?
managed to fix it finally. I have reinstalled the system a few times, so not sure what has been wrong at different stages.
For this last attempt TCP/IP wasn't enabled on SQL Server Express by default, so had to manually enable it and bounce SQL services.
Just for reference, the working scenario:
- SQL Server Express R2, Instance: LAB, TCP/IP manually enabled, SQL Server run as Local System
- QM_901, instance name LAB specified in PostInstall, user account: sa
If you are using the default SQL instance do not fill in the instance name when running post install this fails even if you put in the default instance name.
Came across another error but may be the same so I thought I would share.
In my case I needed to go from SQL Standard to SQL Express. Did the backup, uninstall, re-install, restore. Was getting an unauthorized error... "Cannot load information from DB: org.apache.http.AuthenticationException: AuthenticationFailed: Received 401 Unauthorized." ... See error1.png
Found that TCP/IP (and Named Pipes) were disabled. Enabled them and everything starting working... See tcpip.png