July 18, 2008 at 7:01 am
Hi all,
Im a bit confused with regards what type of user account and what level of access this account should have on the domain to run a sql server.
I have two environments. Development environment which has single instance of sql server 2005 and then a Production environment which is a sql cluster.
Should i have different accounts for both environments? should the accounts be domain accounts or local os accounts?
Can someone give me a bit of a run down on how these accounts should be set up please.
Regards
N.
July 18, 2008 at 7:58 am
With SQL Server 2005 the service accounts just needs to be a standard domain account. When you install SQL Server and specify the domain account (or when you change it using Configuration Manager) the necessary permissions are granted to the account.
As far as having different accounts for the different instances, some would say you should, some say you don't need to. Here is a link to the search results for Service Accounts on this site. There are several articles and forum posts on the issue.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply