Re: Using SSL with named instance
From: Ajey (ajey5_at_hotmail.com)
Date: Mon, 7 Mar 2005 21:48:25 +0530
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
"Ajey" <firstname.lastname@example.org> wrote in message
> 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
> CA' on client. Now, from client side I could connect to default instance
> not to named instance. Then I enabled 'Force PRotocol Encryption' on
> 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
> Enterprise Root CA
> - Loaded the 'Certificates' snapin and in the 'Personal' folder
> the certificate for the machine.
> - On the client in 'Trusted Root CA' i imported the CA from server.
> Is there anything I am missing?