Product:
Search Type:

[FIX] Cannot switch Plesk Database Provider to MSSQL

Article ID: 3603 
Last Review: Feb,06 2008
APPLIES TO:
  • Plesk 8.3 for Windows

SYMPTOMS

When I try to switch Plesk Database Provider to MSSQL, I specify SQL server admin name different from 'sa'.
Reconfigurator doesn't switch database and the following record arrives in the Plesk Event Log:


Event Type:     Error

Event Source:   Plesk Reconfigurator

Event Category: None

Event ID:       0

Date:           1/8/2008

Time:           5:54:45 AM

User:           N/A

Computer:       VW2003H

Description:

System.Exception: Login failed for user 'admin2'.

   at (VADOConnection::open line 62)

   at Unable to ADO conect with connection string: Provider=SQLOLEDB.1;Initial

Catalog=master;Data Source=.\sqlexpress(VADODatabaseProvider::connect line 181)

   at VDatabaseSwitch::SwitchDb(VDatabaseSwitch::SwitchDb line 167)

   at (psaobsolete::PSAMySQLDatabase::SwitchPleskDatabase line 654)

   at psaobsolete.PSAMySQLDatabase.SwitchPleskDatabase(String new_provider,

String new_host, String new_dbName, String new_login, String new_password,

String new_port, String con_login, String con_password)

   at reconfigurator.Reconfigurator.Main(String[] args)

 

RESOLUTION

Please download the following file:

http://download1.swsoft.com/Plesk/Autoupdate/Windows/8.3.0/129903/reconfigurator.exe

and place it to the %plesk_bin% folder.

Note: Please see how to install Plesk hotfixes properly.

Additional information

%plesk_dir% is environment variable which points to Plesk installation folder. By default it is C:\Program Files\SWsoft\Plesk

%plesk_bin% is environment variable which points to Plesk binaries folder. By default it is C:\Program Files\SWsoft\Plesk\admin\bin


Please provide feedback on this article

Did this article help you solve your issue?
Yes
No
Partially
I do not know yet
 
Strongly Agree   Strongly Disagree
  9 8 7 6 5 4 3 2 1
The article is easy to understand
The article is accurate
Additional Comments:
*Please provide us with your email address in case we need to contact you.
*Please type the code you can see.
* - required fields