shahram_dehghan
13 years agoLevel 4
How to configure logon account for backing up five SQL servers with different SA passwords?
Hi,
I have 5 SQL servers in the network.
RAWS is installed on all of the 5 SQL servers.
We don't have Domain and we use workgroup.
so each server has his own username and password because each server is manged by special group of administrators.
for example :
server1 administrator's username : user1 ,password :pass1 ,
sql SA pass:SApass1
server2 administrator's username : user2 , password: pass2
sql SA pass : SApass2
... .
two servers are running SQL 2005.
three servers are running SQL 2008R2.
My question is :
how do i have to configure logon accounts in Backup Exec 2010 R3 Media server for backing up these 5 SQL servers with SA username and password ?
Thanks.
You can "Connect As" using the proper account(s)
See page 178 of the Admin Guide