Accessing SQL2000 on a Win2003 server

Hello

I am reposting my previous question adding additional info...

I am trying to access a Win2003/SQL2000 server from a Win2000 (web)server.
To test the access I am windows-loging in the Win2000 server and I am
manually testing a UDL string. I am accessing the DB using SQL
authentication. There is no domain - only a workgroup.

If the windows user I using to login (on the Win2000 server) can
authenticate on the Win2003/SQL2000 machine (it exists and has the same
password) then the UDL connection succeeds. However if the windows user
cannot authenticate then the UDL fails. (Obviously web accesses to the DB
also fail b/c they are done using the IUSR user). Notice that this problem
does NOT exist if I try to access SQL2000 on a Win2000 server.

I suspect this has to do with stricter permissions for anonymous access to
the Win2003 server (compared to Win2000). I have changed the following
security settings on the Win2003 server:

- Enabled "Let Everyone permissions apply to anonymous users" setting (KB
822011)
- Enabled SID/Name translation and TurnOffAnonymousBlock (KB 839569)
- Added "Everyone" in the "Allow Logon Locally" setting

The problem still remains. Does anyone have any other ideas? I am more or
less stuck!

many thanks
christos

ChristosKritikos
Tue May 03 18:08:47 CDT 2005


some more info:
I ran the same test that I mention below (manually connecting via
SQL-authentication to a SQL2000/Win2003 server using a UDL connection) from 8
different computers. The computers are a mix of Win2k Adv, Win2k std, Win03
Std. In all cases I login on the computer using a local admin account that
doesn't exist on the SQL2000/Win2003 server. I noticed that the connection
*succeeds* for computers with SQL2000 installed but it fails for computers
that don't have SQL2000 installed. So it seems that installing SQL2000 makes
some configuration change that allows the connection to the Win2003 server to
work.

any input/ideas will be highly appreciated.

christos

"Christos Kritikos" wrote:

> Hello
>
> I am reposting my previous question adding additional info...
>
> I am trying to access a Win2003/SQL2000 server from a Win2000 (web)server.
> To test the access I am windows-loging in the Win2000 server and I am
> manually testing a UDL string. I am accessing the DB using SQL
> authentication. There is no domain - only a workgroup.
>
> If the windows user I using to login (on the Win2000 server) can
> authenticate on the Win2003/SQL2000 machine (it exists and has the same
> password) then the UDL connection succeeds. However if the windows user
> cannot authenticate then the UDL fails. (Obviously web accesses to the DB
> also fail b/c they are done using the IUSR user). Notice that this problem
> does NOT exist if I try to access SQL2000 on a Win2000 server.
>
> I suspect this has to do with stricter permissions for anonymous access to
> the Win2003 server (compared to Win2000). I have changed the following
> security settings on the Win2003 server:
>
> - Enabled "Let Everyone permissions apply to anonymous users" setting (KB
> 822011)
> - Enabled SID/Name translation and TurnOffAnonymousBlock (KB 839569)
> - Added "Everyone" in the "Allow Logon Locally" setting
>
> The problem still remains. Does anyone have any other ideas? I am more or
> less stuck!
>
> many thanks
> christos
>
>