sql 2000 with windows 2003

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • shawn

    sql 2000 with windows 2003

    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

    #2
    Re: sql 2000 with windows 2003

    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

    Comment

    Working...