Forum Discussion

Willie_SA's avatar
Willie_SA
Level 6
12 years ago
Solved

NetBackup 7.1 - Unable to logon to NetBackup MS SQL client

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.

7.1.x and Earlier
Backup and Recovery
NetBackup
Windows Server (2003-2008)

4 Replies

Sort By
  • Dyneshia's avatar
    Dyneshia
    Level 6
    12 years ago

    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 avatar
    Willie_SA
    Level 6
    12 years ago

    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

  • Marianne's avatar
    Marianne
    Level 6
    12 years ago

    Totally happy to give this solution to you, Willie.

    You have done own research and found the answer.