For some reason, I'm no longer able to connect to any database on SQL Server.
If I click on the + sign before a Data Connection in Visual Studio Server Explorer, a Logon dialog opens. Whatever I enter in the dialog results in the following error message:
Connection failed.
Sql State: '0 80001'
Sql Server Error: 18
[DBNETLIB][ConnectionClient(SEDC.ClientHandshake().] SSL Server error
Help please.
What version of SQL Server are you using?
Have you tried connecting through some other method, such as using sqlcmd/osql or Management Studio/Query Analyzer?
What errors appear in the server errorlog?
Thanks
Laurentiu
I'm using SQL Server 2000.
I've tried several ways to connect, all unsuccessful.
With Management Studio, I get the following error:
Cannot connect to COMPAC
Additional Information:
A connection was successfully established with the server, but then an error occurred during the pre-login handshake (provider: SSL Provider, error: 0- The token supplied to the function is invalid) (Microsoft SQL Server)
With Query Analyzer
Unable to connect to server COMPAC
Server: Msg 18, level 16, State 1
[Microsoft]]ODBE SQL Server Driver]
[Shared Memory] SSL Security Error
With Enterprise Manager
A connection could not be established to (local)
Reason: SSL Security error
Connection Open (SECDoClientHandshake())
Please verify SQL Server is running and check your SQL Server registration properties(by right-clicking on the (local) node and try again.
(The Server was running according to SQL Service Manager, and right-clicking said node/properties returned the same error)
Thanks for your consideration.
|||Is there an error in the server errorlog? Look into MSSQL\Log directory for the latest ERRORLOG files. If there is an error there, please add it to this thread.
I'll move the thread to the data access forum, where someone might be able to help with this issue.
Thanks
Laurentiu
I'm not up on reading the errorlog, so I've posted it at
http://www.e-windowsonline.com/errorlog.html
Thanks again
|||The errorlogs don′t show anything in this case, the database is started up just fine. Have a look at the articles [1] and [2] at KB. Seems that you are trying to use SSL top connect to the server. Did you make the appropiate settings for SSL ? If you do not want to use SSL you have to disable the enforcement of encryption at the client and server side, otherwise the connection will be refused if not encrypted.
The settgin is stored at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SuperSocketNetLib as of [3].
[1] http://support.microsoft.com/default.aspx?scid=kb;en-us;309398
[2] http://support.microsoft.com/default.aspx?scid=kb;en-us;302409
[3] http://support.microsoft.com/default.aspx?scid=kb;en-us;841695
HTH, jens Suessmeyer.
http://www.sqlserver2005.de
|||I am moving the thread to the data access forum, because there's no login failure message in the log.
Thanks
Laurentiu
Thanks for your email.
I check the settings at the key referred to and found the following:
ab (Default) REG_SZ (value not set)
ab Protocolorder REG_MULTI_SZ tcp np
and the key contains a folder TDS with:
ab (Default) REG_SZ (value not set)
ab (local) REG_SZ 7.0
ab COMPAC REG_SZ 7.0
Do you see any changes that need to be made?
Thanks
|||Hi,
It is possilbe that if you enabled client-side 'force encryption' option but the sql server does not support SSL from server-side.
Please open Client Network Utility, (you can run cliconfg.exe from the Run menu). Make sure that 'foce encryption' is not checked.
Thx, -Justin
|||Mostlikely, this is because your server does not have trusted certificate and client driver is configured to "Force protocol encryption". If you truly need to force encryption, you can take a look at
http://blogs.msdn.com/sql_protocols/archive/2005/10/04/476705.aspx
Otherwise, you can use cliconfg.exe to turn off "Force protocol encryption". option.
