Frans Bouma's blog

Generator.CreateCoolTool();

Syndication

News

    Visit LLBLGen Pro's website

    Follow FransBouma on Twitter

    Add to Technorati Favorites

About me

Fun stuff I created

My work

SqlServer 2005's installer... Oracle Quality, at last!

SqlServer 2005's installer is a bit hopeless. It needs IE to get you started. Not a problem. I open the page in IE 6 on XP, I give it permission to run objects/activex and what have you. Then I click a link. "Error on page", IE says.

So hunting through the sourcecode I find a link, to an .hta page. Also doesn't work. So I hunt through that sourcecode as well and find a setup.exe. Unfortunately for me, it was in the Tools folder. I run it, but at the end, of course, no SqlServer 2005 installation. Just docs 'n tools. Though the installer gives you the suggestion everything is installed. It even displays the dialog where it explains you have to run the config wizard to start services.

Why on earth isn't there a single installer, which simply starts with a .exe, like in SqlServer 2000? It's great Sqlserver finally got a lot of Oracle's features, but one 'feature' wasn't that required to be implemented in SqlServer: Oracle's horrible installer.

Ok, take 14...

(Update): Ok, the setup.exe in the Servers folder is the real setup. So don't bother with the setup in the Tools folder nor with the .htm files or .hta files. Also, if you're installing on a system where SqlServer 2000 is already installed, be sure to select during the setup of SqlServer 2005 for a named instance and give it a logical name, like SqlServer2005 (don't include spaces). This way you can refer to the SqlServer instance as yoursystemname\SqlServer2005 in the connection string for connections to SqlServer 2005 and yoursystemname in the connection string for connections to SqlServer 2000.

Another tip: after installation of SqlServer 2005 and/or VS.NET 2005, you'll probably notice a new service which eats a lot of CPU time. This is the NGEN service, which is NGEN-ing the .NET assemblies and sqlserver .net code. So be patient (takes a couple of minutes)

Published Friday, October 28, 2005 4:22 PM by FransBouma

Comments

# re: SqlServer 2005's installer... Oracle Quality, at last!@ Friday, October 28, 2005 10:27 AM

SQL 2000 had a .bat setup script :)

Police

# re: SqlServer 2005's installer... Oracle Quality, at last!@ Friday, October 28, 2005 10:50 AM

Nerd ;)

Frans Bouma

# re: SqlServer 2005's installer... Oracle Quality, at last!@ Friday, October 28, 2005 11:05 AM

The sql2k5 install ran just fine for me, but that is probably because I dropped the security permissions for IE on my system.

The NGEN on 64 bits is REALLY painful.

Wallym

# re: SqlServer 2005's installer... Oracle Quality, at last!@ Friday, October 28, 2005 11:35 AM

I really like your post title and I feel your pain :-) Whoever has installed Oracle products before probably does to.
When I first read it, I thought maybe the installer was also made in Java... Last time I installed ODP.NET, it was a 180 MB download, which would occasionally result in a successful painful install just to get a few DLLs.

Fabrice

# re: SqlServer 2005's installer... Oracle Quality, at last!@ Friday, October 28, 2005 11:52 AM

Another tip: if you want ngen to do all of its work immediately, you can run "ngen executeQueuedItems" to let it process the entire queue immediately.

Wilco Bauwer

# re: SqlServer 2005's installer... Oracle Quality, at last!@ Friday, October 28, 2005 11:58 AM

How do yet the key now - I see no key in the "product key" page after downloading the cds.

RD

# re: SqlServer 2005's installer... Oracle Quality, at last!@ Saturday, October 29, 2005 1:28 AM

>Last time I installed ODP.NET, it was a 180 MB download, which would occasionally result in a successful painful install just to get a few DLLs.

If it worked the first time you ran it, it must not have been an Oracle product. Maybe you were at a hackers site by mistake.

Eric

# re: SqlServer 2005's installer... Oracle Quality, at last!@ Tuesday, November 01, 2005 1:07 PM

Hm, I thought I understood the comments about Oracle - but then I ran the SQL Server 2005 installation and it worked just like that. Double-click splash.hta and a very nice installer runs, right through with all components... Not sure what your problem really was about.

Oliver Sturm

# re: SqlServer 2005's installer... Oracle Quality, at last!@ Sunday, November 13, 2005 11:38 AM

Also after installing Sql Server 2005 be sure to do a restart of your system. I had the weirdest error messages in sql server management studio after installing and they all disappeared after a restart.

FH