Parallels Virtualization and Automation Software

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:



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>