Windows 2003 and ASP

Hi,
I am unable to connect to a database in my SQL 2000 Server installed on

a Windows 2003 Server machine from an asp page on another machine(the
web server). It gives the the
following error:


Microsoft OLE DB Provider for SQL Server (0x80004005)
Login failed for user 'sa'. Reason: Not associated with a trusted SQL
Server connection.


I also sometimes get:
MSDataShape (0x80004005)
Data provider could not be initialized.

The authentication mode is mixed. That means it is supposed to accept
SQL authentication.

I can connect with the same connection string and parameters from a
visual basic 6 application.


I can also connect the web client with the same DB in SQL 2000 running
on Windows 2000/XP.

If I put the web server on that same machine I can also connect.

I believe it is something to do with security. Please advise me on what

to do. It is very urgent.

RE: Windows 2003 and ASP

There is a thread on this issue a few days ago in this NG; however, to recap,
the solution to your problem is to make sure that your SQL installation is at
Service Pack 3 or higher. Because of known security issues with SQL, Windows
Server 2003 will not allow TCP/IP connections to SQL installations prior to
SP3.

For further information cosult this KB article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;8840 12


"CosmicLeap@gmail.com" wrote:

> Hi,
> I am unable to connect to a database in my SQL 2000 Server installed on
>
> a Windows 2003 Server machine from an asp page on another machine(the
> web server). It gives the the
> following error:
>
>
> Microsoft OLE DB Provider for SQL Server (0x80004005)
> Login failed for user 'sa'. Reason: Not associated with a trusted SQL
> Server connection.
>
>
> I also sometimes get:
> MSDataShape (0x80004005)
> Data provider could not be initialized.
>
> The authentication mode is mixed. That means it is supposed to accept
> SQL authentication.
>
> I can connect with the same connection string and parameters from a
> visual basic 6 application.
>
>
> I can also connect the web client with the same DB in SQL 2000 running
> on Windows 2000/XP.
>
> If I put the web server on that same machine I can also connect.
>
> I believe it is something to do with security. Please advise me on what
>
> to do. It is very urgent.
>
>

Re: Windows 2003 and ASP

Thanks for your reply John.
I already have sp3 applied to my database.
The error that kb deals with is different from mine.
I just want to connect and use SQL connection from a different machine.
Note that I was able to connect from a visual basic 6 application with
no problem at all.

Re: Windows 2003 and ASP

On 14 Jun 2005 00:15:44 -0700, CosmicLeap@gmail.com wrote:

>Hi,
>I am unable to connect to a database in my SQL 2000 Server installed on
>
>a Windows 2003 Server machine from an asp page on another machine(the
>web server). It gives the the
>following error:
>
>
>Microsoft OLE DB Provider for SQL Server (0x80004005)
>Login failed for user 'sa'. Reason: Not associated with a trusted SQL
>Server connection.
>
>
>I also sometimes get:
>MSDataShape (0x80004005)
>Data provider could not be initialized.
>
>The authentication mode is mixed. That means it is supposed to accept
>SQL authentication.
>
>I can connect with the same connection string and parameters from a
>visual basic 6 application.
>
>
>I can also connect the web client with the same DB in SQL 2000 running
>on Windows 2000/XP.
>
>If I put the web server on that same machine I can also connect.
>
>I believe it is something to do with security. Please advise me on what
>
>to do. It is very urgent.

Take a look at:

Why do I get database-related 80004005 errors?
http://www.aspfaq.com/show.asp?id=2009

HOWTO: IIS and SQL Server on Separate Machines with Trusted
Connection:
http://support.microsoft.com/default.aspx?scid=kb;en-us;q176 379

Jeff