Friday, March 30, 2012

MSSQL 2000 SSL Snapshot problem

Currently I am running 2 MSSQL SQL 2000 Enterprise servers running on Win2k3
utilizing SSL via "force protocol encryption". The systems are running fine
with the exception of Snapshots and/or DTS packages that write to the local
disk. When trying to get a snapshot to run for the local machine I recieve
the following error:
General network error. Check your network documentation.
(Source: SERVER (Data source); Error number: 11)
If I turn off "force protocol encryption" the snapshot works just fine.
I suspect the replication binaries do not support SSL. You should contact MS
(PSS) for further clarification on how to configure this.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"PSchultz" <PSchultz@.discussions.microsoft.com> wrote in message
news:A6ECD0B1-87BD-4D41-9A80-48E26BAA155A@.microsoft.com...
> Currently I am running 2 MSSQL SQL 2000 Enterprise servers running on
> Win2k3
> utilizing SSL via "force protocol encryption". The systems are running
> fine
> with the exception of Snapshots and/or DTS packages that write to the
> local
> disk. When trying to get a snapshot to run for the local machine I
> recieve
> the following error:
> General network error. Check your network documentation.
> (Source: SERVER (Data source); Error number: 11)
> If I turn off "force protocol encryption" the snapshot works just fine.
>
|||Some tables will successfully produce a snapshot, however, it is quite hit or
miss so I believe that the binaries do support SSL. I've also looked into it
being a possible issue with a timeout, however, that isn't the root cause as
the error occurs within seconds of the snapshot starting
"Hilary Cotter" wrote:

> I suspect the replication binaries do not support SSL. You should contact MS
> (PSS) for further clarification on how to configure this.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "PSchultz" <PSchultz@.discussions.microsoft.com> wrote in message
> news:A6ECD0B1-87BD-4D41-9A80-48E26BAA155A@.microsoft.com...
>
>
sql

No comments:

Post a Comment