all groups > sql server connect > july 2007 >
You're in the

sql server connect

group:

Error while running service


Error while running service Arati
7/30/2007 10:03:38 AM
sql server connect:
Hi,

I have created .net windows service for running an exe. Exe is running
fine. It is used for inserting xml data in sql server database.

My service mode is automatic. Whenevr i start my computer it is
throwing me an error below :-

"An unhandled exception of type 'system.data.sqlclient.sqlexception'
occured in system.data.dll.

Additinal information : A connection was successfully established with
the server.but then an error occured during prelogin handshake.
(provider - SSL provider , error : 0 - the messege or signature
provided for verification has been altered"

When i start service in manual mode it runs perfectly fine. Can
someone please help me in this regard?

Arati
Re: Error while running service JPD
7/31/2007 12:00:00 AM
Hi Arati,

I've seen a similar problem just last week. In that case we deleted all
certificates on the server and everything worked perfectly.

Jonathan


[quoted text, click to view]
Re: Error while running service Arati
8/1/2007 9:00:52 PM
[quoted text, click to view]

Hi,

Are you talking about server certificates for IIS or sql server?

Regards,
Arati
Re: Error while running service Jonathan Psaila-Depasquale
8/2/2007 12:00:00 AM
Hi Arati,

You have delete all existing certificates on the server no matter what
purpose they are serving. In the case I encountered last week the
problem certificate was for SharePoint.

Jonathan


[quoted text, click to view]
Re: Error while running service Arati
8/2/2007 5:49:44 AM
On Aug 2, 6:30 am, Jonathan Psaila-Depasquale
[quoted text, click to view]

Hi,

There are no certificates for IIS server. And I don't know where I can
find certificate for sql server. Do you have any idea on this?

Regards,
Arati
Re: Error while running service Jonathan Psaila-Depasquale
8/3/2007 12:00:00 AM
Hi,

Open an MMC console. Go to File | Add/Remove Snap-in. Click on Add and
select Certificates. Choose Computer Account and then Local Computer.
Click Finish, Close, OK.

In the tree on the left expand Certificates (Local Computer), then click
on Personal. You need to delete all certificates that appear in the
details pane.

Jonathan



[quoted text, click to view]
AddThis Social Bookmark Button