02-14-2012 03:50 PM
Hi all
We have backup exec 2010 R3 installed on Win 2k8 R2.
In creationg job when selecton SQL 2008 R2, backup exec pops on logon account selection and no account works even which works in SQL management studio well.
Other SQL versions can be selected and works
Regards
02-14-2012 04:49 PM
Does this account have the sysadmin role ?
02-14-2012 04:51 PM
Hi
Have you tried using SA account to expand the sql server instance means while expanding the SQL server you would be using you default domain account & when trying to expand the sql 2008 r2 you can click on new & then make new account called SA & then try to expand it & see if that works
Thanks
02-14-2012 05:41 PM
Thank you guys
The account SA is working but my domain user account has all privileges and works in management studio well but is not work here
02-14-2012 05:53 PM
What is the error you receive ?
Are you able to select other resources on the same server ?
02-14-2012 05:55 PM
Hi
Thanks for the update & in that case open SQL studio management & then click on security & then click on users & see if that user account which you are using in backupexec is there or not if it is not there please add the account & then click on properties & click on server role & let me know what rights or server role you have for that account
http://www.symantec.com/docs/TECH68253
Thanks
02-14-2012 08:09 PM
hi again
I found that if add BUILTIN/administrators to sql login group and add the domain admin group to that local administrators, it works
Regards