An error occurred while installing SQL. How to Solve the COM + problem?

Source: Internet
Author: User

 

If the COM + verification fails, there may be two reasons:
1. the COM + service has not been started, or the COM + component itself has an error. The solution is to reinstall COM + (install/uninstall-> Windows Components. Do not change anything. Go to the next step, and then enable the COM + service.

2. The appeal method still cannot be rejected, which may be caused by account permissions. the following error message is displayed in the system log:

The runtime environment detects inconsistency in its internal status. This indicates that there is potential instability in the process, possibly because of running custom components in the COM + application, components used by the COM + application, or other factors. D: \ qxp_slp \ com \ com1x \ SRC \ comsvcs \ txprop \ dtcinfo. cpp (158) error, HR = 8000 FFFF: transactionmanager-> getwhereaboutssize

Solution:
1. Click Start, click Run, type regedit, and then click OK.
2. Locate and click the following subitem:
HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ MSDTC
If the following items exist, go to Step 1 :? Turnoffrpcsecurity
? Allowonlysecurerpccils
? Fallbacktounsecurerpcifnecessary

3. Create turnoffrpcsecurity entry: A. On edit menu, point to new, and then click DWORD Value.
B. Type turnoffrpcsecurity and press Enter.

4. Create an allowonlysecurerpccils item: A. On edit menu, point to new, and then click DWORD Value.
B. Type allowonlysecurerpccils and press Enter.

5. Create fallbacktounsecurerpcifnecessary item: A. On edit menu, point to new, and then click DWORD Value.
B. Type fallbacktounsecurerpcifnecessary and press Enter.

6. Set the DWORD Value turnoffrpcsecurity item: A. Right-click turnoffrpcsecurity and click Modify.
B. In the Edit DWORD Value dialog box, type value 1 and click OK.

7. Set it to the DWORD Value of the allowonlysecurerpccallitem: A. Right-click allowonlysecurerpccalland click Modify.
B. In Edit DWORD Value dialog box, type value 0, and then click OK.

8. Set DWORD Value for fallbacktounsecurerpcifnecessary entry: A. Right-click fallbacktounsecurerpcifnecessary and click Modify.
B. In Edit DWORD Value dialog box, type value 0, and then click OK.

After you have changed the registry, you must restart the MSDTC Service. To restart the MSDTC Service, follow these steps: 1. Click Start, click Run, type cmd, and then click OK.
2. Type net stop MSDTC and press Enter.
3. Type Net start MSDTC and press Enter.
4. Open the component service Microsoft Management Console (MMC) Management Unit. To do this, click Start, click Run, type dcomcnfg.exe, and then click OK.
5. Expand component services and computers in turn, and then my computers.
6. Right-click my computer and click Properties.
7. Click the MSDTC tab and then click Security Configuration.
8. log on to the account in the DCT and change the account to nt authority \ NetworkService. If you need a password, enter a blank password.
9. Click OK twice.

 

Solve the Problem of COM + directory requirements when installing sqlserver2005

In fact, there are many possibilities for this problem. The last reason I found is that the two default services of the system are not enabled.

MSDTC and COM + system application. X I # 'y _ n
J3} 0f R, u n
1. Account Opening MSDTC Service
Start-run, Enter cmd and press Enter. In the command prompt line, enter MSDTC-install and press Enter. {. _ I? D' P

2. Enable the COM + System Application Service.

Right-click my computer, Click Manage, find the service and application, and click the Service under the ticket. And find COM + System Application in it. Right-click, click Properties, change the startup mode to "automatic", and click "start" below to enable the Service.
OK. Restart your computer and try again.

Supplemental problem (Fix pending in installation): here you must describe another problem during installation. If sqlserver has been installed and has not been fully uninstalled, you may also be prompted to suspend it, in this case, we recommend that you use Microsoft's dedicated uninstall tool to completely uninstall it, restart your computer, and then install it. 1tg B R M, J
If you cannot Uninstall a dedicated tool, you can also manually delete it in the registry. Click Start and enter Regedit in the running state to enter the Registry Editor. Click Edit-search in the menu, enter sqlserver2005, and delete all the keys found. Restart the computer and then install it. H $ _ r a k9i
7z N] @ c p: y l
If you think the above method is too troublesome or cannot be solved, congratulations, you can reinstall the system.
 

 

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.