Hello,

I am new to CRM. We have a CRM Server and SQL 2000 Server each on their own
piece of hardware. I recently changed the MSSQLServer and SQLServerAgent
services to start using a Domain\User. I was able to get the services
started and all other programs worked well except for CRM. We were no longer
able to get to the CRM Website, and the CRM Security Service would not start.
As soon as I set the SQL Services to start using the localsystem account
again, everything began working fine. What privileges does does a domain
user need in CRM in order for the software to function properly? I most
definitely want to start the SQL Services in this manner. Can someone help
me with this.

Jeff,

It's possible that the domain account doesn't have the rights needed to set the
Service Principal Name for the SQL box or there may be a duplicate entry for the
Service Principla Name. If you search this group on Google you should find
references to how to look for this value. This entry is needed for the
integrated authentication to work properly.

You can also try verifying this by changing SQL to run under a Domain Admin
account and see if that works. If so, it will basically need an account that
has AD rights to the computer account.

Matt Parks
MVP - Microsoft CRM

----------------------------------------
----------------------------------------
On Wed, 3 Nov 2004 08:18:03 -0800, "Jeff Lewis"
<JeffLewis@discussions.microsoft.com> wrote:

Hello,

I am new to CRM. We have a CRM Server and SQL 2000 Server each on their own
piece of hardware. I recently changed the MSSQLServer and SQLServerAgent
services to start using a Domain\User. I was able to get the services
started and all other programs worked well except for CRM. We were no longer
able to get to the CRM Website, and the CRM Security Service would not start.
As soon as I set the SQL Services to start using the localsystem account
again, everything began working fine. What privileges does does a domain
user need in CRM in order for the software to function properly? I most
definitely want to start the SQL Services in this manner. Can someone help
me with this.

Hi Matt,

This fixed my issue. I really appreciate your help.

Jeff

"Matt Parks" wrote: