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

Re: ms sql management studio login error 80 80

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

Re: ms sql management studio login error 80 80

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.