By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,766 Members | 1,252 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,766 IT Pros & Developers. It's quick & easy.

SQL 2005 Management Studio/Express - Any differences

P: n/a
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
Aug 29 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Aug 29 '08 #2

P: n/a
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 <esq...@sommarskog.sewrote:
John Fox (fox...@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, esq...@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
Sep 9 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.