Symptoms

During the migration of Parallels Business Automation - Enterprise (PBA-E) to Windows 2008, the second configure.pl fails with an error that states the script cannot create the pba database because it already exists.

The following error can be found in %PBA_DIR%\tools\tools.log:

[Thu Apr  3 17:03:54 2014] [Call stack]:
[Thu Apr  3 17:03:54 2014]     'helper::msystem' at c:/ProgramFiles/Parallels/PBA/tools/native/mssql.pm line 534
[Thu Apr  3 17:03:54 2014]     'native::mssql::create_db' at db.pm line 336
[Thu Apr  3 17:03:54 2014]     'db::create_db' at c:\Program Files\Parallels\PBA\tools\configure.pl line 92
[Thu Apr  3 17:03:54 2014]     'main::configure' at c:\ProgramFiles\Parallels\PBA\tools\configure.pl line 79
[Thu Apr  3 17:03:54 2014] PWD: c:/Program Files/Parallels/PBA/tools

In addition, the following error is seen::

[Thu Apr  3 17:04:35 2014] Connect 'dbi:ODBC:pba', bm4
[Thu Apr  3 17:04:35 2014] Couldn't connect to database via configured parameters: DBI connect('pba','bm4',...) failed: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'bm4'. (SQL-28000) at db.pm line 82

It is not clear why configure.pl is trying to create the pba database as it already exists. The script is supposed to connect to the existing database and reconfigure the destination installation using new IP addresses only.

Cause

configure.pl requires the "SQL Native Client" driver to be installed on the system. The connection to the MSSQL server occurs via DSN, which is configured in:

Administrative Tools > Data Sources (ODBC) > System DSN

If the configuration of DSN is not correct, the connection fails, the script switches to the "new installation" mode, and therefore tries to perform a new installation of PBA-E using DB_HOST IP address from %PBA_DIR%\etc\ssm.conf.d\global.conf.

The issue with an incorrect DSN has two possible causes:

  1. Incorrect MSSQL Server management tools version installed. MSSQL Server 2005 management tools must be installed.

  2. DSN parameters are incorrect (e.g. MSSQL server IP, username, password or database name).

Resolution

  1. Install MSSQL Server 2005 management tools.
  2. Go Adminitsrative Tools > Data Sources (ODBC) > System DSN, select pba, click Configure and correct the IP address, username, password and database. Perform the same for pba_verify.

Internal content