Re: Using SSL with named instance

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

Date: Tue, 8 Mar 2005 11:35:29 +0530

I tried using alias for the named instance as MyServer_second and then tried
to connect on the same machine. It worked this time.
Is there any issue with using named instance with SSL.

"Ajey" <ajey5@hotmail.com> wrote in message
news:ObHXh%230IFHA.3336@TK2MSFTNGP10.phx.gbl...
> 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
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: SSAS with an Instance name
    ... I would also highly recommend moving the server to SP1 -- there were several ... Try out the MSDN Forums for Analysis Services at: ... Please do not send email directly to this alias. ... We are able to connect to the named instance from Excel without passing ...
    (microsoft.public.data.xmlanalysis)
  • Re: SSAS with an Instance name
    ... The SQL 2005 server is a named instance. ... Try out the MSDN Forums for Analysis Services at: ... Please do not send email directly to this alias. ...
    (microsoft.public.data.xmlanalysis)
  • Re: SSAS with an Instance name
    ... connect to the named instance (e.g. try to use Excel on that machine to ... connect to that server). ... Please do not send email directly to this alias. ... but it brings an error: Datasource Local Analysis Server not ...
    (microsoft.public.data.xmlanalysis)
  • Re: SSAS with an Instance name
    ... We are able to connect to the named instance from Excel without passing ... connect to that server). ... Please do not send email directly to this alias. ... but it brings an error: Datasource Local Analysis Server not ...
    (microsoft.public.data.xmlanalysis)
  • 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)