SQL 2005 Management Studio/Express - Any differences

[John Fox]

Hi there,

We have recently deployed a couple of new SQL 2005 x64 servers in our
hosting environment. We have previously used SQL 2000.

I need to start rolling out the new client tools so our developers can
start working on them. I tried to copy the sql tools msi off the
installation CD and install it on the developers machine but it will
not install on them as the workstations are 32bit and the server is
x64.

I have had a look on the net to see if i can download the 32 bit
management studio but i can only find the management studio express
edition. Are there any differences between the management studio and
express versions? and if there is how can i go about getting the 32
bit version of the full management studio client tools.

Thanks

[Erland Sommarskog]

John Fox (fo****@gmail.com) writes:

I need to start rolling out the new client tools so our developers can
start working on them. I tried to copy the sql tools msi off the
installation CD and install it on the developers machine but it will
not install on them as the workstations are 32bit and the server is
x64.

I have had a look on the net to see if i can download the 32 bit
management studio but i can only find the management studio express
edition. Are there any differences between the management studio and
express versions? and if there is how can i go about getting the 32
bit version of the full management studio client tools.

The stupid thing is that the tools are 32-bit; it's only the Setup that
is 64-bit.

Mgmt Studio Express is a stripped down version of Mgmt Studio that
lacks support for features not in Express. I don't think your developers
will like that one.

I think your options are:
1) Download 32-bit version from MSDN if you have a subscription.
2) Call your local Microsoft office and explain your predicament.
3) Cough up 50$ for a copy of 32-bit Developer Edition, although I don't
know how good this is license-wise. But you should have the license
through you 64-bit server anwyay.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

[John Fox]

Thanks Erland,

I used our MSDN subscription and downloaded the full management studio
32 bit version.

Much appreciated


On 29 Aug, 23:12, Erland Sommarskog <[e-mail]:

John Fox ([e-mail]) writes:

I need to start rolling out the new client tools so our developers can
start working on them. *I tried to copy the sql tools msi off the
installation CD and install it on the developers machine but it will
not install on them as the workstations are 32bit and the server is
x64.

I have had a look on the net to see if i can download the 32 bit
management studio but i can only find the management studio express
edition. *Are there any differences between the management studio and
express versions? *and if there is how can i go about getting the 32
bit version of the full management studio client tools.

The stupid thing is that the tools are 32-bit; it's only the Setup that
is 64-bit.

Mgmt Studio Express is a stripped down version of Mgmt Studio that
lacks support for features not in Express. I don't think your developers
will like that one.

I think your options are:
1) Download 32-bit version from MSDN if you have a subscription.
2) Call your local Microsoft office and explain your predicament.
3) Cough up 50$ for a copy of 32-bit Developer Edition, although I don't
* *know how good this is license-wise. But you should have the license
* *through you 64-bit server anwyay.

--
Erland Sommarskog, SQL Server MVP, [e-mail]

Links for SQL Server Books Online:
SQL 2008:http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005:http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000:http://www.microsoft.com/sql/prodinf...ons/books.mspx