WIN 7 Pro as a server

Posted on 2011-10-31
Medium Priority
Last Modified: 2012-06-22
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.
Question by:Bert2005
LVL 84

Assisted Solution

by:David Johnson, CD, MVP
David Johnson, CD, MVP earned 1600 total points
ID: 37060872
Doesn't matter as SQL Server will be running as NETWORKSERVICE
LVL 13

Accepted Solution

khairil earned 400 total points
ID: 37060967

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.

Author Closing Comment

ID: 37062523
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.

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Assume you have an outside contractor who comes in seasonally or once a week to do some work in your office, but you only want to give him access to the programs and files he needs and keep all other documents and programs private. Can you do this o…
This Micro Tutorial will give you a basic overview of Windows Live Photo Gallery and show you various editing filters and touches to photos you can apply. This will be demonstrated using Windows Live Photo Gallery on Windows 7 operating system.
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…

864 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