Re: SQL Encryption

From: Robert Abela (robert_at_gfi.com)
Date: 09/09/03 

Date: Tue, 9 Sep 2003 17:07:50 +0200

This worked out fine for me :) though i am having a problem replicating the
db, once i try to run the snapshot it is failing :\
"Jasper Smith" <jasper_smith9@hotmail.com> wrote in message
news:%23aQ9b19cDHA.1580@tk2msftngp13.phx.gbl...
> Make sure that the name on the certificate is the FQDN of the server and
> also that you install the certificate when logged in as the SQL Service
> account.
>
> --
> HTH
>
> Jasper Smith (SQL Server MVP)
>
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
> "Robert Abela" <robert@gfi.com> wrote in message
> news:eIuXkK8cDHA.1728@TK2MSFTNGP09.phx.gbl...
> Hi I am trying to connect 2 sql servers over the internet, though I want
to
> use Encryption. I was told to make a server certificate so that I could
use
> SQL replication. I made a server certificate though sql service is
failing
> to start cause of an "Invalid certificate". Any idea what type of
> certificate or "how to" make a proper server certificate to be used from
sql
> please?
>
> Regards,
> Robert Abela.
>
>
>

Relevant Pages

  • Re: SQL Encryption
    ... I managed to make sql ... If I Disable SSL it works out fine:\ any ideas what this could be? ... How SQL Server Uses a Certificate When the Force Protocol Encryption ... I was told to make a server certificate so that I could ...
    (microsoft.public.sqlserver.security)
  • Re: Security Update for SQL Server 2005 Service Pack 2 (KB948109)
    ... I don't even know if I need this SQL Server and I have ... > account password, invalid user account, user account does not have ... To help you determine which service is failing to start,> view ...
    (microsoft.public.windowsupdate)
  • Re: Services Failing to Start
    ... > to reference the SQL agent service not the main one ... Does the MSSQLServer service manually start OK? ... check the server event logs, enable SQL Server Audit Failed ... that attempt to narrow down which application is failing and whether that ...
    (microsoft.public.sqlserver.setup)
  • Re: strawberry perl and sql server
    ... my connection is failing: ... The error here is that sql_init is a global method, ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.server)
  • Re: Error : Difference of two datetime columns caused overflow at runtime.
    ... > At my job is a dts package that is failing in SQL 2005. ... I am not a SQL ... I put the query in Query Analyzer ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)