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

However, the thing is, I dunno why it is getting that. I
have created the 'et' user and it utilizes the SQL
Authentication to grant that user access. Its hitting the
right SQL Server and the Database itself, since it is
noting that et is a user for the database, just not
assciated with a trusted SQL Server Connection.

I do NOT pretend to be a DB admin or such, but hey.. my
employer wants me to fix this.

Any help would be MOST welcome. Please.

Russell McCurry (russ@andersoft.com) writes:
[quoted text, click to view]

Actually not. Whichever server you are talking to is saying that the
username you provided is associated with a trusted SQL Server Connection.

And in most cases this means that the server you are trying to connect
to, is not configured to accept SQL authentication. Open Enterprise
Manger, right-click the server, choose Properties, open the Security
tab and double-check.


--
Erland Sommarskog, SQL Server MVP, sommar@algonet.se

Books Online for SQL Server SP3 at