You cannot set the type to Microsoft. SqlServer. Management. Smo. SimpleObjec.

When you use sqlserver2005 to create a job, you cannot create it, and the system prompts that the type cannot be "Microsoft. sqlServer. management. smo. the SimpleObjectKey object is forcibly converted to the type "Microsoft. sqlServer. management. smo. agent. jobObjectKey ". (Microsoft. SqlServer. Smo) install SQLServer2005

When you use sqlserver2005 to create a job, you cannot create it, and the system prompts that the type cannot be "Microsoft. sqlServer. management. smo. the SimpleObjectKey object is forcibly converted to the type "Microsoft. sqlServer. management. smo. agent. jobObjectKey ". (Microsoft. SqlServer. Smo) install SQLServer2005

When you use sqlserver2005 to create a job, the following message is displayed:

An object of the type Microsoft. SqlServer. Management. Smo. SimpleObjectKey cannot be forcibly converted to the type Microsoft. SqlServer. Management. Smo. Agent. JobObjectKey ". (Microsoft. SqlServer. Smo)

Install sqlserver2005sp2-kb921896-x86-chs.exe to solve my problem.

The installation of Integrated services and component services fails during SP2 installation, because the Distributed Transaction Coordinator cannot be started locally. The solution is as follows:

1. Delete the keys in the registry:
? HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ MSDTC
? HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ MSDTC
? HKEY_CLASSES_ROOT \ CID
2. stop MSDTC: net stop msdtc
3. uninstall the MSDTC Service: msdtc-uninstall
4. reinstall the MSDTC Service: msdtc-install
5. restart the computer


My system is Windows Server 2003 Enterprise Edition

Keyword:-1073737712 (0x3FFFEFF0) COM + damaged 8004e00f

Error message:

---------------------------
Service
---------------------------
Windows cannot start Distributed Transaction Coordinator on the local computer. For more information, see System Event Logs. If this is a non-Microsoft Service, contact the service provider and refer to the error code-1073737712 for specific services.
---------------------------
OK
---------------------------


Solution:

Rename the C: \ WINDOWS \ system32 \ dtclog directory (if any) and recreate the directory.
In the command line: msdtc-resetlog

Then msdtc can be started.

Start the service and run the sp2 installation program again. The module that failed to be installed can be installed successfully, and then restart the computer to solve the problem of sql2005 job creation failure.

Download sp2 from Microsoft official website,

Http://www.microsoft.com/downloads/details.aspx? Familyid = D07219B2-1E23-49C8-8F0C-63FA18F26D3A & displaylang = zh-cn

The link is Microsoft SQL Server 2005 Service Pack 2.

Click "download the following files" and you will see:
File Name: File Size
SQLServer2005SP2-KB921896-x64-CHS.exe
355.4 MB
Download
SQLServer2005SP2-KB921896-x86-CHS.exe
297.4 MB
Download