Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 907716 - Last Review: January 31, 2006 - Revision: 5.2
How to obtain SQL Server Management Studio Express (SSMSE) community technology preview (CTP)
On This Page
INTRODUCTION
Microsoft SQL Server Management Studio Express (SSMSE) community technology preview (CTP) provides a graphical management tool for instances of Microsoft SQL Server 2005 Express Edition (SQL Server 2005 Express). SSMSE can also manage relational engine instances that are created by any edition of SQL Server 2005. SSMSE cannot manage the following:
- SQL Server Analysis Services
- SQL Server 2005 Integration Services
- SQL Server 2005 Mobile Edition
- SQL Server Notification Services
- SQL Server Reporting Services
- SQL Server Agent
MORE INFORMATION
Obtain SSMSE
Prerequisites
You must install the Microsoft .NET Framework 2.0 and Microsoft MSXML 6.0 Parser before you install SSMSE.
Note The .NET Framework 2.0 and MSXML 6.0 Parser might be already installed if the computer is running SQL Server 2005 Express.
.NET Framework 2.0
You must install the .NET Framework 2.0 before you install SSMSE. SSMSE depends on .NET Framework version 2.0.50727.42 or a later version of the .NET Framework. If you have a previous version of the .NET Framework, your SSMSE installation might function unpredictably. To download the .NET Framework version 2.0.50727.42, visit the following Microsoft Web site:
MSXML Parser 6.0
You must install the MSXML Parser 6.0 before you install SSMSE. To download MSXML 6.0, visit the following Microsoft Web site:
Obtain the SSMSE CTP
To download SSMSE, visit the following Microsoft Web site:
How to connect to SQL Server 2005 Express
To connect SSMSE to a SQL Server 2005 Express Database Engine instance, follow these steps:
- In the Connect to Server dialog box, specify one of the following:
- .\sqlexpress
- (local)\sqlexpress
- server name\sqlexpress
Note The default installation of SQL Server Express uses an instance name (SQLExpress). This instance name must be provided to connect to SQL Server Express by using SSMSE. If you have a instance name other than SQLExpress, connect by using computer name\instance name. - Click Enter.
REFERENCES
For more information, see SQL Server 2005 Books Online.
APPLIES TO
- Microsoft SQL Server 2005 Express Edition
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
Be the first to leave feedback, to help others about this knowledge base
article.
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please