SQL Server to start in which account?

Question

SQL Server to start in which account?

Ashwin M N

Hall of Fame

Points: 3668
More actions
August 19, 2008 at 7:37 am

#77073

I had posted the same topic in 2005 forum, but since I am managing both 2000 and 2005 I have the same issue in SQL Server 2000.
I want to schedule the backup of databases over the network i.e. \\server\folder.
When I tried to backup I got a error that user does not have the permission to the folder even though I have the permission to create and drop files in that folder. Then I found that the service account on which the SQL Server starts has to have the permission to that folder.
The SQL Server service account uses the local account to start.
Here I have the problem. I am the DBA in the company,there is a sysadmin and administration group. I only handle SQL Server part, the sysadmin handles the server side and administration group everything.
The sysadmin logins using his name and administration using administrator login. Most of time the remote server is re-started by sysadmin and few times in his absence by administration but the server will be re-started at least twice in a week. My dilemma is that in which account to start the SQL Service so that who ever restarts the server the SQL Server should start and backup should happen. It will be a overhead if every time the server is restarted the login user has to check whether SQL Server is started.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

tosscrosby SSCoach Points: 18045 More actions · Answer 1

I never have a local account start my services. We created a SQLAmin account, it starts all of my servers services. This account is then granted full permissions to the data shares that I need to perform backups and the copying of these files to remote servers for safe keeping. Your services should never be at the mercy of the person logging into the server (to be honest, I didn't know it was even possible, hence the reason that they're called services!),

-- You can't be late until you show up.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

Here's a link to the other thread.

http://www.sqlservercentral.com/Forums/FindPost554864.aspx

Ashwin: It's prefered if you don't create multiple postings on the same subject, as it tends to result in people spending time answering questions that have already been answered, or suggesting things that have already been suggested.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 3

I'm with Terry on this one. Actually, we also used SQLAdmin.

One problem that exists with the local system account is that is does not have rights on other servers. This makes it harder to access other servers across the network.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]