- How To Install Sql Server 2008
- Steps To Install Sql Server 2008
- Sql Express 2008 Management Tools
- Sql Server Management Studio 2008 R2 …
- Install Sql Server 2008 R2
This time I installed Visual Studio 2010 first, which in turn installed SQL Server 2008 Express. Of course I needed SQL Server Management Studio though, so I downloaded it from Microsoft and tried to install it. And of course, when I went through the installation wizard, the option to install Management Studio didn’t seem to be there.
I installed Visual Studio 2010 on my machine and it installed along with it SQL Server Express 2008.
Now I'd like to use the Management Studio, but I can't seem to find it so I assume it doesn't install it without installed the SQL Server by itself.
Is there a way to just install this software without setting up a brand new instance of a SQL Server?
TFM3 Answers
You can download and install Microsoft SQL Server 2008 Management Studio Express from this Microsoft Download Center page.
The Non express version only ships with SQL Server 2008 editions and cannot be sold or distributed separately.
A DwarfA DwarfThe full version of Microsoft SQL Server Management Studio can be installed WITHOUT installing the server, and it can administer a SQL Server Express Edition.
Here's a tutorial (with screenshots) on how to do this: SQL Server 2008 Client Tools Installation
About SQL Server Management Studio Express Edition (from Wikipedia):
Microsoft has also introduced a free edition known as the Express Edition. As with all of Microsoft's 'Express' products, this is downloadable as a standalone tool or integrated with a SQL Server Express edition at no charge. The tool's limitations lie in the fact that it cannot manage SQL Server Analysis Services, Integration Services, Notification Services, Reporting Services, or SQL Server 2005 Mobile Edition.
TFMTFMHow To Install Sql Server 2008
Yes, it can be done but I only got this to work using SQL server Management studio 2005.
Works well with SQL 2008.
Steps To Install Sql Server 2008
Not the answer you're looking for? Browse other questions tagged sql-server-2008sql-management-studiosql-server-express or ask your own question.
Sql Express 2008 Management Tools
Overview:
With the release of the SQL Server 2008 R2 November, we have simplified the SQL Server Express (all editions and package) installation process. In this release, we have completed the following:
Sql Server Management Studio 2008 R2 …
- Reduced the number of clicks by 50% when performing an install.
- All inputs are defaulted on Vista and above operating systems. (many inputs are defaults on Windows XP and Windows 2003, except for the service accounts)
- Skip (auto advance) through the UI, meaning non-essential dialogs will still be skipped.
- Reduced the size of the Express basic package
Available Express editions for download:
Express Package | If your system is? | If your system is? | If your system is? |
Microsoft® SQL Server® 2008 R2 Express | |||
Microsoft® SQL Server® 2008 R2 Express with Tools | . | ||
Microsoft® SQL Server® 2008 R2 Express with Advanced Services | . | ||
| Microsoft® SQL Server® 2008 R2 Management Studio Express | . |
Below I show the steps to install SQL Server 2008 R2 Express.
1. Launch the package, you will then see the contents extracted to a temporary location.
2. SQL Server Setup checks to determine pre-reqs are installed. If not, you will be prompted to install.
Install Sql Server 2008 R2
3. The Installation Center will then launch. Click on “New installation or add feature to an existing installation” to start the Installation Wizard.
4. Accept the license terms.
5. Review the features to installed and where SQL Server will be installed. Make any changes that are necessary for your environment.
6. Review the Instance Name and change if necessary.
7. Review the credentials that will be used for the services that will be created.
8. Review the Authentication Mode and the administrators that will be added to the Database Engine.
9. Review the Error Reporting settings. We encourage you to keep this option checked, as we review the product feedback on an ongoing basic. This helps us to continually improve SQL Server.
10. That’s it!
Support/Feedback
If you have further questions or feedback, you have a few options:
- Submit feedback through the SQL Server connect site: http://connect.microsoft.com/SQLServer (This is the preferred option, if you have an installation failure)
- Make a comment about this post below. I will answer as many questions as possible.
- MSDN: http://social.msdn.microsoft.com/Forums/en-US/category/sqlserver/