POS 2009 with SQL Server on Domain Controller

Posted by rmi on October 27, 2009, 3:19 am

Please log in for more thread options

Hello,

In preparation for a POS 2009 installation, I have been doing some tests to
make sure the product will work in our environment. I would like to have the
primary POS database on our Small Business Server 2008 machine. I don't have
a SBS machine available for testing, but I have been testing this with
Windows Server 2008 configured as a domain controller.

So far, I've been having trouble setting up the database when the server is
configured as a DC. I get the following error after waiting for a few
minutes while the DB is set up:
Failed to create database MSPOS.
Error Details: Failed to create the windows users/groups or add the sql
logins.

The database is still created, but it is not usable. If I try to connect to
it from a client computer, I get the following error:
An error occurred while attempting to create users and groups for Microsoft
Dynamics POS.
For technical information about this problem, click Details.
(Details:)
The creation of all Pos groups could not be completed

If the server is not configured as a DC, I have none of these problems. I
suspect it is because, as a DC, the server has no local user database.
Still, it seems like it should be able to create the appropriate domain
groups.

Am I missing something? Will I be able to run the SQL Server instance on
the same server as the primary domain controller? Would the problem be any
different if I was trying it on an actual SBS installation?

Thanks,

--
Matt