Two instance of mssql

[Handi]

Two instances of mssql

Hi,

after upgrading from 7.6 to 8.1 we have two instance of mssql
First instance is mssql version 8. second instance is mssql version 9 (SQL express)
If we create a database via plesk, the database is create in the first instance (version 8).

Now I think, something is wrong with the installation. We should have only one instance. We prefer the version 9.

How we can correct this things.

Thank you very much.

Handi

 

[bizstreet]

I found it the same in one of our servers. I did it this way. I would not suggest this if you have many domains though (I did it on a client's personal server with 10 domains)

1) Important !! Take a Plesk backup (Start>Programs>Swsoft>Plesk Backup)

2) Uninstall one of the mssql (from Control Panel>Add/Remove Programs) using the Change>Modify option
3) If the mssql you removed had the databases (if it was the one Plesk was creating the databases), you need to login to Plesk as admin and go to Server>Database and connect Plesk to the new mssql (the one it was not connected to before)
4) the server name for SQL Express is usually not localhost, it should be something like Machine_name/SQLExpress
5) Once it connects (after you put the sa password) remove the database names and usernames from Plesk
6) Finally Restore all the databases from backup