WIN 7 Pro as a server

Posted on 2011-10-31
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 77

    Assisted Solution

    by:David Johnson, CD, MVP
    Doesn't matter as SQL Server will be running as NETWORKSERVICE
    LVL 13

    Accepted Solution


    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.
    LVL 1

    Author Closing Comment

    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

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Divide by zero error encountered. 2 23
    Eclipse Neon and jdk 1.8.0 11 41
    HP Z440 RAID 1 26
    SD  partition not being recognised 14 41
    One of the features I've come to appreciate about Windows 7 and Windows Server 2008 R2 is the ability to pin applications to the task bar. As useful a feature as I've found this, it does have some quirks.  For example, have you ever tried pinning an…
    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    This Micro Tutorial will give you basic overview of the control panel section on Windows 7. It will depth in Network and Internet, Hardware and Sound, etc. This will be demonstrated using Windows 7 operating system.
    This Micro Tutorial will give you a basic overview of Windows DVD Burner through its features and interface. This will be demonstrated using Windows 7 operating system.

    745 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

    18 Experts available now in Live!

    Get 1:1 Help Now