Search:   Namespaces Discussions .NET v1.1 Feedback

Encryption not supported on SQL Server Messages   Related Types This message was discovered on microsoft.public.dotnet.general. Responses highlighted in red are from those people who are likely to be able to contribute good, authoratitive information to this discussion. They include Microsoft employees, MVP's and others who IMHO contribute well to these kinds of discussions. Post a new message to this list... Nithi Gurusamy I am facing this error after making changes to client configuration utility of SQL Server 2000: Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Encryption not supported on SQL Server. [SqlException: Encryption not supported on SQL Server.] System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +484 System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnec tionString options, Boolean& isInTransaction) +372 System.Data.SqlClient.SqlConnection.Open() +384 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter [] commandParameters) +54 Reply to this message...        Jason Brown (VIP) try here: http://support.microsoft.com/default.aspx?kbid=318605 -- Jason Brown Microsoft GTSC, IIS This posting is provided AS IS with no warranties, and confers no rights. "Nithi Gurusamy" <Click here to reveal e-mail address> wrote in message news:#Click here to reveal e-mail address... > I am facing this error after making changes to client configuration utility [Original message clipped] Reply to this message...        Nithi Gurusamy Hi Jason: Thanks for the reply. I rolled back all the changes I made using SQL Server Client Network Utility. I used this program for configuring a remote SQL server as per the steps of WebMatrixHosting.com who provides .NET environment for my test application. I rolled back all changes and still it came back with the same problem. Actually my web application is not at all using the remote database. It is using the SQL2000 database in the local machine itself. Any suggestions? Thanks Nithi Gurusamy "Jason Brown" <Click here to reveal e-mail address> wrote in message news:uhT$Click here to reveal e-mail address... [Original message clipped] Reply to this message...        Nick Malik Hi Nithi, The article explains that if your client is set up to use the Force Protocol Encryption option with any SQL Server, it must use it with All SQL Servers. If WebMatrixHosting provides a SQL Server where this option is on, your client will have to use it. I guess I don't understand how your situation is different from that described in the KB article. Please tell me what the environment looks like. --- Nick "Nithi Gurusamy" <Click here to reveal e-mail address> wrote in message news:Click here to reveal e-mail address... [Original message clipped] Reply to this message...        Jason Brown (VIP) SO you're saying you followed the steps outlined in the article and still the same issue? -- Jason Brown Microsoft GTSC, IIS This posting is provided AS IS with no warranties, and confers no rights. "Nithi Gurusamy" <Click here to reveal e-mail address> wrote in message news:Click here to reveal e-mail address... [Original message clipped] Reply to this message...     System.Data.CommandType System.Data.SqlClient.SqlConnection System.Data.SqlClient.SqlException System.Data.SqlClient.SqlParameter Ad MBR BootFX Best-of-breed application framework for .NET projects, developed by Matthew Baxter-Reynolds and MBR IT

Copyright © Matthew Baxter-Reynolds 2001-2008. '.NET 247 Software Development Services' is a trading style of MBR IT Solutions Ltd. Contact Us - Terms of Use - Privacy Policy - www.dotnet247.com