1. Support
  2. Knowledge base
  3. 100021649

Unable to set Database Management System (DBMS) login parameters. Application connection failed for servername. Please select a different SQL server host and instance, or press 'cancel' to exit...

Article: 100021649
Last Published: 2020-12-09
Ratings: 0 0
Product(s): NetBackup

Problem

Unable to set Database Management System (DBMS) login parameters on the Windows 2008 platform. Application connection failed for servername. Please select a different SQL server host and instance, or press 'cancel' to exit the NetBackup for SQL Server Graphical User Interface (GUI)

 

Error Message

Dbclient log:
++++++++++++++++++++
11:54:17.368 [6020.2856] <16> CODBCaccess::LogODBCerr: DBMS MSG - ODBC return code <-1>, SQL State <42000>, SQL Message <229><[Microsoft][ODBC SQL Server Driver][SQL Server]The EXECUTE permission was denied on the object 'xp_loginconfig', database 'mssqlsystemresource', schema 'sys'.>.
11:54:17.368 [6020.2856] <16> CGlobalInformation::QuerySQLServerInfo: ERR - Error found executing <exec master.dbo.xp_loginconfig 'login mode'>
11:54:17.368 [6020.2856] <16> CSQLDBMSOptions::OnApply: ERR - Error 64 has been returned from QuerySQLServerInfo
 

Cause

NetBackup client service was running as Domain Admin. The same account was selected in the DBMS Login Parameters window of the NetBackup SQL Agent GUI
By default in SQL 2008 Local Admin and Domain Admin are no longer included in the SQL Server sysadmin fixed server role on new SQL Server 2008 installations.
 

Solution

Added user account used by NetBackup to the sysadmin server role
 
RELATED DOCUMENT:
http://technet.microsoft.com/en-us/library/cc280562.aspx
 

 

Was this content helpful?

Article Languages