This document contains important information to read before you install Microsoft® SQL Server 2005™ Management Studio Express (SSMSE) Service Pack 3 (SP3) and SQL Server 2005 Express Edition Toolkit SP3. It describes how to obtain SP3, how to obtain the latest version of Books Online, and describes additional information about product issues. This version of the document replaces the version that ships with SP3.
3.0 Known Issues
3.4 SQL Server Agent
1.0 Download Location
Service Pack 3 is available from the following locations:
Microsoft SQL Server Management Studio Express Service Pack 3
Microsoft SQL Server 2005 Express Edition Toolkit Service Pack 3
|Be sure to follow the instructions provided at the download site for downloading and extracting the product.|
1.2 Related Links
Service Pack 3 for the tools does not update SQL Server. To update your version of SQL Server download one of the Service Packs from the following locations.
Microsoft SQL Server 2005 Service Pack 3
Microsoft SQL Server 2005 Express Edition Service Pack 3
Microsoft SQL Server 2005 Express Edition with Advanced Services Service Pack 3
2.0 Updates to SQL Server 2005 Books Online are Available
Starting with the December 2008 update of SQL Server 2005 Books Online, a separate Books Online for SQL Server Express is unavailable. SQL Server 2005 Books Online is the primary documentation for SQL Server Express. The December 2008 update of Books Online reflects all product upgrades that are included in this service pack, and also includes other improvements to the documentation. We strongly recommend that you install this update to keep the information in the local copy of the documentation current with SQL Server Express SP3. The December 2008 update is available at this
3.0 Known Issues
This section details issues when you install or run the product.
3.1 Side-by-Side Installation
SQL Server Management Studio and SSMSE cannot be installed side-by-side on the same computer.
|SQL Server Management Studio can be used to connect to SQL Server Express instances.|
3.2 Full-Text Catalog
You cannot update the full-text catalog by using SSMSE because it is not supported by the tool. You can use sqlcmd utility or Windows Scheduler to update the full-text catalog. For more information, see "Creating Full-Text Indexes," "CREATE FULLTEXT CATALOG (Transact-SQL)," and "ALTER FULLTEXT CATALOG (Transact-SQL)" in SQL Server 2005 Books Online at this
In Object Explorer, you will see the full-text catalog object, but only the Refresh command is available.
3.3 Replication Support
Interactive Resolver, which lets you resolve conflicts manually during on-demand synchronization in Microsoft Windows Synchronization Manager, is not supported in SSMSE.
3.4 SQL Server Agent
SSMSE does not support scheduling administrative tasks by using SQL Server Agent. In Object Explorer, only the Refresh command is available to refresh the state of the service for all SQL Server instances except SQL Server Express. This is because SQL Server Agent is not supported by SQL Server Express.
3.5 Help Experience in Management Studio
3.5.1 Help for SSMSE is not installed by the product
Help for SSMSE is not installed by the product. If you press F1, MSDN Online help opens. By pressing F1, you can access all F1 help topics, but you do not see a table of contents or an index for the SQL Server 2005 documentation. To add SQL Server 2005 documentation to SSMSE, install SQL Server 2005 Books Online from this
|When you press F1, the topics that open might refer to user interface elements or features that are not supported by SSMSE. This is because the documentation was written for SQL Server Management Studio, which is installed with SQL Server 2005.|
3.5.2 Help Might Not Function Properly in Integrated Mode
Some features in the Help Search and Help Favorites windows might not be functional if the Help option is set to Integrated Help Viewer. To address this situation, do the following:
Open SQL Server Management Studio Express.
Click Tools, click Options, and then click Help.
Under General, set Show Help using: to External Help Viewer.
3.6 Help Experience in Business Intelligence Development Studio
By default, SQL Server 2005 Books Online is not installed with Business Intelligence Development Studio. Therefore, if you press F1, the MSDN online Help opens. By pressing F1, you can access F1 Help topics. However, you do not see a table of contents or have access to the rest of the SQL Server 2005 documentation. To access the SQL Server 2005 documentation, install SQL Server 2005 Books Online from this
|When you press F1, the topics that open might refer to user interface elements or features that are not supported by SQL Server Express. This is because the documentation was written for the full version of SQL Server 2005.|
3.7 Business Intelligence Development Studio Compatibility with Windows Vista or Windows Server 2008
The Visual Studio component that is included in Business Intelligence Development Studio (BIDS) has a known compatibility issue with Windows Vista and Windows Server 2008. For more information, see Knowledge Base article
4.0 Additional Information
4.1 Object Explorer Behavior
In SSMSE, Object Explorer only supports Database Engine instances. The Connect to Server dialog box prevents connecting to other services, such as Analysis Services.
All objects that would ordinarily be enumerated for a specific Database Engine Object Explorer tree are still visible in SSMSE. If it is an object for an unsupported item such as full-text catalog, only the Refresh command is available.
4.2 Connecting to SQL Server Express
To connect to a SQL Server Express Database Engine instance, in the Connect to Server dialog box, specify any one of the following:
.\sqlexpress, (local)\sqlexpress, or server name\sqlexpress
Note The default installation of SQL Server Express uses an instance name (sqlexpress). This instance name must be supplied to connect to SQL Server Express by using SSMSE. If you have an instance name other than sqlexpress, connect by using computer name\instance name.
4.3 Connecting to a User Instance
SSMSE enables developers to administer SQL Server Express user instances. The prerequisite for using SSMSE with a SQL Server Express user instance is that the user instance should be running and active. To start a user instance, install SSEUtil.exe from this
To open SSMSE, click Start, click All Programs, click Microsoft SQL Server 2005, and then click SQL Server Management Studio Express.
To open a new query editor window in SSMSE, click New Query.
In the new query window, enter the following commands:
USE master; GO SELECT owning_principal_name, instance_pipe_name FROM sys.dm_os_child_instances; GO
After the results are displayed, under the owning_principal_name column, find the user name for which the user instance was generated. From the instance_pipe_name column, copy the named pipe value.
Create a new database connection. In Object Explorer, click Connect. In the Connect to Server dialog box, paste the named pipe value, preceded by np:, as shown:
You can now use SSMSE to manage objects related to your user instance.
For more information about user instances, see "User Instances for Non-Administrators" in SQL Server 2005 Books Online.
4.4 Configuring Remote Access to SQL Server Express
SQL Server Express listens on local named pipes and shared memory. By using a default installation, you cannot remotely connect to SQL Server Express. You must enable TCP/IP and determine whether the firewall is enabled.
From the Start menu, select All Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Configuration Manager.
Optionally, you can open Computer Manager by right-clicking My Computer and selecting Manage. In Computer Management, expand Services and Applications, expand SQL Server Configuration Manager.
Expand SQL Server 2005 Network Configuration, and then click Protocols for InstanceName.
In the list of protocols, right-click the protocol you want to enable, and then click Enable.
The icon for the protocol will change to show that the protocol is enabled.
Click Start, click Control Panel, and then click Network Connections.
From the navigation bar on the left, click Change Windows Firewall settings.
On the Exceptions tab, in the Programs and Services box, you will probably see that SQL Server is listed, but not selected as an exception. If you select the check box, Windows will open the 1433 port to let in TCP requests. Alternatively, if you do not see SQL Server listed, do the following:
Click Add Program.
Navigate to drive:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\BINN
Add the file sqlservr.exe to the list of exceptions.
- Click Add Program.
4.5 Business Intelligence Development Studio and Reporting Services
SQL Server Express Toolkit SP3 Setup installs Business Intelligence Development Studio. This is required to create and modify reports that can be hosted on Reporting Services. To install Reporting Services, run Microsoft SQL Server Express with Advanced Services Setup. The Setup program will guide you through the Reporting Services installation.
When Reporting Services is installed, you can view reports by using your report server. However, to create reports, you must use Business Intelligence Development Studio.
Business Intelligence Development Studio is the Microsoft Visual Studio 2005 environment with enhancements that are specific to SQL Server 2005 business intelligence solutions. The following project templates are available in Business Intelligence Development Studio. You can use either of these templates to create reports that run on a Reporting Services report server.
Report Server Project
Report Server Project Wizard
4.6 Community Support
The following resources are available for information about SSMSE:
MSDN Community Forums: SQL Server
Ask a question. On this site, you can search through existing newsgroup postings for any questions that you might have. Use this as a starting point to see whether someone else has encountered a similar situation to the one that you are experiencing. To browse for SSMSE postings, click the "SQL Server Tools General" link. Do not use other Microsoft newsgroups for posting questions regarding SSMSE.
Note: Newsgroups are supported in English only.
Microsoft Connect for SQL Server
Send feedback. On this site, you can participate in the development process by submitting suggestions and bug reports for SSMSE. You can search for bug reports and suggestions that others have submitted. Add your vote or enter a new bug report if you cannot find one that matches your scenario. Be as specific as possible in bug reports to help the development team reproduce the problem. You can also set up alerts to monitor the status of your report as changes are made by the development team.
SQL Server Developer Center on MSDN
Get more information. On this site, you can find information for developers who are building SQL Server databases, reporting systems, and business intelligence solutions, and enabling their applications and Web sites to use these systems.