Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 cannot connect

Author  Topic 

magmo
Aged Yak Warrior

558 Posts

Posted - 2013-08-29 : 03:25:47
Hi


I have set up a SQL server on a local machine for test purpose, when I try to connect through the Sql server Manager I get this message..

A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.) (Microsoft SQL Server, Error: -2146893019)



Anyone know why I get this message and how i fix it?

bandi
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2013-08-29 : 03:29:24
Refer the following link
http://stackoverflow.com/questions/1824579/sql-server-encryption-using-self-signed-ssl-certificate-querying-from-asp-net-3
http://stackoverflow.com/questions/2231500/error-connecting-to-all-of-my-sql-servers
--
Chandu
Go to Top of Page

magmo
Aged Yak Warrior

558 Posts

Posted - 2013-08-29 : 06:56:51
Thanks, but I dont Think this has something to do with a certificate...
Go to Top of Page

magmo
Aged Yak Warrior

558 Posts

Posted - 2013-08-29 : 07:01:15
I found the error, I had by mistake checked "encrypt Connection", after I removed that it worked
Go to Top of Page
   

- Advertisement -