SQL Server 2005 Enterprise Edition no workaround for Management Studio management Tools _ Application Tips

Source: Internet
Author: User
Tags microsoft sql server microsoft sql server 2005 management studio microsoft sql server management studio sql server management sql server management studio sql server express

Looking for a half-day on the Internet have the following situations:

1. Can be installed directly, loaded on there.
2. Do not install, and then the SQL 2005 all unloaded after reloading will have.
3. Not installed, download from Microsoft's official website: Microsoft SQL Server Management Studio Express,
You can use it on the load.
4. Reload system, install SQL Server 2005 First, then install VS2008


See the above method, for me, maybe only the third one is the best, but he is express, I think there is a lack of this
Point, if he is not the best, and others can do the best, I must let myself do the best, why my is also the enterprise
The industry version is not Management Studio, why some people like me, in other ways can be successful. So find and find,
Finally, in the middle of the night, I saw a saying on the internet, I didn't care too much: I had to put all the previous SQL Server Express
Uninstall clean. (Uninstall all the programs that start with Microsoft SQL (except that SQL 2000) and install them again)

I also noticed in the installation when the program detection system, the last one has a question mark, the following details are:
-Version Change check (warning)
News
* Version Change check

* To change an existing instance of Microsoft SQL Server 2005 to another version of SQL Server 2005, you must obey
Run SQL Server 2005 Setup and include skuupgrade=1 parameters at the prompt
It looks like my machine was previously loaded with SQL Server. Express,ok, a look at my machine, I used to do this,
Yes, uninstall Yes uninstall, this thing is quite a lot, finally is to kill, and then I first install the second one of the management workers
With, OK, did not think of success. Oh, look at the next, have not installed the database, and then install the first disk, OK, also succeeded. Is
It was a great effort, but it was a success, so, wow quack, laugh three, to shock ambition.

Through the above operation finally installed the system, from here can be seen, if you want to install successfully, you can have the following several methods:

1. Install SQL Server 2005 First, then install VS related software (not try, should be feasible).

2. If you installed the VS2005 or vs2008 and installed your own SQL Server Express 2005, you would have to put the previous SQL
Server All-in-room Express uninstall all clean and then install SQL Server 2005

3. When installing VS2005 or VS2008, do not install SQL Server EXPRESS,VS and install SQL Server after installation
2005 (Pro test, success, recommended)

This is supplemented by other netizens:

After installing sql2005, there is no SQL Server Management Studio. What should I do?

1: The original installed with SQL 2000 and VS2005

Very simple Next management Microsoft China Download SQL Server Management Studio Expree version on line

When you installed the SQL2000, you brought your SQL management plug-in using Computer Management. You install 05 of Microsoft, you should choose a SQL Server Management Studio in the setup build, you may download a compact version, normally download a CD size. Extract 1.4G. If the administrative interface is urgently needed, it can be managed temporarily using the SQL 2000 management interface connection.

2:sqlserver 2005 there is no SQL Server Management Studio Solution

In two cases, one is the version problem, one is the installation sequence problem, please look down:

One, you install the SQL Server Express Edition edition, which is what we call the rapid development version

SQL Server the Express version is free of charge, Microsoft let you use, but it is a lot less function, but for learning, personal development function is enough. Installing SQL Server Edition Express, you will find that you can find a service manager for SQL Server 2005, but you cannot find its database manager because the Express version of SQL itself does not have a graphical management tool. If you need this tool, you need to download it from Microsoft.

The graphical interface tool used by SQL Server 2005 is Microsoft SQL Server Management Studio Express, which is now officially available for Microsoft to download.

In addition, Microsoft SQL Server the Microsoft SQL Server Express Edition Toolkit is also available for download, and Microsoft's Serve the Edition tool pack includes Microsoft SQL R Management Studio Express is inside.

You can download it, install it, and then install Microsoft SQL Server Management Studio Express in the SQL Server 2005 program group and use it for management.

(Note: The above is Simplified Chinese version, you can also choose the version of other languages to download)

Two, the second situation is the installation sequence problem

You might tell me that I'm not a express version, maybe you're installing Microsoft SQL Server Development Edition (the development version), this version is full-featured, functionally identical to the corporate version, no difference, There is only a difference in authorization. Why do I guess you use the development version? Don't be surprised, because this edition is a popular version of the internet, most Chinese people have the habit of downloading online or stall to buy pirated CDs, what software is downloaded from the Internet, a son does not need to spend, stall buy also 5 yuan, so I guessed right words most people use is development version.

Well, don't pull away, say, water cold a bit wordy, say a thing is not finished, please forgive me.

If you installed Microsoft Visual Studio 2005/2008 First and then installed Microsoft SQL Server Development Edition, you will also be able to post-install SQL Server 2005 there is no SQL Server Management Studio, because when you install Visual Studio 2005/2008, he automatically installs you with an instance of SQL Server Express, so you install SQL Server 2005 Development when testing installation compatibility, he will ask you if you want to change the version, said that your previous version is the Express version, it is estimated that most people did not look, direct "next", so after installation in fact your version is the Express version, so Microsoft SQL The Server Management Studio Express is naturally not installed. You can view your "service items" after installation and there will be a SQL Server Express version of the service.

Solution: The solution is to uninstall all of the programs that start with Microsoft SQL Server 2005 (including some tool components) in the Control Panel, and then reload to get it done!

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.