Help and Support
 

powered byLive Search

How to obtain SQL Server Management Studio Express (SSMSE) community technology preview (CTP)

View products that this article applies to.
Article ID:907716
Last Review:January 31, 2006
Revision:5.2
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

Back to the top

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:
http://www.microsoft.com/downloads/details.aspx?familyid=0856eacb-4362-4b0d-8edd-aab15c5e04f5 (http://www.microsoft.com/downloads/details.aspx?familyid=0856eacb-4362-4b0d-8edd-aab15c5e04f5)

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:
http://www.microsoft.com/downloads/details.aspx?familyid=993c0bcf-3bcf-4009-be21-27e85e1857b1 (http://www.microsoft.com/downloads/details.aspx?familyid=993c0bcf-3bcf-4009-be21-27e85e1857b1)

Obtain the SSMSE CTP

To download SSMSE, visit the following Microsoft Web site:
http://www.microsoft.com/downloads/details.aspx?familyid=82AFBD59-57A4-455E-A2D6-1D4C98D40F6E (http://www.microsoft.com/downloads/details.aspx?familyid=82AFBD59-57A4-455E-A2D6-1D4C98D40F6E)

Back to the top

How to connect to SQL Server 2005 Express

To connect SSMSE to a SQL Server 2005 Express Database Engine instance, follow these steps:
1.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.
2.Click Enter.

Back to the top

REFERENCES

For more information, see SQL Server 2005 Books Online.

Back to the top

APPLIES TO
•Microsoft SQL Server 2005 Express Edition

Back to the top

Keywords: 
kbinfo KB907716

Back to the top

Article Translations

 

Related Support Centers

Other Support Options

  • Need More Help?
    Contact a Support professional by E-mail, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.