Msde Istallation Problems And Solutions

The goal is: Make installation program procedure to successfully install MSDE 2000

Know something more or something is not correct on this page? You are welcome to edit this page. Use the link in bottom left.

Offtopic?

INF: Customizing SQL/MSDE Unattended Installation Files http://support.microsoft.com/default.aspx?scid=kb;EN-US;q233312 (APPLIES TO • Microsoft SQL Server 7.0 Standard Edition • Microsoft Data Engine 1.0) So does not help at all today.
Customizing Desktop Engine Setup.exe http://msdn.microsoft.com/library/en-us/distsql/distsql_84xl.asp

All in one problem solver

setup sapwd=mypassword securitymode=sql disablenetworkprotocols=0
http://www.mssqlcity.com/Articles/Adm/SQL70InstProbl.htm

By my experience, most problems are there with having correct MDAC 'MDAC version checking and setup

Component Checker: Diagnose problems and reconfigure MDAC installations http://support.microsoft.com/default.aspx?scid=kb;EN-US;307255

How To MDAC Setup Troubleshooting Guide http://support.microsoft.com/default.aspx?kbid=232060
- Manually extract Mdac_typ.exe. When you run the MDAC setup, it extracts all the setup files into the system defined TEMP directory first before continuing. You can manually extract the MDAC files yourself and run the setup directly as well. This is a good trouble-shooting step if you think that the computer may not have a properly defined TEMP folder. To extract the MDAC setup files, copy the MDAC installer (Mdac_typ.exe) to the C:\ root folder and run the following command from Start menu click Run:
- Use logging. The MDAC setup program has advanced setup logging capabilities. You can run MDAC Setup with log file generation and then examine the log file to determine what portion of MDAC setup failed. This log file will also contain any errors that occur during installation. In order to run MDAC setup with logging, first extract out the MDAC setup program as detailed in the earlier section and then run the following command from Start menu click Run:

C:\MDACSetup\Setup.exe /gc C:\Mdaclog.txt

C:\mdac_typ.exe /c /t:c:\MDACSetup
The above command starts the MDAC installer and extract the files into a folder named C:\MDACSetup (it automatically creates the folder if it does not exist). Once the files are extracted, the MDAC installer quits (it does not attempt to install MDAC). Once the files are extracted, run the extracted Setup.exe inside the C:\MDACSetup folder to start the MDAC installer in "extracted mode".

Single known problems and solutions

Q: What is the difference between SP3 and SP3a ?

Microsoft has removed the download of SP3 from its site and has included the SP3a download only. The version of SQL Server found after we apply SP3 or SP3a is 8.00.0760. But ssnetlib.dll version on the server would be 2000.80.760.0 for SP3 and 2000.80.766.0 for SP3a. SP 3a is the same as SP3, but fixes 3 installation problems. [http://support.microsoft.com/?kbid=306908]

A SQL Server Desktop Engine 2000 installation fails when it tries to register Performance Monitor counters
Desktop Engine Upgrade of MSDE 1.0 Fails
- http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q271/8/87.asp&NoWebContent=1
MSDE Installation Fails on Systems That Have SQL Server 2000 Service Pack 1 or 2 Installed
- http://support.microsoft.com/default.aspx?scid=kb;EN-US;299351
320873 - HOW TO Manually Remove a Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Instance
- http://support.microsoft.com/default.aspx?scid=kb;en-us;320873
How to get MDAC version via SQL? EXEC master..xp_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\DataAccess?', N'Version'