SQL Server 2008 install error

2/12/2009 1:01:37 PM #

Great advice. I'm totally adding this to my delicious!

If I may add, based on the information I was able to pull using configuration file, you can also run this from a Command Prompt where the present working directory is the root of the installation files for MS SQL 2008:
setup.exe /Action="Install" /INSTALLSHAREDDIR="D:\Program Files\Microsoft SQL Server" /INSTALLSHAREDWOWDIR="D:\Program Files (x86)\Microsoft SQL Server"

Assuming you want to install in the D: drive, of course.

And if you want to install BIDS on a machine with Visual Studio 2008 already installed, but not in the C: drive, check out this article:

connect.microsoft.com/.../ViewFeedback.aspx

Copy over that devenv.exe.config file to C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE, or you will get an error while the installer tries to put in BIDS.

Cheers,
Count Zyx

4/4/2009 3:26:20 AM #

Great post, thanks

7/30/2009 4:47:46 PM #

Cheers Count Zyx - that got me going.
Installing SQL 2008 Web, even leaving as the default directories resulted in this error.

8/23/2009 11:30:33 PM #

Sorry for being dense, but where am i supposed to copy this ini file from? And what directory value do i need to change if i want the databases installed by default on a folder on D drive. I dont care if the software itself is installed on C. Actually, i'd prefer the software on C and data on D.

thanks

10/3/2009 7:37:12 PM #

The INSTANCESHAREDWOWDIR command line value was not specified. This value must be specified when the INSTANCESHAREDDIR value is specified."  

When using the SQL 2008 x64 GUI install, I found that if I changed the
the top Shared features directory path, I needed to re-input the bottom Shared features directory (x86) path even though I wanted to leave it at the default.  Otherwise, it seems that the GUI install interprets this as no input.

Thank you for leading me in the right direction!

11/30/2009 4:21:16 PM #

i noticed you deleted my post but thats ok i was mainly venting.
spelling on a web site is critical.

maintaning

www.henrycordes.nl/page/Development-Tools.aspx

2.Getting tired of ((( mantaining ))) versioning inside of my C# solutions

11/30/2009 4:23:26 PM #

woops i did it too.

maintaining

11/30/2009 4:59:11 PM #

another thing about the install..

so obvious ... one of the errors reads as follows.
---------------------------------------------------------------------
Rule "Windows Firewall" generated a warning.

The windows Firewall is enabled. Make sure the appropriate ports
are open to enable remote access. See the rules documentation at
http://go.microsoft.com/flink/?LinkID=94001 for information
about ports to open for each feature.
---------------------------------------------------------------------

how hard would it have been for the programmers at microsoft to have placed a button on the dialog box
that reads (((  auto configure remote access through the firewall )))
after all they know their firewall and opperating system and security better than anybody else.
dont they?

so obvious.

something like that would ensure that comments like this wouldnt appear on forums like this one.

11/30/2009 5:41:19 PM #

im glad that somebody has been sucessfull in using sql 2008 !

i have fresh installed ws 08 x64 ent

then tried to install sql 2008 x64 ent.

the install had the following failures !!!
database engine services
sql replication
full text search
reporting services etc ...

it would seem that microsoft would take into consideration that everyone that purchases their products does not know everything that they know.

and they would offer or include a program that can create a setup config file for you that would check the firewall for inabilities to connect to sql ie .. set up rules in the firewall , check the user accounts ie... set up user account access , from what i have seen so far setting up sql 2008 ent on ws 08 requires some sort of magical spell ... or is it the magical $265.00 support call ?

i want to install commerce server 2009 but it looks like i might have to go linux to be able to have a commerce website that is functional.

12/10/2009 12:46:05 PM #

Does someone have a solution for how to install SQL 2008 Servicepack 1 ??????????

1/31/2010 7:13:11 AM #

Yeah - I found the thread where this solutions was offered. Sadly, on our Windows Server 2003 (64 bit), when I try ANY setup from the command line it refuses to run and pops up "Please go to the Control Panel to install and configure system components", despite the fact I am a full admin on that system. Any clue?

3/16/2010 11:12:11 AM #

I  have  a problem  when  i  setup  Sql  serever  2008  by  cmd  .
i wort  setup.exe /q /action=Install /configurationfile=E:\ConfigrationFile.ini, but   i  have  this  message
"Please   go to  control panel  to install  and  configure  sysrem  componentes  "

5/15/2010 1:01:20 AM #

Has anybody tried to install Service Pack 1 for SQL 2008 ? I was able to install the SQL 2008 using the help of the posts here, but I am able to install SP1/2.

Any help is appreciated !!!

9/21/2010 10:48:40 AM #

Great blog!

6/19/2011 8:54:30 PM #

I want to install sql server 2008 in D:\ drive but it generate an error at "setup support rules" it gave me a warning in windows firewall any one gave me the answer how i solve the problem