SQL Tools install problem

8 Jan 2007 8:55 PM

griffonage

I have SQL 2005 64bit edition and I can't get the SQL tools ie SQL
Server Management Studio installed on my 32bit XP workstation. All of
the setups say not a valid 32 bit application or they say they don't
run on my processor. (Pent D 2.8)

Anyone had success getting SQL Management Studio to install on a 32bit
workstation from the 64bit DVD?

8 Jan 2007 9:15 PM

Aaron Bertrand [SQL Server MVP]

I'd be surprised if the 32bit version wasn't on the DVD somewhere... though
I don't have one here to check.

<griffon***@gmail.com> wrote in message
Show quote

news:1168289727.966940.295800@i15g2000cwa.googlegroups.com...
>I have SQL 2005 64bit edition and I can't get the SQL tools ie SQL
> Server Management Studio installed on my 32bit XP workstation. All of
> the setups say not a valid 32 bit application or they say they don't
> run on my processor. (Pent D 2.8)
>
> Anyone had success getting SQL Management Studio to install on a 32bit
> workstation from the 64bit DVD?
>

8 Jan 2007 9:19 PM

griffonage

I have the CD too...when i put the CD in my drive I get

A Runtime error has occurred.
Do you wish to Debug?

Line: 214
Error: %1 is not a valid Win32 application.

I'm not sure which msi on the CD is for the Management studio, but so
far my guesses haven't been correct.

Aaron Bertrand [SQL Server MVP] wrote:
Show quote

> I'd be surprised if the 32bit version wasn't on the DVD somewhere... though
> I don't have one here to check.
>
>
>
> <griffon***@gmail.com> wrote in message
> news:1168289727.966940.295800@i15g2000cwa.googlegroups.com...
> >I have SQL 2005 64bit edition and I can't get the SQL tools ie SQL
> > Server Management Studio installed on my 32bit XP workstation. All of
> > the setups say not a valid 32 bit application or they say they don't
> > run on my processor. (Pent D 2.8)
> >
> > Anyone had success getting SQL Management Studio to install on a 32bit
> > workstation from the 64bit DVD?
> >

8 Jan 2007 9:35 PM

Aaron Bertrand [SQL Server MVP]

>I have the CD too...when i put the CD in my drive I get
>
> A Runtime error has occurred.
> Do you wish to Debug?
>
> Line: 214
> Error: %1 is not a valid Win32 application.

You can search for folders called "tools" even though the autorun doesn't
work correctly. In other words, you don't necessarily have to rely on the
autorun feature at all.

Alternatives if you can't find a 32-bit tools folder on the DVD or CD:

(a) contact Microsoft for a 32-bit version.
(b) buy developer edition ($49).

8 Jan 2007 9:47 PM

griffonage

I tried poking around for the tools install, unfortunately everything
is in 1 folder called Setup.

On CD 2 I found SqlRun_tools.msi, which when i run seems to do nothing
for a while, I check task manager and explorer.exe shoots up to 500+ MB
of RAM, than i get "This installation package is not support by this
processor type. Contact your product Vendor." as an error.

I randomly picked other install packages on the CD and they failed the
same way. Oddly I can confirm on the server that SSMS runs in 32 bit
mode...just wish someone knew how to install it on a workstation.

Aaron Bertrand [SQL Server MVP] wrote:
Show quote

> >I have the CD too...when i put the CD in my drive I get
> >
> > A Runtime error has occurred.
> > Do you wish to Debug?
> >
> > Line: 214
> > Error: %1 is not a valid Win32 application.
>
> You can search for folders called "tools" even though the autorun doesn't
> work correctly. In other words, you don't necessarily have to rely on the
> autorun feature at all.
>
> Alternatives if you can't find a 32-bit tools folder on the DVD or CD:
>
> (a) contact Microsoft for a 32-bit version.
> (b) buy developer edition ($49).

23 Jan 2007 6:10 PM

Alan

Hi,
Did you ever find out how to install the tools on the XP workstation?
Looking for an answer to this as well.
Please advise.
Thanks!

--
Alan

Show quote

"griffon***@gmail.com" wrote:

> I have SQL 2005 64bit edition and I can't get the SQL tools ie SQL
> Server Management Studio installed on my 32bit XP workstation. All of
> the setups say not a valid 32 bit application or they say they don't
> run on my processor. (Pent D 2.8)
>
> Anyone had success getting SQL Management Studio to install on a 32bit
> workstation from the 64bit DVD?
>
>