Can't upgrade V7 to V8
Jeff_Landers
Customer IT Monkey ✭
We have successfully upgraded our Version 7 portal to Version 8 but V7 to V8 is problematic in our test environment.
The user running is install is a domain admin on the SM box and the Cireson portal box and is dbo on the SM and Cireson database. Since we are on version 7, we went through the uninstall procedure EXCEPT for deleting the Cireson Database (is that the problem?). We select Install Database since the warning box says to do that even if upgrading. However, we are getting this error. Can someone help?
Jeff
0/16/2017 10:11:39 AM Replacing content in: InstallationFiles\DBScripts\ServiceManagement-Temp.sql
10/16/2017 10:11:39 AM Attempting to create ServiceManagement Database
10/16/2017 10:11:49 AM Failed to create management database ServiceManagement2 on cohntcs33\mssqlcm : Changes to the state or options of database 'ServiceManagement2' cannot be made at this time. The database is in single-user mode, and a user is currently connected to it.
ALTER DATABASE statement failed.
10/16/2017 10:11:49 AM Failed to create management database ServiceManagement2 on cohntcs33\mssqlcm : Changes to the state or options of database 'ServiceManagement2' cannot be made at this time. The database is in single-user mode, and a user is currently connected to it.
Best Answer
-
Options
Martin_Blomgren
Customer Ninja IT Monkey ✭✭✭✭
The user installing must be local administrator on the server where you are installing the Cireson portal AND sysadmin on the SQL instance where the database resides.
5
Answers
Can you please go to Add/Remove Programs and uninstall the entry "Cireson Setup". This will not uninstall the existing portal - it only removes the old installation files. Once that's done, go back to the beginning of installing version 8 (make sure the file you download is Unblocked in Properties) and run the installer again. It should download version 8 fresh.
Alternatively, you can try stopping the Cireson Cachebuilder and Platform Host services and stopping the IIS Site and see if you are still having an issue with the single user problem.
Regards, Tony
Tony, Thank you for your reply.
Just to be clear, we have followed the uninstall document which removes all IIS entries, uninstalls the cache builder service, deletes the inetpub/cireson folder, removes the mgmt packs, and would remove Cireson from add/remove programs but it has never appeared there even on our functional Version 8 portal. In addition, since this is an offline install, we browse to the install files, and copy them to the server so there is no unblock. Something just doesn't make sense with what should be a clean install except for updating the databases. What are we missing?
Thank you, Jeff
Removing the database does remove things like favourite requests, KB articles and dashboards, so if that's not something you want to do, then you could try this:
dbo isn't enough you must be sysadmin to be able to deploy the dacpac, as stated in the install kb.
Martin,
Our bad. I assumed that since the database was installed we would not need sysadmin on the SQL box. Can you clarify the "administrator on the local box" please? Is that local admin on the cireson portal box, sql box, or both. Thank you for you help.
Important note: Make sure that the logged in user that you are running the installer as is a sysadmin on the SQL Server where the ServiceManagement database will be installed, as well as an administrator for the local machine.