Jim Metcalf
asked on
Credentials that created maintenance plans in Studio Management
Question-
I had all the maintenance plans fail that were created by a different user through the MSSQL studio interface. the backup piece of the maintenance plans go to a network share.
if someone logs into studio with their windows credentials to create a maintenance plan, is that the credentials the sql server uses for 1) to fire off the maintenance plan and 2) if the destination for a backup is on a network share, does it use those same credentials for network access to the share?
same question if someone uses the SA account to login to studio...... what then is used for network access to shares to place the backup files if the maintenance plan was created by the SA account
I had all the maintenance plans fail that were created by a different user through the MSSQL studio interface. the backup piece of the maintenance plans go to a network share.
if someone logs into studio with their windows credentials to create a maintenance plan, is that the credentials the sql server uses for 1) to fire off the maintenance plan and 2) if the destination for a backup is on a network share, does it use those same credentials for network access to the share?
same question if someone uses the SA account to login to studio...... what then is used for network access to shares to place the backup files if the maintenance plan was created by the SA account
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
also-
the about the sa account. the service account is a local account correct? so how does active directory authenticate the service account to allow it to network resources. if I have two sql servers/instances... is the sa account service account the same in active directory's eyes?
the about the sa account. the service account is a local account correct? so how does active directory authenticate the service account to allow it to network resources. if I have two sql servers/instances... is the sa account service account the same in active directory's eyes?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER