Installation SQL2005 hint that you cannot find a problem solution for any SQL2005 component _mssql2005

Source: Internet
Author: User
Tags management studio sql server management sql server management studio

The SQL Startup service is not in service and the database is not connected. Open SQL Server Management Studio, select "Browse more" in the server name, and there is no option in the local server that appears. Select the Configuration Tool-> SQL Server 2005 perimeter configuration, select the perimeter configuration for services and connections, and Error: "No SQL Server 2005 component was found on the specified computer." No components are installed on this computer, or You are not an administrator on this computer. (SQLSAC) "



Select the service and connection's perimeter configuration, Error: "No SQL Server 2005 components were found on the specified computer." No components are installed on this computer, or you are not an administrator on this computer. (SQLSAC) "


SQL Server Management Studio, select "Browse more" in server name, there is no option in local server



Installed one afternoon,SQL2005 also repeated installation, uninstall many times, but the result is the same. Near to dinner when suddenly think of the first time to install SQL is the VS2008 in the SQL EE uninstall, will not be like this, hands-on installation VS2008

VS2008 installation, add components should be able to do not front VS2008, is already installed, just add the following SQL EE and SQL release


After the installation, sure enough, the service has SQL


Then open the service and connection's perimeter application Configurator, with

The database is finally connected.

Finally solved the problem, from the Internet to see some said that the next SQL development version of the install, the Enterprise version of the No, I did not try, 100K speed Drag a 1.5G of things still very laborious.
The first time to come here, see a lot of cattle people's article, very useful, thank you very much. I also posted my findings, hoping to find the necessary.

(08-09-02: Update) If you want to install the Enterprise version of my Web 2008 system, you must install the following patch file to install the SQL2005 Enterprise version.
http://www.microsoft.com/downloads/details.aspx?displaylang=zh-cn&FamilyID= fb0ee17e-96eb-4cbb-ac09-95a4dcf73077

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.