Error hints and resolutions encountered by SQL Server 2005 installation _mysql

Source: Internet
Author: User
Tags error handling file copy message queue microsoft sql server microsoft sql server 2005 mssqlserver

Install SQL Server 2005 for a long time, finally ... During the period of problems, want to take out and share with you.

The first type of error appears:

Unable to install and configure assembly errors in the COM + catalog:-2146233087
Unable to install and configure assembly C:\Program Files\Microsoft SQL Server\90\dts\tasks\microsoft.sqlserver.msmqtask.dll in the COM + catalog. Error:-2146233087
  
Solution to "Unable to install and configure programs in the COM + catalog" at SQL Server installation:
Cannot install and configure assemblies in the COM + catalog, C:\program Files\Microsoft SQL Server\90\notificationservices\9.0.242\bin\microsoft.sqlserver, Notificationservices.dll.
Error:-2146233087
Error message: Unknown error 0x80131501
Error Description: The transaction manager is available. (Exception from hresult:0x8004d01b)

"Solution"

At this time you can suspend the installation, do not click Abort, ignore, and do not click Cancel.

Follow these steps
1. Delete keys in the registry:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSDTC
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC
Hkey_classes_root\cid
2, use cmd execution stop MSDTC service: net stop MSDTC
3. Uninstall MSDTC service using cmd: Msdtc-uninstall
4, use CMD to perform reinstall MSDTC service: Msdtc-install
Click Retry to continue the installation.

How to handle COM + check failure during SQL Server setup.

The second type of error shows:

