Login failed for user ''. The user is not associated with a trusted SQL Server connection.

One user on our network when trying to connect to a SQL 2005 DB gets the error.
Login failed for user ''. The user is not associated with a trusted SQL Server connection.
Looking into the SQL 2005 error log it displays.

Date            7/02/2008 12:25:02 PM
Log            SQL Server (Current - 7/02/2008 12:25:00 PM)

Source            Logon

Message
SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: 148.145.229.38]

Now I am connecting fine from my computer, another user has no problems.No why can the user not connect to the DB?
LVL 1
deeznutzAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

chapmandewCommented:
Make sure the windows account that you are using to connect has access to connect to the machine, and that is a valid domain account.
0
deeznutzAuthor Commented:
More info on error when trying to connect:

A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted
0
chapmandewCommented:
how are you connecting to the server?
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

deeznutzAuthor Commented:
He is part of the domain and his computer and account do have access to the SQL Server
0
deeznutzAuthor Commented:
I am trying via a .NET application. TO connect to the database. On his computer he did have SQL 2000 Query Analyzer which I have since removed from his machine and still no luck.  Everyone else's computer did not have SQL 2000 running locally on their machines.
0
chapmandewCommented:
can you connect via management studio?
0
qz8dswCommented:
I might be totally off the mark here, but as per http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=355101&SiteID=1
"(2) If you force encryption in the client, asp2.0 in your case, and that the server happens to use a self-signed certificate or a certificate that is not trusted by the client, you will see the error "The certificate chain was issued by an authority that is not trusted". In such case, in order to still use encryption, you can add a connection string property,

"TrustServerCertificate = true", such that client does not validate certificate hierarchy."

So I'd have a look at the certificates on a machine that works and compare them to your failing user's machine.
They might have an expired certificate or the such. (Also check for any expired trusted root certification authorities certificates)

Terry

0
deeznutzAuthor Commented:
I can connect from his machine logging in using SQL authentication from server studio. I can not log on using Integrated security.
0
brejkCommented:
Move Named Pipes up or down (to switch its position in protocols stack with TCP/IP) in cliconfg.exe or in SQL Server Connection Manager (in Client Network Configuration). If it does not help move back. Sometimes it helps.
0
deeznutzAuthor Commented:
I simply changed my code to use SQL authentication which was simplier for me, none of the suggestions worked unfortunately
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.