Derrick Leggett Blog

Ramblings, grumblings, and other nonintelligible nonsense about SQL Server.

<b>SQL Server 2005 Install Notes</b>

I've now installed SQL Server 2005 about 18 trillion times since the first beta came out.  :)  Seriously, since I have been trying to take all the free webcasts, training, etc that's out there and ramping up my skillset on the new technology, I have completed around 25 installs of the product.  I am currently installing three more instances of the June CTP on various laptops and computers at home.  So.......I thought I would start recording notes on the installs here.

This will probably end up like all my other blogs (rarely updated and very seldom read).  lol  But, in the interest of the great and almight blogosphere, let's begin.

  1. I had a brilliant idea of setting up one of my virtual server instances as a DC, so I wouldn't have to use multiple computers to have my domain environment.  I also installed SQL Server 2005 on there.  This was brilllllliant.  It didn't work though.  lol  There is no NT Service\Network Service blah, blah account on a DC, so Integration Services wouldn't install.  I learned that the second time this little scenario failed.  The first time it failed because I tried to install with the domain\administrator account.  It didn't have permissions to one of the local .msi files and things kept failing along the way.  I would try this scenario out again to see if I can replicate, but I'm not that bored.
  2. The MSDN site has now very nicely placed the April CTP inside the Visual Studio 2005 section of downloads.  There's a really good reason for this.  The .NET Framework used by the June CTP and the Visual Studio 2005 Beta 2 are DIFFERENT.  I, of course, had to learn this the hard way.  Just to prove the point, I tried it twice.  It failed twice.  BRILLIANT!!!
  3. Do yourself a favor.  If you insist on installing both VS 2005 AND SQL Server 2005, install SQL Server 2005 first.  It works MUCH, MUCH smoother.  Be sure to use VS 2005 Beta 2 and the April CTP.  Together, they work a charm.
  4. Use Virtual Server, VMWare, or whatever you want to use.  It's kewl.  It's awesome.  I love it.  I think it's the best thing since sliced bread with bananas, peanut butter, and bologna all mashed together and topped with mint ice cream.  Setup a Virtual Server instance with just Windows 2003 and all the stupid updates that take 1800 hours to install.  Copy the file.  Hide it.  Protect it.  You'll need it.  After you've done that, embarc on the great voyage of beta testing.  May Gates rest your merry little soul.
  5. Forgot a fun one (I woke up).  I installed the April CTP after VS 2005 Beta 2 once (I think this was the was like 3:30am again).  Under the stupid MS SQL Server 2005 menu I didn't see anything.  IF you INSIST on installing in this order, uninstall the stupid Express edition FIRST.  Otherwise, your tools are ummmmmmmm missing in action.  AWOL tools are a bad thing. 

I might add to this.  I might not.  It depends.  I'm doing this one at midnight.  It shows.  My 2803419840019841 installation (June CTP) is almost finished.  I can't wait.  My journey to conquer the world has began. 


Yawn.  Yawn.  Yawn







Legacy Comments

re: <b>SQL Server 2005 Install Notes</b>
Thank you for your installation notes. I already had VS2005 Beta 2 on my (virtual) machine, and when I installed the SQL Server 2005 CTP... no tools.

I went to Google, found your blog, and solved my problem. :-)

Leshonda Watkins
re: <b>SQL Server 2005 Install Notes</b>
I don't have the beta so I can't find this out all that easily.

If you know, would you please list other MS server products or product configurations (like the domain controller issue you note) that conflicts with SQL Server 2005?

re: <b>SQL Server 2005 Install Notes</b>
OK I'm a bit lost - I have my 3 VS Beta 2.0 dvds and started installing. I think I have stuffed up in terms of reading above that sql server 2005 should have been installed before vs - but now that I have installed vs (and cannot get sql server 2005 to install) what do I do?!

Derrick Leggett
re: <b>SQL Server 2005 Install Notes</b>
I haven't had any issues with the latest beta and the September CTP. Where did you get the DVD? Is it the same build as the on on MSDN? If so, the September CTP and that version have the same build of the .NET framework. What error are you getting? Post it here and/or on the forum and we'll see if we can help you out.

khaja moin uddin
re: <b>SQL Server 2005 Install Notes</b>
I want full notes of sql sever 2005

khaja pasha
re: <b>SQL Server 2005 Install Notes</b>
my name is pasha i live in imam bada

re: <b>SQL Server 2005 Install Notes</b>
I found a solution for installing SQL Server 2005 Express edition.

I tried many things, but always received this failure message:

The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." The error is (1067) The process terminated unexpectedly. Error Number : 29503

The solution for me was NOT to uninstall Visual Basic 2005 Express Edition, or install SQL Server 2005 in any particular order.

These are the steps that worked for me. On the first setup screen, there is a checkbox that says "Hide advanced setup installation options" (or somesuch). It is checked by default. UNCHECK IT.

Look closely at the screens that follow. Look for the dropdown that says "Install SQL Server as a... Network Service. In the dropdown, change the choice to Local Service.

In another screen, look for the Authentication method. Do NOT use Windows authentication, which is the default. Select Mixed Mode authentication, and provide a strong password.

Now, let it install. For me, it no longer failed, and SQL Server installed with no further problems.

junaid khan
re: <b>SQL Server 2005 Install Notes</b>
give me free download site on net 'SQL Server 2005'

re: <b>SQL Server 2005 Install Notes</b>
No Comments

re: <b>SQL Server 2005 Install Notes</b>
I have unchecked the advanced options.
I do not find the dropdown for Network Service or Local Service.
I have set the autentication to mixed.
Still the same message.

re: <b>SQL Server 2005 Install Notes</b>


When i install sql server on my machine running windows server 2003 sp1.
I got a window saying sql server 2005 ctp fails to install. send or don't send error report even though all the components have been successfully installed

re: <b>SQL Server 2005 Install Notes</b>
Hy I wanted to uninstall the sql server 2005 beta and install the sql server 2005 developer edition.

I uninstalled it successfully (with a tool) but now when I try to install the new one, an error message came that say :
SQL Server Setup has detected incompatible components from beta version of VS, .NET fw or sql server 2005. use add or remove programs to remove these componets...

can somebody help?

re: <b>SQL Server 2005 Install Notes</b>
Non of this worked for me. I still get sql service failed to start error. I've installed sqlserver2005 a million times on different machine and still get thesame error.HEEEEEEEEEEEEEELP

re: <b>SQL Server 2005 Install >
I installed SQL Server 2005 Trial version successfully but I can't see SQL Server Management Studio. When I click on prgrams, then SQL Server 2005, I don't see the Management Studio. How can I access it?