Posted by Mike Epprecht \(SQL MVP\) on 10/01/15 11:18

Hi

The SQL Server is setup to only accept NT Integrated Security. You can
change it to mixed mode, see BOL.

AND, do not use the sa account to connect your web site to your DB. You are
asking to get hacked, your data stolen and published on the internet. Use a
low privileged account for this. Look up security in SQL Server 2000 Books
Online

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

<CosmicLeap@gmail.com> wrote in message
news:1118410663.736691.291600@g47g2000cwa.googlegroups.com...
> 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. 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.
>
> 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.
>
> The authentication mode is mixed.
>
> I believe it is something to do with security. Please advise me on what
> to do. It is very urgent.
>

[Back to original message]