WIN 7 Pro as a server

Hi experts,

A friend of mine who five computers connected to a machine running WIN 7 Pro in a peer-to-peer has an application which uses SQL Server 2005 Express as the database. He is only using this machine to run the one application.

He wants to know if he should run that machine as administrator or a user, keeping in mind that he will need to do backups. Not sure if it uses VSS. I know he will use Backup Assist with the SQL Server module.

Thanks in advance. Please let me know if you need more information. I don't see anything negative for running it as as admin user as long as he uses a strong username and password.
LVL 1
Bert2005Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

David Johnson, CD, MVPOwnerCommented:
Doesn't matter as SQL Server will be running as NETWORKSERVICE
0
khairilCommented:
Hi,

He do not event have to log on into the computer to make SQL server runs. As ve3ofa said, SQL Server will be running as NETWORKSERVICE or SYSTEM account.

SQL by itself have build in backup function, so I assume he's doing backup of the SQL backup data.  He can set any account with adequate privillage to copy these file out with having to use Admin account.

Just follow general rules of thumb on server security. Do not use administator or high level account unless you really need to.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Bert2005Author Commented:
Thanks guys. As far as points or best answer, khairil has the most thorough answer, but I only think it is fair that the first answer that is correct receives the most points.

Please correct me if that is not proper etiquette. Thanks for the timely responses.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows 7

From novice to tech pro — start learning today.