SQL connection error

[Shahin]

Hi,

As you may know we have an issue with upgrading the BE 2010 R2 to R3 we cannot use the brwoser.exe to install the R3 so I did try to run setup.exe from the BE\WinNT\Install\BEx64 and just to see if we pass the pre-chaeck, I went untill the step check services account and after that I did cancel the install after that I did check the logs and I can see there is an error with connecting with SQL server!!

This server has also SQL 2008 and if I use this version of sql server manager I can access nts59\backupexec

what this error means? can We goahead with upgrade? or this is not good?

Thanks

Symantec Backup Exec (TM) 13 Installation Log

11-11-2015,16:22:24 : EnumProcesses Counts: 144
11-11-2015,16:22:24 : Windows Operating System Version: 6.1
11-11-2015,16:22:24 : GetProductInfo returned success. Checking for CORE OS values.
11-11-2015,16:22:26 : Executing managed _Setup:
11-11-2015,16:22:26 : F:\Install\ISOs\Backup_Exec_2010_R3_13.0.5204_ZOnder SP1\BE\WinNT\Install\BEx64\Install\_Setup.exe
11-11-2015,16:22:26 : Loading XML from:
11-11-2015,16:22:26 : F:\Install\ISOs\Backup_Exec_2010_R3_13.0.5204_ZOnder SP1\BE\WinNT\Install\BEx64\Install\IFProducts.xml
11-11-2015,16:22:26 : RawsDlgSequence::CheckInstMode
11-11-2015,16:22:27 : BEOperations::BE_GetInstalledProdCodeVersion()
11-11-2015,16:22:27 : Found 13.0.4164 BEWS Product.
11-11-2015,16:22:27 : RawsDlgSequence::CheckUpgrade
11-11-2015,16:22:27 : DJM was not found to be enabled. Not upgrading a CASO-MMS.
11-11-2015,16:22:27 : SSO key found for upgrade, value: 0
11-11-2015,16:22:27 : Dell Storage Provisioning was not found to be enabled.
11-11-2015,16:22:27 : DLO was not found to be enabled.
11-11-2015,16:22:27 : Backup Exec version 13.0.4164 is registered with the system.
11-11-2015,16:22:27 : Writing Install Registry Value (Software\Symantec\Backup Exec For Windows\Backup Exec\13.0\Install\Upgrade Version: 13.0.4164.0)
11-11-2015,16:22:27 : Read Install Registry Value (Software\Symantec\Backup Exec For Windows\Backup Exec\13.0\Install\Path: C:\Program Files\Symantec\Backup Exec\)
11-11-2015,16:22:27 : Writing Install Registry Value (Software\Symantec\Backup Exec For Windows\Backup Exec\13.0\Install\PreviousDir: C:\Program Files\Symantec\Backup Exec\)
11-11-2015,16:22:27 : Wrote Install Registry Value (Software\Symantec\Backup Exec For Windows\Backup Exec\13.0\Install\DLO Upgrade Version: 0)
11-11-2015,16:22:27 : Launching UI Install
11-11-2015,16:22:28 : BeSeqDlgs::DlgBERemoteConfig
11-11-2015,16:22:28 : CopySupportFiles
11-11-2015,16:22:28 : Saved support files to C:\ProgramData\Symantec\Backup Exec\Logs\InstallSummary
11-11-2015,16:22:28 : GetClusterUpgradeState returning 0
11-11-2015,16:22:28 : GetClusterUpgradeState returning 0
11-11-2015,16:22:28 : AgentSeqDlgs::Misc_BE_CommonOps
11-11-2015,16:22:28 : Executing BE_SetSQLxLangVersion. Setting language version of SQL Express BKUPEXEC instance.
11-11-2015,16:22:28 : English (1033) version of SQL BKUPEXEC instance found on this system. NLS upgrade not required.
11-11-2015,16:22:28 : BKUPEXEC SQLx setup file is SQLEXPR.EXE.
11-11-2015,16:22:28 : GetClusterUpgradeState returning 0
11-11-2015,16:22:28 : GetClusterUpgradeState returning 0
11-11-2015,16:22:28 : GetClusterUpgradeState returning 0
11-11-2015,16:22:28 : GetClusterUpgradeState returning 0
11-11-2015,16:22:32 : GetClusterUpgradeState returning 0
11-11-2015,16:22:32 : GetClusterUpgradeState returning 0
11-11-2015,16:22:36 : GetClusterUpgradeState returning 0
11-11-2015,16:22:36 : GetClusterUpgradeState returning 0
11-11-2015,16:22:36 : GetClusterUpgradeState returning 0
11-11-2015,16:22:36 : GetClusterUpgradeState returning 0
11-11-2015,16:22:37 : m_bUseNativeClient = 1
11-11-2015,16:22:37 : Executing SQL_GetServicePack.
11-11-2015,16:22:37 : DRIVER={SQL Native Client};SERVER=NTS59\BKUPEXEC;Trusted_Connection=Yes
11-11-2015,16:22:38 : Connected to SQL Server.
11-11-2015,16:22:38 : NTS59\BKUPEXEC is a SQL Server Product Level: 'SP4'
11-11-2015,16:22:38 : Executing SQL_GetSQLServerEdition.
11-11-2015,16:22:38 : DRIVER={SQL Native Client};SERVER=NTS59\BKUPEXEC;Trusted_Connection=Yes
11-11-2015,16:22:38 : Connected to SQL Server.
11-11-2015,16:22:38 : Executing SQL_GetServicePack.
11-11-2015,16:22:38 : DRIVER={SQL Native Client};SERVER=NTS59\BKUPEXEC;Trusted_Connection=Yes
11-11-2015,16:22:38 : Connected to SQL Server.
11-11-2015,16:22:38 : NTS59\BKUPEXEC is a SQL Server Product Level: 'SP4'
11-11-2015,16:22:38 : m_bUseNativeClient = 1
11-11-2015,16:22:38 : DRIVER={SQL Native Client};SERVER=NTS59;Trusted_Connection=Yes
11-11-2015,16:22:38 : Executing SQL_GetServicePack.
11-11-2015,16:22:38 : DRIVER={SQL Native Client};SERVER=NTS59;Trusted_Connection=Yes
11-11-2015,16:22:38 : Connected to SQL Server.
11-11-2015,16:22:38 : NTS59 is a SQL Server Product Level: 'SP1'
11-11-2015,16:22:38 : Executing SQL_GetSQLServerEdition.
11-11-2015,16:22:38 : There is no MSSQL$MSSQLSERVER Service
11-11-2015,16:22:38 : V-225-226: Unable to connect to SQL Server. ***To search for information about this error, click here
11-11-2015,16:22:38 : Executing SQL_GetServicePack.
11-11-2015,16:22:38 : DRIVER={SQL Native Client};SERVER=NTS59;Trusted_Connection=Yes
11-11-2015,16:22:38 : Connected to SQL Server.
11-11-2015,16:22:38 : NTS59 is a SQL Server Product Level: 'SP1'
11-11-2015,16:23:19 : m_bUseNativeClient = 1
11-11-2015,16:23:19 : AgentSeqDlgs::Misc_BE_CommonOps
11-11-2015,16:23:19 : GetClusterUpgradeState returning 0
11-11-2015,16:23:19 : GetClusterUpgradeState returning 0
11-11-2015,16:23:25 : GetClusterUpgradeState returning 0
11-11-2015,16:23:25 : GetClusterUpgradeState returning 0
11-11-2015,16:23:40 : GetClusterUpgradeState returning 0
11-11-2015,16:23:40 : mydomain\Administrator
11-11-2015,16:23:56 : Install is executing as the service account.
11-11-2015,16:23:56 : EUserName value successfully written to the registry.
11-11-2015,16:23:56 : EPassword value successfully written to the registry.
11-11-2015,16:23:56 : EDomain value successfully written to the registry.
11-11-2015,16:24:00 : GetClusterUpgradeState returning 0
11-11-2015,16:24:00 : GetClusterUpgradeState returning 0
11-11-2015,16:24:07 : The return code is: 1602
11-11-2015,16:24:07 : WARNING: Installation has been canceled.

[CraigV · Accepted solution]

Check below and see if these help you:

https://www.veritas.com/support/en_US/article.000008208

https://www-secure.symantec.com/connect/forums/backup-exec-2010-r2-installation-failing

You might've also stopped the upgrade at the point it needed to connect to SQL, or it is looking specifically for an SQL server, and not at the SQL Express installation.

As long as you have copies of the Data & Catalogs folders, you have a way to manually roll back to BE 2010 R2 if you run into issues. I'd personally go with the upgrade. Done it plenty of times, and the major issue I had was McAfee AV blocking the SQL upgrade and corrupting the installation.

THe installation will roll back if there are errors too...

The last error is because you cancelled the upgrade.

Thanks!

[Shahin]

Thank you Carig,

I will go ahead with upgrade to R3 and let you know the result.

Thanks

[Shahin]

Hi Carig,

We did run the upgrade to R3 and it says completed successfully but we must reboot the server I will do it tonight after office hours.

I will plan en upgrade to BE 15 but I must first see how the licenses must be upgraded.

Thanks you for you support.