Cannot upgrade Parallels Plesk Sitebuilder for Windows: "Cannot connect to the SQL server with the created Sitebuilder account"

Created:

2016-11-16 13:12:46 UTC

Modified:

2017-06-13 09:15:36 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Cannot upgrade Parallels Plesk Sitebuilder for Windows: "Cannot connect to the SQL server with the created Sitebuilder account"

Applicable to:

  • Plesk Sitebuilder 4.5 for Windows

Symptoms

I'm upgrading Parallels Plesk Sitebuilder 4.1 to version 4.5. The following error is shown in the log:

SCRIPTMSG_SQLAUTH_ERROR = Cannot connect to the SQL server with the created Sitebuilder account. Probably the SQL Authentication is off on the server. Verify that mixed mode authentication is used and enabled.
SCRIPTMSG_PORT_ERROR = Provided port for web site is incorrect. Please enter another port.

Cause

Sitebuilder installation utility uses database connection parameters specified in the registry:

HKLM\\Software\\SWsoft SiteBuilder for Windows
--->8---
SQLSERVER: ***
WSB_SQLPWD: ***
WSB_SQLUSER: ***
WSB_SQLWINAUTH: false
---8<---

Even if Parallels Plesk Sitebuilder works itself, the upgrading might fail. Here are connections records from the installation script (provided by the developers):

If ( GetProp("WSB_SQLWINAUTH") <> "false" OR GetProp("WSB_SQLUSER") = "" OR ( GetProp("SQLWINAUTH") <> "true" AND GetProp("SQLUSER") = ""  ) ) Then
Exit Sub
End If



Set cnn = CreateObject("ADODB.Connection")
If GetProp("SQLWINAUTH") = "true" Then
cnn.ConnectionString = "Provider=SQLOLEDB;Data Source=" + GetProp("SQLSERVER") + ";Integrated Security=SSPI"
cnn.Open
Else
cnn.Open "Provider=SQLOLEDB;Data Source=" + GetProp("SQLSERVER"), GetProp("SQLUSER") , GetProp("SQLPWD")
End If

Please get the parameters from the registry and verify the connection is possible using SQL Server Management Studio Express .Kindly note that Sitebuilder installer uses default port for database connection - there is no parameters for ports specification.

Resolution

Reconfigure database server to make the connection possible. Upgrade Parallels Plesk Sitebuilder with installation script sitebuilder-4.5.0_build080902.182_winx86.exe

Upgrade to 4.5 with debug log:

> msiexec /i SBinst.msi SKIPCONFIGUREIIS=1 FORCELICENSEUPGRADE=1 /lx*v install45.log

File SBinst.msi will appear in directory C:\\Program Files\\Parallels... created by the autoinstaller script sitebuilder-4.5.0_build080902.182_winx86.exe automatically. So it's needed that you execute the exe script first.

Related tickets

#1667148: Cannot upgrade Sitebuilder 4.2

#1838875: Sitebuilder 4.1 for Windows upgrade

Related Articles

I cannot upgrade Parallels Plesk Sitebuilder from 4.1 to 4.5: “Custom action OnSuccessCA script error”

Have more questions? Submit a request
Please sign in to leave a comment.