tags:

views:

30

answers:

1
Q: 

SQL 2005 - SSL Security error at connection

A client of mine has an application that is being migrated from SQL 2000 to SQL 2005. After the DB migration, the following error is occurring when the application tries to execute a SQL query.

xSomeClassTools: 3/30/2010 9:27:42 AM-ErrorMessage:SSL Security error.- StackTrace:
at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnection.Open()
at xSomeApplication.Tools.xSomeClassTool.writeRecord(String fieldChanged, String newValue, String dn) in c:\inetpub\wwwroot\xSomeApplication\components\xSomeClassTool.cs:line XXX

Beyond the account used by the application, I don't have access to the SQL server. According to the DBA's they have a default installation of SQL 2005, with the database migrated from SQL 2000. Has anyone seen this error before and know how to resolve it?

A: 

http://support.microsoft.com/kb/316898

Perhaps they need to install a cert?

Sam  2010-03-30 16:36:49
Using the installation process for SQL 2000 we verified that the old server did not require a cert. I also asked them to look for self signed certificates. The SQL 2000 server did not have any, but the SQL 2005 server did have a self signed root certificate. I tried to get them to temporarily remove it, but they were not willing to.
Nick  2010-03-30 21:54:47

related questions

Is it better to create Model classes, or just stick with generic database utility class?
What are effective options for embedding video in an ASP.NET web site?
Visual Studio 2008 debugger already attached work-around
Tracking state using ASP.NET AJAX / ICallbackEventHandler
ASP.NET Display SVN Revision Number
ASP.NET URL Rewriting
How can I change the background of a masterpage from the code behind of a content page?
Easy way to AJAX WebControls
How do I define custom web.config sections with potential child elements and attributes for the properties?
ASP.NET MVC "CRUD" Database Sample
Are Multiple DataContext classes ever appropriate?
How to RedirectToAction in ASP.NET MVC without losing request data
Triple Quotes? How do I delimit a databound Javascript string parameter in ASP.NET?
ASP.NET built in user profile, Vs old stile user class/tables
What's a good book for learning ASP?
Bandwith throttling in IIS 6 by IP Address
ASP .Net Custom Client-Side Validation
How to get the value of built, encoded ViewState?
Decent, simple, GIS/mapping component for ASP.NET?
Checklist for IIS 6/ASP.NET Windows Authentication?
How to write to Web.Config in Medium Trust ?
ASP.NET, Visual Studio and Subversion - how to integrate?
Floating Point Number parsing: Is there a Catch All algorithm?
How do I sync the SVN revision number with my ASP.NET web site?
ASP.NET Site Maps