Login failed, not associated with a trusted SQL server connection

[Mentos]

I have ODBC Connection between SQL Server and with my site, even though it seems to be perfect but whenever i check for the security, it gives me the folowing erormessage Login failed, not associated with a trusted SQL server connection,what kind of problem is that does anyone clear a ther.aassss

[afidelino]

How To: Login failed ... not associated with a trusted SQL server connection

Summary
You probably didn't specify "Mixed Mode authentication" during the install.


Issue
While configuring the ODBC data source (step 2 on page 12 of the ACS Administrator Guide) I'm getting the error

Connection failed:
SQLState: '28000'
SQL Server Error: 18452
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'gbadmin'. Reason: Not associated with a trusted SQL Server connection

If you need to Solution dopp
You probably didn't specify "Mixed Mode authentication" during the install.

[Ackley]

You may also check for the windows authentication by using the following command:

server=Domain\DB_SERVER_NAME;database=DB_NAME;Trusted_Connection=yes;

ie "server=(local)\VSTE;database=intranet;Trusted_Connection=yes;"

and for the security purpose of the SQL Server you may use:

server=Domain\DB_SERVER_NAME;database=DB_NAME;uid=USER_ID;password=PASSWORD;

If following above things, you would not be getting any thing or it simply fails, make a new user on the box where the SQL Server is installed. From there, you can just use that account by using SQL Server authentication instead of Windows based.

[Mecurtis]

I was also facing the same Problem. I was getting error message Login failed for user 'COMPUTERNAME\ASPNET' Everything I tried doesn't work. In my office we had "Mixed Mode" where on application runs on the INTRANET (--> Windows-authentication) and another one that runs over the Internet (--> SQL-Authentication). When i checked that connection with the network manager it were showing "Trusted_Connection=Yes" within the Intranet-Application, we can't create a new SQL-User-Account because I'm working with the Windows Login-Name.
This is how the code in the web.config looks:

<add key="loginDb" value="Server=COMPUTERNAME;Database=DBNAME;Trusted_Connection=Yes"/>