Re: SQL Server 2005 SSL

So issuing a certificate from our Certificate Server (which is on a
different domain than our new IIS machine) would work in that https would be
able to do on the new IIS machine to our new SQL 2005 machine?

Thanks a bunch for your speedy reply and info Roger. Much appreciated.

J


"Roger Wolter[MSFT]" <rwolter@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:ukK87DBIHHA.1248@xxxxxxxxxxxxxxxxxxxxxxx
Not really, SQL Server certificates are created and stored in the
database. SSL looks for them in the Windows certificate store

--
This posting is provided "AS IS" with no warranties, and confers no
rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

"Noone" <IDontLikeSpam@xxxxxxxxxxx> wrote in message
news:OxdRauAIHHA.4056@xxxxxxxxxxxxxxxxxxxxxxx
Hello. Sorry if I'm off a bit on this question as I'm not too
experienced with SQL 2005 but I am wondering if it's possible to use SQL
2005's new certificate section to enable SSL communications which would
include an https from another IIS machine and any other client connecting
to it over the network. Previously I had to set up a Certificate Server
and issue one on our old SQL 2000 machines which then I could enable SSL
on the web server and client network connections so I was wondering if
the built in SQL 2005 certificate section is able to do all of this and
not have to set up another Certificate Server and issue certificates from
this.

Any info would be appreciated.

J





.

Relevant Pages

  • SQL Server 2005 SSL
    ... with SQL 2005 but I am wondering if it's possible to use SQL 2005's new ... Previously I had to set up a Certificate Server and issue one ... and client network connections so I was wondering if the built in SQL 2005 ... Certificate Server and issue certificates from this. ...
    (microsoft.public.sqlserver.security)
  • using IIS as a client in an SSL session
    ... and the client is an IIS web server.? ... the IIS machine must be able to find a valid client ... This is easy if the certificate subject is unique ...
    (microsoft.public.inetserver.iis.security)
  • Using IIS as client in SSL session
    ... the server (may or may not be an IIS machine) requires ... and the client is an IIS web server.? ... certificate and corresponding private key and present it ...
    (microsoft.public.dotnet.security)
  • Using IIS as a client in an SSL session
    ... the server (may or may not be an IIS machine) requires ... and the client is an IIS web server.? ... certificate and corresponding private key and present it ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: ssl renewal questions
    ... Just on the server which I guess explains the clients being able to ... the certificate is invalid ... >> but connections continue to be encrypted and restarts of sql ... >>> appears that I had to stop and restart the sql process to get certs ...
    (microsoft.public.sqlserver.security)