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:
>

ms sql image data from my-sql

hi people

I have imported "blob" data from mysql to an ms-sql 2000 "Image" field, using ms- sql enterprise manager. However my c# image veiwer does not work on the imported blob data (it does work on data I add to ms-sql via my web application).

Is there any way I can check that the blob data creates a valid image? If anyone has any ideas of how I can debug the data coming out that would be great. Or perhaps someone can point me to somewhere I can get some help?

any pointers are much appreciated!

Greg

There is an article on migration data from Oracle Unix to SQL you might find useful http://technet.microsoft.com/en-us/library/bb497067.aspx|||

Hi,

Here's one more idea: using ADO and simple vbscript/jscript you could save the blob to a file (using the chunk or stream model for BLOBs). Then simply open the file in an image viewer.

In addition, you could use similar approach and do byte-comparison with the data from the MySQL source.

HTH,
Jivko Dobrev - MSFT
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

ok thanks guys, however I think my image data was simply corrupt after all of our efforts :-)