HOW TO ENABLE ENCRYPTION ON SQL SERVER 2005

HOW TO ENABLE ENCRYPTION ON SQL SERVER 2005

Post by Phoeni » Tue, 19 Jun 2007 14:06:50


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

HOW TO ENABLE ENCRYPTION ON SQL SERVER 2005

Post by UGFrLU1pbm » Tue, 19 Jun 2007 20:04:00

See whether the following documentation is useful:
http://www.yqcomputer.com/

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

Ming.
MDAC Team, Microsoft.





> Through MMC but an erro message appears saying No certification >> authority foundgt; > We don 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 Tiwar>
>>
>

 
 
 

HOW TO ENABLE ENCRYPTION ON SQL SERVER 2005

Post by Phoeni » Tue, 19 Jun 2007 20:25:44

On Jun 18, 4:04 pm, Pak-Ming Cheung [MSFT]


> > Through MMC but an erro message appears saying No certification >>>> authority foundgt; > > We don 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 >

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
 
 
 

HOW TO ENABLE ENCRYPTION ON SQL SERVER 2005

Post by UGFrLU1pbm » Sun, 24 Jun 2007 22:45:00

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

>>
> Hi Pak-Ming >
>>
> I have already tried those steps but no use as we don't have an>
> certification authority installed in our domain>
> So I wanted to know an alternate method to this. The ERROR msg whic>
> comes after selecting "Request Ne>
> Certificate" from ALL TASKS in Personal/Certificates>
>>
> Thanks a million for the link and all the help so far , I am reall>
> grateful to you and appreciate your help>
>>
> Thanks & Regards>
>>
> Sudhansu Tiwar>
>>
>