cannot connect - SQL Server Forums

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