Home > Archive > Microsoft SQL Server forum > May 2005 > sql 2000 with windows 2003









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author sql 2000 with windows 2003
shawn

2005-05-24, 8:24 pm

When windows 2003 server is not log on to the domain, SQL works
fine.(workgroup) Everyone can connect to SQL. When everyone is on the
domain, nothing can connect remotely to SQL.

Simon Hayes

2005-05-25, 3:23 am

I don't really understand what you mean, but I guess you're using
Windows authentication, and this stops working when you put the server
in a domain? If so, then you probably need to create new logins in
MSSQL which use domain accounts, not local server accounts.

If this doesn't help, you should give some more information - which
authentication mode (Windows or MSSQL) you use, what error messages you
get, if creating a completely new login works etc.

Simon

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com