We help IT Professionals succeed at work.

SBS SQL Install help for MS CRM 3.0 please!

Matrix1000 asked
Medium Priority
Last Modified: 2010-04-19
I'm to the point where I'm installing SQL 2000 to make it ready for MS CRM 3.0 and I'm not sure abot the 'Services Accounts' form.

I'm confused by this... In the MS  'Completing Setup for Microsoft Windows Small Business Server Premium Technologies'   document  it says

On the Services Accounts page, you can use the default of Use a Domain User account, and then specify the password for your administrator account. Optionally, an even more secure method is to create a new account specifically for accessing SQL Server.

BUT  in the CRM installation Guide says...

"The service account that SQL Server uses to log on to the network must be either a local system account or a domain user account. Installation of Microsoft CRM will fail if the SQL Server service account is the local administrator."

The Services Accounts form says
1. Use the same account for each service. Auto start SQL Server Service
      a. Service Settings
           1. Use the Local System account
           2. Use a Domain User account.
                Username: Administrator
                Password: _____________
                Domain: mydomain

What should I choose?
Watch Question

You do not have to install SQL under the administrator account. You could use any other account with administrative rights.
that will therefore use that account.
Now for the SA password It is really up to you just make sure the password is strong.

Good luck!

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.