Re: sql server 2005 setup question
- From: "Richard Mueller [MVP]" <rlmueller-nospam@xxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 10 Feb 2009 11:40:47 -0600
"ts" <ts@xxxxxxxxxxxxx> wrote in message
news:%23l1Z$M0iJHA.5588@xxxxxxxxxxxxxxxxxxxxxxx
what is the best way to set up sql server 2005 express?
by default, I think system services is used to run the service.
Can I use a regular user with service privilege to run teh service?
how can I make sure a particular attached instance can only be started and
accessed by a particular security group?
Microsoft seems to recommend that you create domain user accounts to run the
SQL Server services. See these links:
http://msdn.microsoft.com/en-us/library/ms143719(SQL.90).aspx
http://msdn.microsoft.com/en-us/library/ms144228(SQL.90).aspx
http://technet.microsoft.com/en-us/library/ms143504.aspx
For SQL Server Express, you only need to start the Instance, and perhaps the
AD Helper service. These accounts are used to start the services only and
should have long, complex passwords.
I use Windows Integrated Authentication, so I create domain groups for
permissions in the databases. I create database roles with the desired
permissions in the database and assign the role to the domain group. All
members of the group get the permissions needed. I remove permissions for
the public role. If you use SQL logins, you create the SQL logins and grant
them the required permissions in each database.
--
Richard Mueller
MVP Directory Services
Hilltop Lab - http://www.rlmueller.net
--
.
- References:
- sql server 2005 setup question
- From: ts
- sql server 2005 setup question
- Prev by Date: Re: DB changing from Simple to Full?
- Next by Date: Re: Creating a database on a local Sql Server Express
- Previous by thread: sql server 2005 setup question
- Index(es):
Relevant Pages
|
