954,560 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

ms sql management studio login error

hi there,

i have a question in connecting to the server. when i log in to the server and connect to the ms sql server i can connect to the databases. but when i login to another computer and try to login to the MS SQL server management studio i get an error message saying

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.) (Microsoft SQL Server, Error: -2146893019)

what is the solution for this

judithSampathwa
Posting Pro in Training
453 posts since May 2010
Reputation Points: 8
Solved Threads: 0
 

Bad certificate. Go to this link to find out how to manage them.
http://technet.microsoft.com/en-us/library/cc785226(WS.10).aspx

BitBlt
Master Poster
711 posts since Feb 2011
Reputation Points: 367
Solved Threads: 109
 

i figured out the answer
if you go to run and type in Cliconfg.exe and then a window will open,
in thath there is TCP/ IP there i had checked force encryption,
that should be unchecked

judithSampathwa
Posting Pro in Training
453 posts since May 2010
Reputation Points: 8
Solved Threads: 0
 

This question has already been solved

Post: Markdown Syntax: Formatting Help
You
View similar articles that have also been tagged: