Hello,

I installed SQL express 2005 on a windows 2003 x64 R2 server that is our
domain controller as it has plenty of processing power and memory. I have
one other server that is slow and has just enough memory for its current
task. I can get the odbc to connect locally on the domain controller but
the app doesn't work using the odbc. I tried to uninstall reinstall many
things but I just can't get it to work even running the app locally. There
is no firewall on the server - windows or otherwise.

If I install sql express 2005 on another server that does have a firewall it
seems to work. Is there a policy or something on 2003 that prevents sql
express from running?

"boe" <boe_d (AT) hotmail (DOT) com> wrote

Per the documentation, assuming the install was successful (you had all
prerequisites), SQL Server Express 2005 can be run on a Domain Controller
(but is not recommended). However, the SQL Server service cannot run on a
Windows Server 2003 Domain Controller as Local Service or Network Service.
Use a Windows domain user account (Local System possible but not
recommended). Also, do not change the role of the server after installation
of SQL Server Express (for example member server to dc, or dc to member
server).

--
Richard Mueller
MVP Directory Services
Hilltop Lab - http://www.rlmueller.net
--

Hi Boe

In addition to the checking the user service, as Mr. Mueller has pointed
out. Depending on how the application is setup, and if the ODBC that you are
referring to connects using (local) or computer name, one thing that you want
to check is to see if the SQL Server has been configured to accept remote
connection (by default it is off for SQL Server 2005 Express - if I am not
mistaken):

http://support.microsoft.com/kb/914277

Other than that, if there is a firewall between the database and the
application, you might want to check to see if port 1433 is open (or other
port number if you customized it).

Thank you
Lucas

"Richard Mueller [MVP]" wrote: