MS SQL SERVER 2005 SSL ISSUE

Hi Friends,
I would be highly grateful if anyone can provide a solution for the
following :
There is a MS-SQL server hosted on a machine which is our data server.
We need to access this data server through many client machines. To
secure the data exchange between client(s) & Data server we use
JSECURE Client for SSL communication. But this secures the channel
between client machine and the machine on which my MS -SQL server
is hosted. Once the data is received on server machine, JSECURE
decrypts the data and sends to the data server. Now if I enable the
SSL
on MS-SQL server , I guess my communication would fail because I
don't
know which algorithms are being used by MS-SQL server & JSECURE
to encrypt their respective data's. So , in this case I need a bridge
between
these two ( Precisely a TRANSLATOR which understands both - JSECURE
& MS-SQL SERVERS).
Please let me know if any such solution exists. Thanks a lot to you
all friends!!Move the file share which the JSECURE connects to, to another machine.
--
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration /
Microsoft Office SharePoint Server 2007: Configuration)
MCITP (dbadmin, dbdev)
"Phoenix" wrote:

> Hi Friends,
> I would be highly grateful if anyone can provide a solution for the
> following :
> There is a MS-SQL server hosted on a machine which is our data server.
> We need to access this data server through many client machines. To
> secure the data exchange between client(s) & Data server we use
> JSECURE Client for SSL communication. But this secures the channel
> between client machine and the machine on which my MS -SQL server
> is hosted. Once the data is received on server machine, JSECURE
> decrypts the data and sends to the data server. Now if I enable the
> SSL
> on MS-SQL server , I guess my communication would fail because I
> don't
> know which algorithms are being used by MS-SQL server & JSECURE
> to encrypt their respective data's. So , in this case I need a bridge
> between
> these two ( Precisely a TRANSLATOR which understands both - JSECURE
> & MS-SQL SERVERS).
> Please let me know if any such solution exists. Thanks a lot to you
> all friends!!
>|||Hi Denny ,
Thanksa lot for the response , being a newbie in this area I was unable to
understand your short comment , kindly elaborate a little whenever you
get some time. Also please have a look on my another post with subject
line as "PROBLEM WITH ENABLE SECURITY OPTION ON MS-SQL SERVER 2005" in this
forum.
Thanks & Regards,
Sudhansu Tiwari
"mrdenny" wrote:
[vbcol=seagreen]
> Move the file share which the JSECURE connects to, to another machine.
> --
> Denny
> MCSA (2003) / MCDBA (SQL 2000)
> MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration
/
> Microsoft Office SharePoint Server 2007: Configuration)
> MCITP (dbadmin, dbdev)
>
> "Phoenix" wrote:
>|||Since the JSECURE software encrytps all communication from the clients to th
e
server, the easiest method to resolving this issue will be to setup a server
specifically for the purpose of being the JSECURE file server. This will
allow database connections to occure normally.
You can also call the company which made JSECURE and ask them if they have a
way to make it work with Microsoft SQL Server hosted on the same server.
--
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration /
Microsoft Office SharePoint Server 2007: Configuration)
MCITP (dbadmin, dbdev)
"Sudhansu" wrote:
[vbcol=seagreen]
> Hi Denny ,
> Thanksa lot for the response , being a newbie in this area I was unable to
> understand your short comment , kindly elaborate a little whenever you
> get some time. Also please have a look on my another post with subject
> line as "PROBLEM WITH ENABLE SECURITY OPTION ON MS-SQL SERVER 2005" in thi
s
> forum.
> Thanks & Regards,
> Sudhansu Tiwari
> "mrdenny" wrote:
>