SBS SQL Install help for MS CRM 3.0 please!

Posted on 2006-03-31
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?
Question by:Matrix1000
    1 Comment
    LVL 15

    Accepted Solution

    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!

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Join & Write a Comment

    You may have discovered the 'Compatibility View Settings' workaround for making your SBS 2008 Remote Web Workplace 'connect to a computer' section stops 'working around' after a Windows 10 client upgrade.  That can be fixed so it 'works around' agai…
    A quick step-by-step overview of installing and configuring Carbonite Server Backup.
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    746 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

    16 Experts available now in Live!

    Get 1:1 Help Now