The Microsoft SQL Server Management Studio Express provides a graphical user interface for configuring and managing SQL 2000 and 2005 Server. While this software is an older version, it is still in use in many organizations. Install Microsoft SQL Server 2008 Management Studio Express if your database resides on an SQL 2008 Server.
Users can develop and run Transact-SQL, EXtensible Markup Language (XML), DMS and multidimensional expressions (MDX) codes against databases using the built-in Code Editor, set up replication and replication servers, assign rights and permissions to each field or column in a database table, and create and schedule database backup jobs within the Microsoft SQL Server Management Studio Express.
Prerequisites
Microsoft Core XML Services and .Net Framework must be installed on the computer where the Microsoft SQL Management Studio will reside. Microsoft Core XML Services and the .Net Framework provide support for the XML format. If Microsoft SQL Server is installed on the computer, then these prerequisites have been met.
Installing Microsoft Core XML Services
- Log on to the Windows computer as a user with administrative rights.
- Download Microsoft Core XML Services from the Microsoft Download Center. Save the downloaded file to the desktop.
- Double-click the installation file Microsoft Core XML Services.
- Click “Run” if prompted by the “Open File – Security Warning.” Click “Next” in the “MSXML 6.0 Parser Setup” window.
- Highlight the radial button beside “I accept the terms in the license agreement.” Click “Next.”
- Type a user's name in the “Name” field and the company name in the “Company” field. Click “Next.”
- Click “Install” to begin the installation. Click “Finish.”
Installing Microsoft .Net Framework
- Download Microsoft .NET Framework from the Microsoft Download Center. Save the downloaded file to the desktop.
- Double-click the Microsoft .NET Framework 2.0 installation file. Click “Run” if prompted by the “Open File – Security Warning.”
- Click “Next” in the “Microsoft .NET Framework 2.0 Setup” window.
- Check the box beside “I accept the terms of the License Agreement.”
- Click the “Install” button. Click “Finish.”
Installing Microsoft SQL Server Management Studio
- Download Microsoft SQL Server Management Studio Express from the Microsoft Download Center. Save the downloaded file to the desktop.
- Double-click the installation file for Microsoft SQL Server Management Studio Express. Click “Next.”
- Highlight the radial button beside “I accept the terms in the license agreement.” Click “Next.”
- Type a user's name in the “Name” field and the company name in the “Company” field. Click “Next.”
- Click “Next” to accept the default installation path. Click “Install” to begin the installation.
- Click “Finish” when you see the message that Microsoft SQL Server Management Studio Express installation completed successfully.
Manage SQL Server
This installation of Microsoft SQL Server Management Studio Express will simplify the administrative tasks for Microsoft SQL Server versions 2000 and 2005. It provides graphical tools and script editors that allow administrators to escape the command line for most routine functions, including script execution, rights assignments, and backup and restore jobs.
Maria Montoya - Maria Montoya loves data and writes on how to find it, use it, store and secure it. Maria holds computer network and forensics ...
Join the Conversation