Accessing SQL2000 on a Win2003 server

Hello.

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?

trillion thanks
christos

jeff
Wed May 04 22:11:22 CDT 2005

On Tue, 3 May 2005 11:08:01 -0700, "Christos Kritikos"
<ChristosKritikos@discussions.microsoft.com> 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
Connection:
http://support.microsoft.com/default.aspx?scid=kb;en-us;q176379

Jeff