Article ID: 2073, created on Aug 8, 2007, last review on May 7, 2014

  • Applies to:
  • Plesk Sitebuilder for Windows

Resolution

There are two ways to reconfigure connection string:

1. Uninstall Sitebuilder from the server and install it again specifying the new connection parameters.

2. Change connection strings directly on the server.

The following files should be modified:

%SB_DIR%\Web\web.config,
%SB_DIR%\Utils\SBBackup.exe.config,
%SB_DIR%\Utils\SBMigrationTool.exe.config,
%SB_DIR%\Utils\SBResetPassword.exe.config,
%SB_DIR%\Utils\SBRestore.exe.config,
%SB_DIR%\Utils\SBSetLicense.exe.config,
%SB_DIR%\Utils\UpdateTemplatesConsole.exe.config

where %SB_DIR% is Sitebuilder installation directory.

Note, that before changing the connection string in web.config you need to decrypt connection string section with the following command line:

aspnet_regiis.exe -pdf connectionStrings "%SB_DIR%\Web"


Upon sucesfull execution of the above command Sitebuilder configuration file will contain decrypred connectionString section. Rest of the files do not require decryption.

aspnet_regiis tool is usualy located in following directory C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\

More about encrypting and decrypting configuration section you can read here:

http://msdn2.microsoft.com/en-us/library/zhhddkxy.aspx

In order to avoid issues with possible future upgrades it is necessary also accordingly to modify the Windows Registry.

HKEY_LOCAL_MACHINE\SOFTWARE\SWsoft Sitebuilder for Windows

There are four values related to the SQL Server connectivity:

SQLSERVER (string),
WSB_SQLUSER (string),
WSB_SQLPWD (string),
WSB_SQLWINAUTH (string/boolean)

In case Windows authentication is used, the following values should be specified:

SQLSERVER = name of SQL server machine
WSB_SQLWINAUTH = "true"
WSB_SQLUSER = ""
WSB_SQLPWD = ""


In case Integrated SQL Server Authentication is used, the following values
should be specified:

SQLSERVER = name of SQL server machine
WSB_SQLWINAUTH = "false"
WSB_SQLUSER = <user name>
WSB_SQLPWD = <password>

fad6dc0c8e983c17ae70a51ac7952cd0 2a62cbceb986d1b8f45bcd3ff4cb29a5 56797cefb1efc9130f7c48a7d1db0f0c

Email subscription for changes to this article
Save as PDF