[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1528
  • Last Modified:

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?
0
deeznutz
Asked:
deeznutz
1 Solution
 
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
[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

 
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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now