June 16, 2009 at 10:15 am
Hi
I've installed an SQL2008 instance (Developer 64bit on win32 Ent 64bit sp2), but I get the following message:
There was an error on the connection. Reason: 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.)
The server already has a SQL2000 32bit instance on the server, so the 2008 instance is a named instance. The 2008 instance works, but DBMail doesn't, giving the same message.
Can anyone tell me what this message means?
Thanks
Andy
June 17, 2009 at 8:10 am
Hello Andy, I've ran across similar problems while trying to install a new instance of SQL Server 2005 Express Edition with Advanced Services on a Windows Server 2003 machine that already had an instance of SQL Server 2005 Standard.
This system was also the functioning as the companies production web server which had SSL certificates installed (in IIS6). After talking to one my coworkers, he said the only way around this is to uninstall ALL of the SSL certificates in IIS, install SQL Server and then reinstall ALL of the SSL certificates. :w00t:
Since this their only production web server and I don't know how to install/uninstall SSL certificates in IIS, I was fortunate enough to have another server that I could install SQL on.
My coworker said that this is the solution that he got from Microsoft too... :ermm: I don't remember the details of the conversation, but he said that it had something do with the services trying to connect to the computer, but the SSL was confusing it.
I know the solution is kind of a pain, but I hope this helps. 🙂
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply