SQL Server Enterprise Edition does not have management studio management tools. workstation components cannot be installed (you do not need to uninstall and reinstall)

If you first install vs2005 2010 and then install sqlserver, you may find that the installation of Management studio is still not found.

 

Common online solutions

1. The installation of your sqlserver2005 development edition is incorrect. After installation, SQL Server Management studio is SQL Server 2005 express edition.

Quick development of SQL Server 2005 Express is free of charge, and Microsoft is free to use, but it features sqlserver2005 development edition installation problems after installation is complete, there is not much less SQL Serve, however, it is enough for learning and personal development. After installing SQL Server 2005 express edition, you can find the SQL Server 2005 service manager, but cannot find its Database Manager, this is because the Express version of SQL itself does not contain graphical management tools. If you need this tool, you need to download it from Microsoft.

The graphic interface tool used by SQL Server 2005 is Microsoft SQL Server Management studio Express. Now Microsoft officially provides its official version for download.

In addition, Microsoft provides the Microsoft SQL Server 2005 express edition toolkit for download. Microsoft SQL Server 2005 express edition toolkit includes Microsoft SQL Server Management studio Express.

The following is the download link. You can download and install it. After installation, Microsoft SQL Server Management studio express appears in the SQL Server 2005 Program Group. Use it for management.

Microsoft SQL Server Management studio Express:

Http://www.microsoft.com/downloads/details.aspx? Displaylang = ZH-CN & familyid = c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796

 

Microsoft SQL Server 2005 express edition Toolkit:

Http://www.microsoft.com/downloads/details.aspx? Displaylang = ZH-CN & familyid = 3c856b93-440f-4c6f-9357-c35384259543

Note: The above is a Simplified Chinese version. You can download it in other languages.

Ii. installation sequence Problems
You may tell me that I have not installed express edition, but Microsoft SQL Server 2005 Development edition (Development Edition). This version has complete functions, the functions are the same as those of the Enterprise Edition. There is no difference, but there is a difference in authorization.

If you first install Microsoft Visual Studio 2005/2008 and then install Microsoft SQL Server 2005 Development edition, SQL Server Management studio is not installed in SQL Server 2005 after installation, when you install Visual Studio 2005/2008, it automatically installs an SQL Server express or mobile instance for you, when you check the installation compatibility when installing SQL Server 2005 development, he will ask you if you want to change the version, saying that your previous version is the express version. It is estimated that most people have not read it, directly "Next", so after installation, your version is express, So Microsoft SQL Server Management studio Express is not installed. You can check your "service items" after installation, and there will be SQL Server express services.

Solution: In this case, the solution is to unmount all the programs starting with Microsoft SQL Server 2005 (including some tool components) in the control panel, and then reinstall them!

 

We recommend that you Install SQL Server 2005 later,

1. First Install SQL Server 2005 and then install Visual Studio software

2. If vs2005 or vs2008 is installed and the built-in SQL Server express 2005 is installed, You Have To uninstall all the previous SQL Server 2005 Express, and then Install SQL Server 2005.

3. Do not Install SQL Server 2005 express when installing vs2005 or vs2008. Install SQL Server 2005 after installing.

At the same time, you should note that if you install Visual Studio 2005 and Visual Studio 2008, its built-in SQL Server is in the Express version, so you will not have Microsoft SQL management studio, the specific solution can be the same as above.

 

 

However, it would be a waste of time to reinstall it after simple uninstallation. In addition, during installation, you should also note that

During installation, I also noticed that when the program detects the system, the last question mark is displayed. The details are as follows:
-Version change check (warning)
Message
* Version change check

* To change an existing Microsoft SQL Server 2005 instance to another version of SQL Server 2005
Run the SQL Server 2005 installation program at the prompt and include the skuupgrade = 1 parameter.

Since Microsoft prompts this clearly, why should so many people uninstall and reinstall it? The Installation Process of sqlserver is cumbersome and time-consuming. It is not a good solution to the problem.

In fact, it is very easy to add the skuupgrade = 1 parameter during installation.

, Switch to the location under cmd, and execute the corresponding command

Then the installer is started.

Installation Process 1

You can check the wks component.

Click Next to start Installation

After a long wait, the installation is successful.

Start the sqlserver service and management studio has started to connect.

At this point, the installation is complete, and restart is recommended.