Re: SSL Security Error

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


Yes McDonnel,

We also receive the same error. But the issue is a bit different. The
environment had changed from Windows 2000 to Windows 2003. The SQL DB
Server machine also got changed from Windows 2000 to Windows 2003.

Now we got an application which actually imports data into the DBServer
database.

When the application is manually invoked and run after filling in the
text boxes with necessary information import was successful.

But when the same application is invoked using a batch script file, the
application is started and all the parameters are filled in the text
boxes of the application. But import doesnt happen. We get two types of
error at different times.

First one is
-----------
2006\06\06 11:56:09 General SQL error.
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
(SECDoClientHandshake()).
Alias: PRODUS

Second one is
-------------
2006\06\26 06:52:56 Read failure.
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite
(SECEncryptData()).
Alias: PRODUS


From your discussion I understand some secure connection request is
trying to establish from client. But if that is the case why should it
work when manually invoked and why shouldnt it work when invoked with a
batch.



Thanks in Advance
Suresh Kannan from India


--
sureindia
------------------------------------------------------------------------
sureindia's Profile: http://www.dbtalk.net/m476
View this thread: http://www.dbtalk.net/t153695

.

Relevant Pages

  • Windows Impersonation authentication to SQL Server?
    ... Impersonation will each Windows Domain user accounts need to be granted ... all be tracked and displayed in SQL Profiler? ... or SQL security but the article is discussing Windows security. ...
    (microsoft.public.sqlserver.security)
  • Re: Windows Authentication to SQL Server?
    ... oranges in trying to convert an asp.net app which uses forms authentication ... mode throughout the app with one SQL login account into SQL Server versus ... converting the asp.net app into a full individual Windows authentication ... Ultimate goal would be to see the individual windows ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • [TOOL] Resources for Combating the Slammer Worm
    ... installations of Microsoft® SQL Server™ and the Microsoft SQL Server ... SQL Server 2000 SQL Scan Tool ... runs on computers running Windows 2000 or higher and can identify ... Check runs on computers running Windows 98, Windows ME, Windows NT 4.0, ...
    (Securiteam)
  • Re: connection options to yukon
    ... If you use TLS you can increase the security of your SQL auth ... connection but unless you're good at setting up groups/schema/logins/users, ... Windows auth is slower as the domain must ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Connect problem MSDE ADO ASP
    ... problems on setting the IIS User password. ... result - and both can access the MSDE SQL via the webinterface (I am aware I ... > your connection string, and put in a valid SQL USER ACCOUNT, not a Windows ...
    (microsoft.public.sqlserver.programming)