Re: HOW TO ENABLE ENCRYPTION ON SQL SERVER 2005

Tech-Archive recommends: Fix windows errors by optimizing your registry

First, is it possible to configure a Enterprise Certificate Authority in your
domain? If so, see the documentation for detail:
http://www.windowsitpro.com/Article/ArticleID/14923/14923.html
http://searchwindowssecurity.techtarget.com/generic/0,295582,sid45_gci1148690,00.html

After you setup the Enterprise Certificate Authority, I think you can now
"request new certificate" successfully.

In case, if you cannot setup the Enterprise Certificate Authority in your
domain for some reason, there is a new mechanism in SQL Server 2005 that will
generate a self-signed certificate. See
http://blogs.msdn.com/dataaccess/archive/2005/08/05/448401.aspx for detail.
Please note that you need to disable the server validation in client.

However, you are recommended to create a Enterprise Certificate Authority in
your domain whenever it is possible.

For more detail explanation on the security of SQL Server, please visit:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.security&lang=en&cr=US


Ming.
MDAC Team, Microsoft.



"Phoenix" wrote:

On Jun 18, 4:04 pm, Pak-Ming Cheung [MSFT]
<PakMingCheungM...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
See whether the following documentation is useful:http://support.microsoft.com/kb/316898

Reply if the problem cannot be solved. You may also contact the support of
JSQLConnect.

Ming.
MDAC Team, Microsoft.

"Phoenix" wrote:
Hi Masters ,

Please have a look on the following issue :

We have a MS - SQL Server 2005 Server which is accessed through
many client machines . We use JSQLConnect to communicate with
the server from client machine. Problem is when we enable SECURITY
on the server machine , the communication fails with the following
error :

Log:Cannot connect to database,
reason:com.jnetdirect.jsql.JSQLException:
Failed Logon:com.jnetdirect.jsql.JSQLException: DBComms.error reading
input. Context:Read packet header, Unexpected end of stream,
readBytes:-1, negative read result, PktNumber:0, ReadThisPacket:0,
PktDataSize:4096 url:jdbc:JSQLConnect://localhost/database=master/
user=sa/password=<Password>

Any Idea why it is failing ? Do I need to install a certificate on my
SQL Server , if
Yes KINDLY LET ME KNOW THE PROCEDURE. I tried installing certificate
Through MMC but an erro message appears saying “ No certification
authority found”
We don’t have a certification authority , so please let me know an
alternate solution for
This.

My Environment is as follows :

JDK 1.5
Platform : HP-UX & Windows 2000
JSQLConnect 5.5

Thanks to you all in advance , Any response is most welcome 

Thanks & Regards,

Sudhansu Tiwari

Hi Pak-Ming ,

I have already tried those steps but no use as we don't have any
certification authority installed in our domain.
So I wanted to know an alternate method to this. The ERROR msg which
comes after selecting "Request New
Certificate" from ALL TASKS in Personal/Certificates.

Thanks a million for the link and all the help so far , I am really
grateful to you and appreciate your help.

Thanks & Regards,

Sudhansu Tiwari


.

Relevant Pages