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.