Forum Discussion

shahram_dehghan's avatar
13 years ago

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