Net Industry: Sql Server (MSSQL) msde MSDE 2000 Installation Fails

Thursday, February 03, 2005

Sql Server (MSSQL) msde MSDE 2000 Installation Fails

After installing Visual Studio 2005 my SQL Server 2000 Developer Edition stopped working, giving an error from Enterprise Manager: Unable to connect to server. Reason: SSL security error. ConnectionOpen (SECDoClientHandShake())... Microsoft has this technote about this: Thinking it over, all of these references apply to me:

302409 FIX: Unable to Connect to SQL Server 2000 When Certificate Authority Name Is the Same As the Host Name of the Windows 2000 Computer

275307 BUG: Installation of SQL Server 2000 Desktop Engine Fails on Computers That Already Have SQL Server 7.0 Tools Installed

299351 BUG: MSDE Installation Fails on Systems That Have SQL Server 2000 Service Pack 1 or 2 Installed Too late for me, because I already uninstalled SQL Server 2005 and 2000 beta and everything related. Uninstall SQL Server 2000 didn't work, because somehow the application doesn't show up in the add/remove programs. I can't install MSDE anymore because it gives these errors: "Setup failed to configure the server. Refer to the server error logs and setup error logs for more information." After some searching some people suggested the cause might existing datafiles, but after removing all datafiles, it still doesn't work. Installing with another instancename doesn't help. either These are the MSDE Setup parameters:

SAPWD="[password]" default password for sa user
/l*v [logfile]log the complete installation
SECURITYMODE=SQL install with mixed mode authentication
DISABLENETWORKPROTOCOLS=0 enable access from other computers
DATADIR ="[data folder]" specify a dir other than default
INSTANCENAME="instancename"
BLANKSAPWD=1 Install with blank SA Password. SAPWD overrides this.
ALLOWXDBCHAINING=1 Enables cross-database ownership chaining.
UPGRADEPWD="" Use if your upgrading to SP3
/i
/settings You can specify all MSDE parameters using an ini file in this format: [options] DATADIR ="Data_Folder" INSTANCENAME="Instance_Name"

Examining the logs I came to this problem:

Starting custom action ConfigServerExecuting "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "MSSQLSERVER" -Q "SQL_Latin1_General_CP1_CI_AS""MSI (c) (70:54)

[13:55:09:921]: Font created. Charset: Req=0, Ret=0, Font: Req=MS Shell Dlg, Ret=MS Shell Dlg Setup failed to configure the server. Refer to the server error logs and setup error logs for more information.MSI (s) (D8!24)

[13:55:42:031]: Product: Microsoft SQL Server Desktop Engine -- Setup failed to configure the server. Refer to the server error logs and setup error logs for more information. Action ended 13:55:42: InstallFinalize. Return value 3.

here's someone with the same problem: http://www.masterado.net/home/ng/forum.sqlserver.msde/post13125079.aspx

Here's the microsoft technote on the subject http://support.microsoft.com/default.aspx?scid=kb;en-us;816499&Product=sql2k

Nothing is working, so now I'll try this: HOW TO: Manually Remove a Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Instance

The last post here by the way says that if you disable the SECURITYMODE=SQL, it might work as well. http://community.installshield.com/archive/index.php?t-124746.html

No, it doesn't.

Installing SQL Server 2000 Developer Edition gives me the same problems, they're all related to the (SECDoClientHandShake())... error.

I'm trying to remove the certificate authority installed with selfssl.exe, see another post: Setting up SSL in Windows 2003 & XP (within 10 minutes)

Now I'm trying to remove it using certutil, as described here. certutil.exe is available for Windows XP in the Windows Server 2003 Administration Tools Pack

using this command certutil.exe -delkey "SELFSSL"

I was able to delete the conflicting certificate authority keys, and tried reinstall (after restarting for the zillionth time ofcourse)

Great! it works!

Apply SQL Server Service Pack 3, reinstall the SelfSSL Certificate, and everything should be all right...

conclusion

Solution in a nutshell: http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-connect/1906/SSL-Security-Error-in-WinXP-SP2

Wich links to PRB: SQL Server 2000 Installation or Local Connections Fail with "SSL Security error :ConnectionOpen (SECDoClientHandshake())" Error Message

Labels: Sql Server