I rarely write blog to complain about something. I would rather like to share useful information instead. But this time, I got so frustrated installing SQL2008.
Originally, I have Windows 7 installed with SQL2008 Server. My company has an product that require a file call “SQLDMO.DLL” to be register. (i.e. regsrv32 sqldmo.dll). Unfortunately I kept getting an –2147024770 error.
After trying everything, I decided to uninstall SQL2008 Server and hopefully by reinstalling it would let me register sqldmo.dll.
Btw, I turned off my firewall and UAC just in attempt to register sqldmo.dll…. but nothing works.
Originally, I installed SQL2008 from a MSDN CD follow by an SP1 installation. My colleague suggested me to install SQL2008Express install from one of our company shared directory. So this is what had happened.
- Install SQL2008Express from company network
- Complain about Windows 7 compatibility issue, click continue
- Go online, cannot find SQL2008Express SP1 upgrade, instead, just the full SQL2008Express SP1 installation
- Uninstall install existing SQL Server just to be safe.
- Download and install SQL2008Express from here
- Installation works, but can’t find SQL Management Studio
- Download and install SQL Management Studio from here
- The setup screen didn’t say anything bout Management Studio, install, it is the same screen as regular SQL Express installation wizard.
- Try install it, failed, because I have SQL installed
- Find another download link: http://www.microsoft.com/express/sql/download/
- Try to install “Runtime with Management Tools”
- Cannot install since I have SQL installed
- Try install “Management Tools”
- Complain about Windows 7 compatibility issue, ignore it
- Finally, I got SQL Management Studio
I downloaded total of over 2GB of installation files, took me to whole morning to do it. Yet, I still cannot register sqldmo.dll.
Solution
Ultimately… it turns out that all I needed to do is install SQLDMO from SQL Server 2005 Backward Compatibility components. Yikes, wasted 1/2 of my day.