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...

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)

Solution

ISSUE:
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
 
ERROR CODE/ 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
 

 

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)