SQLServerManagementStudio does not exist

In one case, two warnings were reported when sqlServer2005 was installed: 1Com + directory requirement 2Editionchangecheck is depressing! There are two warnings on the Internet, but the installation is definitely not successful! I tried it with my luck and succeeded. After the installation is successful, only tools, books online, and examples (T) are being prepared but cannot be installed. He prompts me to work

In one case, two warnings occurred when installing sqlServer2005: 1 Com + directory requires 2 Edition change check! There are two warnings on the Internet, but the installation is definitely not successful! I tried it with my luck and succeeded. After the installation is successful, only tools, books online, and examples (T) are being prepared but cannot be installed. He prompts me to work

In one case, there are two warnings when installing sqlServer2005:

1 Com + directory requirements

2 Edition change check

Depressed! There are two warnings on the Internet, but the installation is definitely not successful! I tried it with my luck and succeeded.

After the installation is successful, you are preparing "tools only, books online, and examples (T )"

However, the system prompts me that the "workstation components" have been installed and cannot be updated or upgraded to the existing components.

Solution:

1 open "Control Panel" ---- "add and delete programs" --- "micorsoft SQL server 2005"

2. Press "Change button" and "micorsoft SQL server 2005 Maintenance" appears"

3. Select "workstation components" under "SQL server 2005 Public components" and click "Next"

4. "Change installation components" and "delete micorsoft SQL server" appear"

5. I took the chance to select "delete micorsoft SQL server"

6. Then, the "only tools, books online, and examples (T)" were re-installed )"

7. At the end of the installation, "msdtc cannot read configuration information" appeared. I was scared. I pressed "retry" and the result was okay.

8. Installation successful!

The myth that two "Warnings" cannot be installed successfully is broken by me.

2nd cases: After sql2005 is installed, no SQL Server management studio is available. What should I do?

1: Originally installed SQL 2000 and VS2005

It's easy to download SQL Server management studio expree from the next management Microsoft China website.

You installed SQL2000 with the SQL management plug-in managed by the computer. If you have installed Microsoft's 05, you should select an SQL Server management studio in the installation group. You may download a simplified version. Generally, a CD is normally downloaded. Decompress 1.4 GB. If you urgently need the management interface, you can temporarily use the management interface of SQL 2000 for management.

2: There is no SQL Server Management Studio solution in SQLserver 2005

There are two cases: version and installation order. Please refer to the following:

1. You have installed SQL Server 2005 Express Edition, that is, the quick development Edition.

SQL Server 2005 Express does not cost money. Microsoft is free to use for you, but it has many features, but 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.

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.

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

Iii. 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. I guess you are using the Development version? Don't be surprised, because this version is a widely spread version on the Internet. Most Chinese people have the habit of downloading online or buying pirated discs. All software is downloaded from the Internet, you don't have to spend any money on a child, and you have to pay five yuan for a stall. So I guess most people use the Development version.

Well, it's not a long journey. It's a little cool to say something about it. It's not enough to say something about it. Please forgive me.

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 SQLserver 2005 after installation, when you install Visual Studio 2005/2008, it automatically installs an SQL server Express 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!