SQL Server 2008 management studio with SQL Server 2005

Hello,
I would like to install SQL Server managment studio 2008 on my PC. I currently have 2 SQL 2005 servers and wasn't for the moment interested in updating them, I would just like the 2008 Management studio (not the express one though, it doesn't seem to include the profiler or the email configurations under Management). Is it possible or am I obliged to buy a SQL Server 2008 suite?
Thank you
James
schuecoITAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

jppintoCommented:
It's possible. Just make sure you have latest patch applied.
0
schuecoITAuthor Commented:
Ok, where would i download the management studio from though? On the microsoft website I can only seem to find the express version for 2008.
0
jppintoCommented:
The mangement studio is included in the full sql server package, and not the express package. So you need to download the full version and then just install that bit.

jppinto
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

schuecoITAuthor Commented:
the only full 2008 i can find is here:

http://www.microsoft.com/sqlserver/2008/en/us/trial-software.aspx

But it seems to be a trial version for 180 days, will the management studio be "forever"?
0
jppintoCommented:
SQL Server is not free! If you don't buy an original copy, you can only work with a trial for 180 days!
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Daniel_PLDB Expert/ArchitectCommented:
To install SQL Server Management Studio 2008 version you need to have SQL Server 2008 installation media.
When SQL Server is licensed per processor every user has right to install SSMS in order to connect and manage that SQL Server installation - not any other.
You need to read carefully EULA but I think that it's allowed. Installator will ask you for license code during installation.
0
schuecoITAuthor Commented:
Thank you, this is what i wanted to know. I thought the management studio was free and just the server part needed a licence, and i wanted management studio 2008 using my 2005 servers.
Thank you for the help,
James
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.