SQL Server 2008 on windows 8 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

SQL Server 2008 on windows 8

Author

Topic

ksr39
Posting Yak Master

193 Posts

Posted - 2014-04-19 : 17:47:31

Hi Experts,

I want to install SQL Server 2008 Enterprise edition 32 bit on Windows 8 64 bit, I am not able to install the SQL, i tried to do in command prompt by using the below syntax but throws and error.

The arguement

'/Q/ACTION=INSTALL/FEATURES=SQL,AS,RS,IS,TOOLS/INSTALLSHARDWOWDIR/PID=XXXXX-XXXXX-XXXXX-XXXXX-XXXX is formatted incorrectly, The delimiter'=' is missing.

error code 0x84B40006.

Please suggest on the above issue.

Thank you all in advance.

Thank You All In Advance
KRS39

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2014-04-19 : 18:16:52

What are you executong.
You need to run setup.exe (I think) and your parameters need to be delimited by spaces.

see
http://msdn.microsoft.com/en-us/library/ms144259.aspx
There's an example after the parameters - easy to miss, search for sample syntax.

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.

ksr39
Posting Yak Master

193 Posts

Posted - 2014-04-20 : 01:16:15

HI,

Thanks for the reply, yeah i tried the same syntax given in the link with the parameters which are mentioned, still i got this error.
Please if you have any script or syntax to install the sql through cmd and can give me would be much appreciated.

Thank You All In Advance
KRS39

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2014-04-20 : 01:25:04

Don't think you can do that. Enterprise Edition required a Windows Server

refer to http://msdn.microsoft.com/en-us/library/ms143506%28v=sql.100%29.aspx#EE32

KH
[spoiler]Time is always against us[/spoiler]

Hotrats
Starting Member

1 Post

Posted - 2014-04-20 : 13:58:28

nigelrivett gave you a reference to the syntax, which does work. See that reference's comments about "space" and "double quotation marks". You should also review how to pass command line arguments (afraid I don't have a convenient reference)/

The 0x84B40006 is setup.exe returning a parsing error. 0x84B40006's message is telling you where the parsed syntax was _finally_ detected (not where the syntax error _starts_). The message 0x84B40006 mis saying the following [ONE] argument:

'/Q/ACTION=INSTALL/FEATURES=SQL,AS,RS,IS,TOOLS/INSTALLSHARDWOWDIR/PID=XXXXX-XXXXX-XXXXX-XXXXX-XXXX

is incorrect.

Your syntax problem is thus rooted in the _lack_ of spaces between _each_ of the command-line executable's (setup.exe's) arguments.

This:
ECHO '/Q/ACTION=INSTALL/FEATURES=SQL,AS,RS,IS,TOOLS/INSTALLSHARDWOWDIR/PID=XXXXX-XXXXX-XXXXX-XXXXX-XXXX

Should be this:
' /Q /ACTION=INSTALL /FEATURES=SQL,AS,RS,IS,TOOLS /INSTALLSHARDWOWDIR /PID=XXXXX-XXXXX-XXXXX-XXXXX-XXXX

Note the insertion additional spaces. The delimiter for an executable's argument is <space>/ (if a named argument) or a <space> (if an unnamed argument), neither / (without a preceding space) or "<space>" (a space inside quotes).

And yet khtan is correct: Even if you get the syntax to work, enterprise setup should be expected to fail (with a more friendly message:).

I would also question the need to setup a 32-bit app (SQL) on a 64-bit OS (Windows 8). I would carefully consider why this must be done. I would seriously question any 'logic' that states "that is the way it was done, so we will keep doing it that way", unless the former OS was also 64-bit. Even if the former OS was 64-bit, I would question the intent of running a 32-bit app on a 64-bit OS (especially when a 64-bit SQL version is available, with 32-bit SQL now being extinct). Microsoft's KB has documented some past problems with running 32-bit SQL on a 64-bit OS. Some of those problems may have no viable solution. It is past the time when one should think about abandoning 32-bit SQL. Caveat emptor.

ksr39
Posting Yak Master

193 Posts

Posted - 2014-04-20 : 21:59:37

Thank you guys,

for your valuable time and support. I have a copy of SQL Server 2008 enterprise edition which is 32 bit and asked to do it on a windows 8.1 which is 64 bit. now I got the clear idea, how it works. thanks once again and appreciate your help.

Thank You All In Advance
KRS39

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources