03-28-2011 11:32 AM
I have seen this topic before, but I am not resolving with the resolutions I have seen on-line. Running NetBackup 6.5.5 and trying to set up the SQL agent for MS SQL 2008 on a Windows 2008R2 server. I have checked UAC, using an account with sysadmin server role and making sure to "Run As Administrator". The weird thing is the SQL version, etc., it all says Unknown, like there is some permission or something that prevents the agent from even seeing the SQL instance. Also new to this.
03-28-2011 11:51 AM
Have you tried to specify 'sa' as user id and sa's password in the bottom of the GUI?
03-29-2011 09:12 AM
Those fields you highlighted will propagate with the correct information after you have supplied proper credentials at the bottom of the window and hit Apply.
03-29-2011 11:42 AM
I did use sa at first, only went to a specific account while troubleshooting.
03-29-2011 11:45 AM
Well, there lies my issue, I cannot get anything but the error above when I hit apply. I was using sa at first, then went with SQL and Windows accounts, all of which have sysadmin role.
05-03-2011 09:23 PM
I am having the same issue. Did you resolve this issue?
05-04-2011 06:53 AM
My backup person has a ticket open with Symantec, but I have not heard anythign back. I will certainly post when I get this resolved.
05-27-2011 06:52 AM
Any resolution yet? I am encountering the same exact scenario. I am running on Windows 2008 Std. 32-bit. This same error happens with both 6.55 and 7.1.
06-09-2011 08:26 AM
remember to use Run as Administrator
06-13-2011 12:08 AM
My Master server is Window 2003 Std. + Netbackup 7.1 and I am trying to connect SQL 2005 std. instance installed in Window 2008 R2 server. Please help!!!
I tried to connect Netbackup SQL Extension from Client and it is successfully connected but when I am trying to Restore database which is in another server it failed saying " unable retrieve required images due to lack of permission"
I am still unable to take backup.
06-13-2011 02:34 AM
Hi,
1. Make sure that you are logged in as a member of the local administrator on the sql server, and that Builtin\Administrator has sysadmin rights in the SQL studio manager. Check under the properties for the builtin\administrator, Security, Login, Server Roles. Take a note of the server name when you are connect to sql server manager, make sure that you use the same sql server name when you try to connect in the Netbackup MSSQL Database gui.
2. Check if the UAC is enabled or not on the SQL server, login as local administrator and open the Control Panel, User Accounts, Turn User Accoutn Control on or off.
3. When you open the Netbackup MSSQL Databse gui, right click on the Icon and select Run as Administrator and type in the sql host name and see if it works.
If all this fail, create log directory <install dir>\netbackup\dbclient on the sql server, increase the verbose level, open the BAR gui and go to File, Netbackup Client Properties, Troubleshooting, change General to 2, Verbose to 5 and Database to 9. Try to open the Netbackup MSSQL database gui again and recreate problem and checkout the log files created in the dbclient folder.
Problem might be with the sqlvdi.dll file, check that you have installed the latest hotfix from Microsoft.
I hope this helps.
/Oddy
06-13-2011 05:56 AM
Thanks Oddy for the description but I am still unable to connect...
Is this happening because of my master server in Window 2003 and Client is Window 2008 server?
06-14-2011 04:19 AM
No, I do not think that problem is the master server. Check the dbclient log on the client, and check if you have any sqlvdi errors in the application log in the event viewer.
Are you able to open and connect to the SQL Studio Manager ?
/Oddy
08-23-2011 05:17 AM
http://www.symantec.com/business/support/index?page=content&id=TECH73128
Try adding the backup account to the sysadmin SQL security group.
11-07-2011 10:50 AM
Hopefully this has been resolved by now?
I found an o-l-d TN that could possibly be relevant :
02-03-2012 02:55 AM
hi,
i got this issue on a server 2008 R2 with SQL 2008 R2 on which i've waisted like half an hour until i found this post :)
the "run as administrator" solved it.
thanks Oddy