Re: Using SSL with named instance

From: Ajey (ajey5_at_hotmail.com)
Date: 03/07/05

  • Next message: Adam Machanic: "Re: Windows Authentication" 
    Date: Tue, 8 Mar 2005 01:25:32 +0530

    I tried with other machines. In other case I could connect to the named
    instance through other machine but could not connect to named instance on
    same machine

    "Ajey" <ajey5@hotmail.com> wrote in message
    news:%23WhfQFzIFHA.2132@TK2MSFTNGP14.phx.gbl...
    > I can connect to the named instance using Enterprise Manager but not
    through
    > Query Analyser (on the same SQL Server with 'Force Protocol Encryption'
    for
    > client connections)
    >
    > "Ajey" <ajey5@hotmail.com> wrote in message
    > news:%23YHIaxyIFHA.3324@TK2MSFTNGP10.phx.gbl...
    > > Hi,
    > > I created the certificate on the target SQL Server. Here I am
    having
    > > two instances (default & named). In the connection string I used 'Use
    > > Encryption for data=true'. I also added the CA of server under 'Trusted
    > Root
    > > CA' on client. Now, from client side I could connect to default instance
    > and
    > > not to named instance. Then I enabled 'Force PRotocol Encryption' on
    > client
    > > side. Through Query Analyser, I could connect to default instance but
    not
    > > to named instance. Then I enabled 'Force Protocol Encryption' for
    clients
    > > (using client network utility) on the Server itself. There also i could
    > > connect only to default instance and not to the named instance.
    > > For named instance i am getting the following error:
    > > Server: Msg 18, Level 16, State 1
    > > [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SSL Security error.
    > >
    > > I followed the following steps to enable the encryption:
    > > - Installed the 'Certificate' service through Add\Remove and created
    > the
    > > Enterprise Root CA
    > > - Loaded the 'Certificates' snapin and in the 'Personal' folder
    > created
    > > the certificate for the machine.
    > > - On the client in 'Trusted Root CA' i imported the CA from server.
    > >
    > > Is there anything I am missing?
    > >
    > > Thanks.
    > > Ajey
    > >
    > >
    >
    >

  • Next message: Adam Machanic: "Re: Windows Authentication"

    Relevant Pages

    • Re: highly appreciated.
      ... First of all David, thanks for your reply.... ... I am at client computer and how client computer diagnose MY_COMPUTER\SQL2 ... I did findout the port No of named instance through SQL Server ...
      (microsoft.public.sqlserver.clients)
    • Re: connect to named instances
      ... Your client system likely has an older version of MDAC. ... higher to connect to a named instance without requiring an alias. ...
      (microsoft.public.sqlserver.server)
    • Re: Using SSL with named instance
      ... I can connect to the named instance using Enterprise Manager but not through ... > I created the certificate on the target SQL Server. ... > CA' on client. ... Then I enabled 'Force PRotocol Encryption' on ...
      (microsoft.public.sqlserver.security)
    • Re: Exposed Object vs Remoting server
      ... Allow the server to access the same object which is remoted to the clients ... Declare and instantiate a named instance of your remote object. ... > I have a remoting server which exposes a Singleton object to a client. ...
      (microsoft.public.dotnet.framework.remoting)
    • Named Instance
      ... I couldn't connect to named instance in my client machine... ... error messange.. ... SQL Server Doesn't exist or Access denied. ...
      (microsoft.public.sqlserver.clients)