Authentication problem

2 Windows Server 2003 Standard Edtion Servers with Domain Controller, eg.: DC1 & DC2

4 Workstations (Win XP Pro SP2)

2 workstations are member of DC1, eg.: DC1_WS1 & DC1_WS2

and another 2 workstation are member of DC2, eg.: DC2_WS1 & DC2_WS2

SQL Server 2005 Express SP2 is installed on DC1_WS1 (Mix Authentication, Server Name: DC1)

My problem:

1. I use SSMSE on DC1_WS2, connect to DC1 with SQL Server Authentication (sa). Login Failed.

(I did off the firewall, enabled remote connections: Using both TCP/IP and named pipes)

My questions:

1. with the above setup, is it possible to use DC2_WS1 connect to DC1?

2. is my problem will be solved if I install SQL Server 2005 Exprees in DC1?

Please advise. Thanks.

1) You should be able to connect with SQL Authentication. What's your exact error message? What did you see in the server errorlog?

2) Install SQL Server on DC is not recommended.

|||

"2) Install SQL Server on DC is not recommended. "

This means SQL Server is better install on workstation?

|||Yes. Just don't share a machine with DC, otherwise, it may cause configuration issue hard to track.