Re: Accessing SQL2000 on a Win2003 server

From: Jeff Cochran (
Date: 05/05/05

Date: Thu, 05 May 2005 03:11:22 GMT

On Tue, 3 May 2005 11:08:01 -0700, "Christos Kritikos"
<> wrote:

>I am running a SQL2000 server that is accessed by our webserver. The problem
>is the webserver cannot access the SQL server on a Win2003 machine (it works
>if the DB is on a Win2000 machine). What I noticed is that DB accesses only
>work for windows users that authenticate on the DB machine. So if I manually
>try to establish a connection it works (my windows user exists on both the
>webserver and the DB server machines). However the IIS anonymous user doens't
>exist on the DB machine. I suspect this is a Win2003 add-security setting.
>Does anyone know what I have to toggle?

Take a look at:

HOWTO: IIS and SQL Server on Separate Machines with Trusted