COM + catalog requirements (warning)
Message: The COM + catalog requires that if SQL Server Setup fails, Setup will roll back the installed system, but all. manifest files may not be deleted. The workaround is to rename the files, and then rerun Setup. For more information, see how to handle COM + check failure during SQL Server setup.
When installing SQL Server 2005 to the System check configuration, I encountered the above problem, my solution is:
First of all the services with COM + enabled, and then the DTC service started (note: This service is sure to start the Oh, if there is no starting can be referred to: Distributed Transaction Coordinator service can not start the solution. Then reinstall, the mistake is resolved. In fact, you can skip the first step (the services started with COM + all enabled), as long as the DTC to start the service is no problem.

The following is a Microsoft official solution:< How to troubleshoot COM + system configuration check failures in SQL Server setup >
Microsoft SQL Server 2005 Setup checks to see if COM + is configured correctly. If a configuration error is found, Setup will continue, but the following warning appears in the System Configuration Check (SCC) Report:
"If SQL Server Setup fails, Setup will roll back the installation that you made, but you may not delete all the. manifest files. The workaround is to rename the files, and then rerun Setup. ”
If the Microsoft Distributed Transaction Coordinator (MS DTC) is not running, or if MS DTC is not a cluster resource, a COM + error may occur if you are using a Microsoft Cluster server. COM + relies on MS DTC, whereas the Message Queue task in integration Services relies on COM +. If a COM + error occurs, the Message Queuing task in integration Services is available only if the COM + system is properly configured.
To use Message Queuing (also known as MSMQ), make sure that MS DTC is running and configured correctly. If SQL Server is installed on a cluster, MS DTC must be a cluster resource.

Follow these procedures to reinstall COM +:

I. Installation Component Services Snap-in

1> on the Windows desktop, click Start, and then click Run.
2> in the Open box, type MMC, and then click OK.
3> in the Console window, click Files on the menu bar, and then click Add/Remove Snap-in.
4> in the Add/Remove Snap-in window, click Add.
5> in the Add Standalone snap-in window, select Component Services from the Snap-in list, and then click Add.
6> Click Close to close the Add Standalone snap-in window, and then click OK to close the Add/Remove Snap-in window.
In the console Root \ Component Services window, expand the Component Services tree. This is where the error message can occur when COM + is having a problem.
Run SQL Server 2005 Setup again. If you receive an error message, reinstall COM +.

Second, reinstall COM +

1> from Add or Remove Programs in Control Panel, click Add/Remove Windows components.
2> in the Windows Components Wizard, do not make any changes to the selection and click Next.
3> always click to complete the wizard, and then run SQL Server 2005 Setup again.

At first due to the installation of the Enterprise version, the hardware has been detected several not clearance,

One is a hardware problem (this can be ignored),

The second one is the IIS warning,

The third is the performance counter registry hive consistency issue.

The fourth is that you cannot choose to install the default configuration during Setup, you can only choose to install but not configure server defaults, or the installation is complete but you cannot configure the perimeter application localhost and you cannot open SQL Server Configuration Manager, or you cannot connect to the server.

(i) Troubleshooting IIS warnings

I found a lot of information on the Internet.

My system is XP, I do not have a CD-ROM, so there is no way to use the CD to install, can only download an IIS online.

Windows Xp_sp1, XP_SP2, XP_SP3 systems are available in IIS5.1 version.

Windows 2000 system applies to IIS5.0 version

Windows Server 2003 system is available in IIS version 6.0

Windows Server 2008, Vista system is available for IIS version 7.0

1 Download a IIS5.1 version of the Internet, remember you download the physical path, it is best to download directly to your root directory, for example, download directly to D disk. Do not download to the folder, I choose to put in the D disk.

2 IIS5.1 is a compressed file, we will extract it to the current folder, such as the current IIS folder is d://iis5.1

3 Open-Start-Control Panel-Add/Remove Programs-Add delete Windows Components-draw on Internet Information Services to tick {just tick it off. Click the "Details" button below, tick all check boxes, and then click Next.

4 at this time the computer prompts you to insert a disc, do not tube it, in the pop-up dialog box browse item mouse click Drop-down menu, find you download IIS5.1 place, d:// IIS5.1, OK on the point dialog, when the computer began to install IIS, but it was only installed to two or three grid when it stopped disturbed, because the file can not be found. You don't have to be afraid, we continue to browse or Copy folder address d://iis5.1, click OK, and then the computer continues to install, this situation probably lasts four times, really to install so far, when your IIS5.1 is really installed in your computer. Note that IIS6.0 and IIS5.1 are installed in the same way.

5 open-Start-control Panel-performance and maintenance-management tools-internet information Services. Send it to your desktop.

The fifth step I do not know what the use, I just follow the internet said to do and then install the SQL Sever 2005 development version only the problem of hardware, even the counter registry problems are gone.

(ii) If the Counter Registry configuration unit Consistency problem is also indicated, then I also found this site should be helpful

(iii) SQL 2005 installation process OWC11 error handling

The following error was found during installation

Product:owcll

Error: Wrong 1706. Setup could not find the required files. Check your network connection or CD-ROM drive status. For other possible solutions to this issue, see C:\Program Files\Microsoft Office\office11\2052\setup. Chm.

I've got a real problem.

1 Find tools\setup\owc11 in the SQL Server 2005 folder. MSI, click Install

2 Put the SETUP under the Owc11.msi and all the. CAB file copy to local directory, run Owc11.msc, prompt for missing Office 2003 WEB compentent Browse-> Select Owc11.msc on hard disk, choose Reinstall.

After the installation is successful, reinstall SQL2005 it's all OK.

(iv) Unable to configure the perimeter application localhost

After the installation, because I want to use the Java Connection database, installed a JDBC driver, but in the Java test database has been prompted to say that TCP/IP here is a problem.

Start-Program inside find Micosoft SQL Server 2005-Configuration tool-server Configuration Manager, double-click to prompt for error, then Micosoft SQL Server 2005-Configuration tool-sql The following two application Configurator options on the Server 2005 perimeter configuration are also prompted for errors when they are turned on, so there is no way to enable TCP/IP in SQL.

Love Condition One

i) Right-click My Computer-manage-expand services and Applications-expand SQL Server Configuration Manager-find this MSSQLSERVER agreement inside of him, as shown below

(ii) Change the disabled TCP/IP to Enabled,

Third, you can open this peripheral application adapter, press the Stop, and then select the left to start, you can.

Situation Two

If it's still not working, or I can't find my computer down here-management-expand services and Applications-expand SQL Server Configuration Manager-to find this MSSQLServer agreement within him,

This time you can try it in this way

i) C:\WINDOWS\system32\wbem find framedyn.dll files,

II Copy it C:\WINDOWS\system32 here

III Start-Program inside Find Micosoft SQL Server 2005-Configuration Tool-server Configuration Manager,

Iv. enable it, repeat the third step of the case

After I tried a development version of the same three problems, the compact version can be successfully installed, but also encountered the problem can not be configured localhost ... However, I have a roommate is the XP system but once installed all buttoned up. Well, this is for those who are not so lucky to refer to the reference, hope useful.

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.