While performing a SQL restore, a pop-up error is received upon clicking the Restore button stating " Error occurred handling an SQL object name "
Problem
When selecting a database to restore using the NetBackup MS SQL Client, a pop-up error is received upon clicking the Restore button stating " Error occurred handling an SQL object name "
Error Message
Error occurred handling an SQL object name
Cause
This issue can occur if the user has logged on using a Temporary profile on the Client.
Findings from dbclient.log
20:18:25.804 [634140.228748] <16> DB_CryptAcquireContext: ERR - Error in CryptAcquireContext : 2148073508.
20:18:25.804 [634140.228748] <1> DB_CryptAcquireContext: CONTINUATION: - The profile for the user is a temporary profile.
20:18:25.804 [634140.228748] <16> DB_CryptAcquireContext: ERR - Error in CryptAcquireContext : 2148073508.
20:18:25.804 [634140.228748] <1> DB_CryptAcquireContext: CONTINUATION: - The profile for the user is a temporary profile.
20:18:25.804 [634140.228748] <8> CSQLDBMSOptions::CSQLDBMSOptions: WARN - Error encountered looking up your default SQL userid and password from file.
\PMT2012QA2};UID:Login ID=?;PWD:Password=?;Trusted_Connection:Use Integrated Security=?;*APP:AppName=?;*WSID:WorkStation ID=?;
20:18:43.042 [634140.228748] <4> CGlobalInformation::IsDefaultInstanceInstalled: INF - Error: ERROR_FILE_NOT_FOUND
20:18:43.042 [634140.228748] <1> CGlobalInformation::IsDefaultInstanceInstalled: CONTINUATION: - The system cannot find the file specified.
20:18:43.198 [634140.228748] <8> AugmentInstanceList: WARN - Cannot query <HKLM\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\\InstalledInstances> on <\\testW4>. Status <2>
20:18:43.198 [634140.228748] <1> AugmentInstanceList: CONTINUATION: - The system cannot find the file specified.
20:18:43.198 [634140.228748] <4> CSQLDBMSOptions::OnInitDialog: INF - It is unknown whether NetBackup for Microsoft SQL Server is installed on host machine
20:18:53.042 [634140.228748] <8> AugmentInstanceList: WARN - Cannot query <HKLM\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\\InstalledInstances> on <\\testW4>. Status <2>
20:18:53.042 [634140.228748] <1> AugmentInstanceList: CONTINUATION: - The system cannot find the file specified.
20:18:57.878 [634140.228748] <4> CGlobalInformation::CreateDSN: INF - Using ODBC Driver <SQL Server Native Client 11.0>
Solution
Make sure user is not logged in under temporary profile.