Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_database_setup thread: Login failed. Not associated with a trusted SQL Server connection


Message #1 by "Alexander" <3asys@m...> on Tue, 28 May 2002 07:14:06
Hello! 
At attempt to connect asp-page to the database on MS SQL Server 2000 I 
have following error: 

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

the Same error repeats and for any other user of the server available in 
base SQL. What I should make for solution of this problem? 
Yours faithfully, Alexander
Message #2 by "PinoyTXT --> Earljon Hidalgo" <earl@p...> on Tue, 28 May 2002 16:05:52 +0800
Please make sure you have checked your SQL Server Properties.
Go to your enterprise manager then right click the server, point to
properties. Under Security Tab, make sure that the checked box is on the SQL
and Windows Authentication not on Windows Authentication only.

-----------
Earljon


----- Original Message -----
From: "Alexander" <3asys@m...>
To: "ASP Database Setup" <asp_database_setup@p...>
Sent: Tuesday, May 28, 2002 7:14 AM
Subject: [asp_database_setup] Login failed. Not associated with a trusted
SQL Server connection


> Hello!
> At attempt to connect asp-page to the database on MS SQL Server 2000 I
> have following error:
>
> "Type Error:
> Microsoft OLE DB Provider for SQL Server (0x80004005)
> Login failed for user 'sa'. Reason: Not associated with a trusted SQL
> Server connection."
>
> the Same error repeats and for any other user of the server available in
> base SQL. What I should make for solution of this problem?
> Yours faithfully, Alexander
%%email.unsub%%
>
>


  Return to Index