I have a windows 2003 server with the latest service pack and patches. This server also acts a domain controller.
Is installing standard edition on a server that is a domain controller supported because it looks like install is trying to create and add to local groups which are not present on a server if it is a domain controller.
I tried installing the standard edition of sql server and I get the following error:
ITLE: Microsoft SQL Server 2005 CTP Setup
SQL Server Setup was unable add user NT AUTHORITY\SYSTEM to local group SQLServer2005SQLBrowserUser.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1187.07&EvtSrc=setup.rll&EvtID=1603&EvtType=sqlca%5csqlsecurityca.cpp%40Do_sqlGroupMember%40Do_sqlGroupMember%40x735d
BUTTONS:
OK
TITLE: Microsoft SQL Server 2005 CTP Setup
The setup has encountered an unexpected error while Installing Local Groups. The error is :The system cannot find the file specified.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1187.07&EvtSrc=setup.rll&EvtID=2&EvtType=Unknown%40Rollback_sqlGroupMember%40Unknown%40x0
BUTTONS:
OK
Currently SQL Server 2005 will not install on a Domain Controller or on Windows Small Business Server. There is no known work around at this time other than installing on a machine that is not configured as a domain controller. This is a known issue and we're working on resolving it.Dan|||is this fix now?|||
3.10 Installing SQL Server Express on a Windows Domain Controller
It is possible to install SQL Server Express on a Windows domain controller; however, it cannot run on a Windows Server 2003 domain controller as Local Service or Network Service. SQL Server service accounts should run as Windows domain user accounts. It is also possible to install SQL Server service accounts to run as Local System, but this option is not recommended.
Do not change the role of the server after you install SQL Server Express. For example, if you install SQL Server Express on a member server, do not use the Dcpromo tool to promote the server to a domain controller. Or, if you install SQL Server Express on a domain controller, do not use Dcpromo to demote the server to a member server. Changing the role of a server after you install SQL Server Express can result in loss of functionality and is not supported.
