Subscribe to:
Post Comments (Atom)
Popular Posts
Labels
About Me
Best Practices
Career
Data Mining
Documentation
Feature Requests
Humor
MagicPASS
Meme Monday
Mirroring
Parameter Sniffing
PASS
Performance
PowerShell
Presentations
Query Tuning
Recognition
Replication
Scripts
Security
SQL Power Doc
SQL Server 2005
SQL Server 2008
SQLH2
SQLRally
SQLSaturday
SYDI
T-SQL Tuesday
Tips
Troubleshooting
Updates
VirtualBox
Windows
XML
What I'm Saying On Twitter
Copyright © 2015 Kendal Van Dyke. All rights reserved.
Kendal is a database strategist, community advocate, public speaker, and blogger. A practiced IT professional with over 15 years of SQL Server experience, Kendal excels at disaster recovery, high availability planning/implementation, & debugging/troubleshooting mission critical SQL Server environments. Kendal is a Senior Consultant on the Microsoft Premier Developer Support team and President of MagicPASS, the Orlando, FL based chapter of PASS. Before joining Microsoft, Kendal was a SQL Server/Data Platform MVP from 2011-2016.
[About Kendal]
(https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh9MNPJA4l6-fUucihu7dVXmOnHaSrHG-zuAhn6IXsjHqnZ2RJ4xSd3KNLMkYXnKcrDKORYVXxC1WGsrrt8s5U8k1atkLfg0xnLtZA6RbLt6qhppadMtWFJLRpNgg1zLjyG3qFeokfkc0xs/w139-h140-p/IMG_3503.JPG)
20 comments
Thanks!! Just what I needed!
very good
Thanks - I just needed to install SSMS on some client machines and this post came in very handy.
Great blog, I just did the installation and then saw the post. No points missed at all.
Abhishek Srivastava
Hi
I am not getting all the shred features in the feature selection window. Could you tell me what could be the problem?
Thanks
Hi
Thx for this walkthrough, its works !
Any information on installing SSMS 2008 on a Windows 7 machine?
Specifically a Windows 7 32 bit install?
I keep encountering an OS not supported error.
I've installed it on x86 (32-bit). Have you double checked that you're running the x86 installer?
Well that was quick. I wasn't expecting such a quick response. Thank you.
While the disc does contain x86 and x64 software, I can't see how I could be running anything other than the x86 version. To make sure, I ran the "Landing Page" launcher from the d:\x86 folder. That launches the installer and I'd assume it's the x86 version since it was in the x86 folder.
In the Setup Support Rules section the minimum operating system version test is passed successfully. The Setup Support files install correctly too. There is a warning about the Windows firewall, but in the short term, I simply turned the firewall off to pass the test.
The problem comes after I select the features. In this case, I'm only selecting the basic management tools.
More specifically, the Operating System error says "This SQL Server edition is not supported on this operating system. See SQL Server Books Online for information about supported operating systems for SQL Small Business Server edition".
The only thing I can think of is that the Small Business Server edition is somehow different.
Does this make any sense to you?
.
It's also worth noting that the Program Compatibility assistant does say right at the beginning that "This program has known compatibility issues", although it simply says that I need to apply SQL Server 2008 SP1 before I actually run SQL Server on this version of Windows.
Ah, the devil's in the details...SQL Server Small Business edition can only be insalled on Windows Server 2008. See http://www.microsoft.com/sqlserver/2008/en/us/small-business.aspx for more details.
If you don't have access to SQL Server Developer edition you may want to consider SQL Express - it's essentially the same basic management tools.
Oh dear yes... those devilish details.
Thanks for your help Kendal.
We simply have the wrong version. I wasn't aware that a separate small business version existed and neither was my OEM supplier. Oddly enough, when he searches for SQL 2008 standard, the small business edition is still the ONLY version that comes up in his channel. Apparently there is more than one class of OEM and his class appears not to be able to sell the true standard version.
I doubt we'll be able to return this to Microsoft as it has been opened.
Thank you, Kendal!
I came acroos your blog after doing the install and it looks like I followed each step correctly. Now how do I get my tools connected to a SQL Server instance on our network? I can't seem to find a connection profile or anything.
Thanks much. It's always nice to know what to expect. I forgot I had VS 2008 (don't use it much, obviously!) and wasn't prompted to upgrade until after trying to install SSMS. FYI.
thank you very much. this site helps me alot...........................
Hey really nice website, I noticed your website when doing study on some methods to develop my web log. I was simply inquiring which spam software system you use for comments as I get tons on my site.
Great walkthrough, thanks!
After installing just the management studio, should I install any of the service packs? Do they apply to the management studio on a client workstation, or only to the SQL Server itself?
Detailed post, no points missed.
Hi
Thank You for Guinness i have done it
Post a Comment