Encryption not supported on SQL Server

Discussion in 'ASP General' started by Nithi Gurusamy, Sep 8, 2004.

  1. 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
    Nithi Gurusamy, Sep 8, 2004
    #1
    1. Advertising

  2. Nithi Gurusamy

    Jason Brown Guest

    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" <> wrote in message
    news:#...
    > 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
    >
    >
    Jason Brown, Sep 8, 2004
    #2
    1. Advertising

  3. 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" <> wrote in message
    news:uhT$...
    > 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" <> wrote in message
    > news:#...
    > > 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
    > >
    > >

    >
    >
    Nithi Gurusamy, Sep 8, 2004
    #3
  4. Nithi Gurusamy

    Jason Brown Guest

    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" <> wrote in message
    news:...
    > 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" <> wrote in message
    > news:uhT$...
    > > 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" <> wrote in message
    > > news:#...
    > > > 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
    > > >
    > > >

    > >
    > >

    >
    >
    Jason Brown, Sep 9, 2004
    #4
  5. Nithi Gurusamy

    Nick Malik Guest

    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" <> wrote in message
    news:...
    > 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" <> wrote in message
    > news:uhT$...
    > > 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" <> wrote in message
    > > news:#...
    > > > 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
    > > >
    > > >

    > >
    > >

    >
    >
    Nick Malik, Sep 9, 2004
    #5
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Geoff
    Replies:
    3
    Views:
    424
    Patrick.O.Ige
    Jan 16, 2006
  2. Mark Carter
    Replies:
    2
    Views:
    876
    Jp Calderone
    Dec 30, 2003
  3. Michele Simionato

    STARTTLS extension not supported by server

    Michele Simionato, Nov 15, 2010, in forum: Python
    Replies:
    2
    Views:
    1,961
    Michele Simionato
    Nov 29, 2010
  4. Mike Swaim
    Replies:
    0
    Views:
    119
    Mike Swaim
    Aug 10, 2004
  5. Jerry Maguire

    sql server encryption

    Jerry Maguire, Aug 24, 2003, in forum: ASP General
    Replies:
    1
    Views:
    93
    Bob Barrows
    Aug 24, 2003
Loading...

Share This Page