Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


SBS SQL Install help for MS CRM 3.0 please!

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

Accepted Solution

vico1 earned 2000 total points
ID: 16349485
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The problem of the system drive in SBS 2003 getting full continues to be an issue, even though SBS 2008 and SBS 2011 are both in the market place.  There are several solutions to this, including adding additional drive space or using third party uti…
If you are a user of the discontinued Microsoft Office Accounting 2008 (MSOA) and have to move to a new computer running Windows 8, you will be unhappy to discover that it won't install.  In particular, Microsoft SQL Server 2005 Express Edition (SSE…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Loops Section Overview
Suggested Courses

580 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