Solved

Credentials that created maintenance plans in Studio Management

Posted on 2015-01-15
5
71 Views
Last Modified: 2015-01-20
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
0
Comment
Question by:jamesmetcalf74
  • 2
  • 2
5 Comments
 
LVL 45

Accepted Solution

by:
Vitor Montalvão earned 334 total points
ID: 40551331
I had all the maintenance plans fail that were created by a different user through the MSSQL studio interface.  
The default owner of the jobs from a maintenance plan is the user that created it so you always need to remember to change the jobs owner after creating a maintenance plan.

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
The SQL Server service account.
0
 

Author Comment

by:jamesmetcalf74
ID: 40551335
is there a way to look at a maintenance plan and see who the creator was/is?
0
 

Author Comment

by:jamesmetcalf74
ID: 40551351
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?
0
 
LVL 45

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 334 total points
ID: 40551371
is there a way to look at a maintenance plan and see who the creator was/is?
As far as I know, no. I don't use maintenance plans.

the service account is a local account correct?
Not really. Isn't the recommendation but you can use it but being a local account it won't have access to shares.
0
 
LVL 4

Assisted Solution

by:Thunder724
Thunder724 earned 166 total points
ID: 40555323
You should have an AD account created to replace the local account.
Than your network shares should be given write/modify access to the share for the AD account that the job is running under.  Using the Local account in SQL to access and write to the network share, the permissions on the share would have to be wide open to anyone.  The SA account is a SQL Account and has nothing to do with Active Directory. Hope this helps.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now