Video Screencast Help

NetBackup 7.1 - Unable to logon to NetBackup MS SQL client

Created: 14 May 2013 • Updated: 14 May 2013 | 4 comments
Willie_SA's picture
This issue has been solved. See solution.

Let me first say - the backups work and all is fine. We created/copied the script for the SQL backups in the ........../DbEct directory. Policy working.

Client = Windows 2008 server.

NetBackup = 7.1

I need to be able log onto the NBU MS SQL Client to configure restore and other parametes.

I Remote Desktop Connection to the Client with the Domain ID with full ADMIN rights.

The ID has full authority in the Database security settings.

BUT I cannot logon to the NetBackup MS SQL Client program.

Refer to attached file with screenshots.

Please help.

Operating Systems:

Comments 4 CommentsJump to latest comment

Dyneshia's picture

What is the Netbackup client service set to ?

Please note that when the NetBackup scheduler is used, backup operations that are launched from a daemon process called the NetBackup Client Service. You must ensure that the Client Service has SQL Server privileges to perform backup and restore operations. If you use integrated security, you must ensure that the NetBackup Client Service specifies a Windows account that has been granted SQL Server administrative privileges.

In short, any account that will be used to access the SQL databases for backup and restores (this can the the native SQL 'sa' account; a Windows global account; or the default 'LocalSystem' account) MUST be a member of the SQL > Security > 'sysadmin' role; otherwise, NBU will not have sufficient privileges to backup and restore SQL databases.

Please see : http://www.symantec.com/docs/TECH43512  and http://www.symantec.com/docs/TECH43698

 

 

Willie_SA's picture

I just solved it via Google and older Connect entries. One like this:

https://www-secure.symantec.com/connect/forums/netbackup-sql-server-client-not-working

Anyway it turned out that the UAC was ticked to be active.

I unticked it - System to be restarted later - and then opened with right click (As Administrator).

And now I can see the databases and restoreable entries.

Thank you Marianne - if you do enter a note in here - I will give you the solution.

 

TX

SOLUTION
Marianne's picture

Totally happy to give this solution to you, Willie.

You have done own research and found the answer.

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links