无法将类型为“Microsoft.SqlServer.Management.Smo.SimpleObjec
在使用sqlserver2005创建作业时，创建不了，提示 无法将类型为“Microsoft.SqlServer.Management.Smo.SimpleObjectKey”的对象强制转换为类型“Microsoft.SqlServer.Management.Smo.Agent.JobObjectKey”。 (Microsoft.SqlServer.Smo) 通过安装SQLServer2005
在使用sqlserver2005创建作业时，创建不了，提示
无法将类型为“Microsoft.SqlServer.Management.Smo.SimpleObjectKey”的对象强制转换为类型“Microsoft.SqlServer.Management.Smo.Agent.JobObjectKey”。 (Microsoft.SqlServer.Smo)
通过安装SQLServer2005SP2-KB921896-x86-CHS.exe，解决我的问题。
在安装此SP2的过程中也遇到Integrated services和组件服务安装失败的问题，因为Distributed Transaction Coordinator本地无法启动，解决方法如下：
1、删除注册表中的键：
?HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSDTC
?HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC
?HKEY_CLASSES_ROOT\CID
2、停止MSDTC服务：net stop msdtc
3、卸载MSDTC服务：msdtc -uninstall
4、重新安装MSDTC服务：msdtc -install
5、重新启动电脑
我的系统是Windows Server 2003 企业版
关键字：-1073737712(0x3FFFEFF0) COM+损坏 8004e00f
错误消息：
---------------------------
服务
---------------------------
Windows 不能在 本地计算机 启动 Distributed Transaction Coordinator。有关更多信息，查阅系统事件日志。如果这是非 Microsoft 服务，请与服务厂商联系，并参考特定服务错误代码 -1073737712。
---------------------------
确定
---------------------------
解决办法：
把 C:\WINDOWS\system32\dtclog 这个目录重命名（如果有），然后重新建立该目录。
在命令行下： msdtc -resetlog
然后 msdtc 就可以启动了。
然后启动此服务，再次运行sp2的安装程序，此时之前安装失败的模块已经能够安装成功，然后重启电脑，解决了sql2005创建作业失败的问题。
微软官方网的一个下载sp2的链接，
http://www.microsoft.com/downloads/details.aspx?familyid=D07219B2-1E23-49C8-8F0C-63FA18F26D3A&displaylang=zh-cn
打开链接，就是： Microsoft SQL Server 2005 Service Pack 2
点击"下载以下文件"后,可以看到：
文件名： 文件大小
SQLServer2005SP2-KB921896-x64-CHS.exe
355.4 MB
下载
SQLServer2005SP2-KB921896-x86-CHS.exe
297.4 MB
下载
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
How to change network type to private or public in Windows 11
Aug 24, 2023 pm 12:37 PM
Setting up a wireless network is common, but choosing or changing the network type can be confusing, especially if you don't know the consequences. If you're looking for advice on how to change the network type from public to private or vice versa in Windows 11, read on for some helpful information. What are the different network profiles in Windows 11? Windows 11 comes with a number of network profiles, which are essentially sets of settings that can be used to configure various network connections. This is useful if you have multiple connections at home or office so you don't have to set it all up every time you connect to a new network. Private and public network profiles are two common types in Windows 11, but generally
Implementing dynamic arrays in Python: from beginner to proficient
Apr 21, 2023 pm 12:04 PM
Part 1 Let’s talk about the nature of Python sequence types. In this blog, let’s talk about Python’s various “sequence” classes and the three built-in commonly used data structures – list, tuple and character. The nature of the string class (str). I don’t know if you have noticed it, but these classes have an obvious commonality. They can be used to save multiple data elements. The most important function is: each class supports subscript (index) access to the elements of the sequence, such as using SyntaxSeq[i]. In fact, each of the above classes is represented by a simple data structure such as an array. However, readers familiar with Python may know that these three data structures have some differences: for example, tuples and strings cannot be modified, while lists can.
How to create a video matrix account? What types of matrix accounts do it have?
Mar 21, 2024 pm 04:57 PM
With the popularity of short video platforms, video matrix account marketing has become an emerging marketing method. By creating and managing multiple accounts on different platforms, businesses and individuals can achieve goals such as brand promotion, fan growth, and product sales. This article will discuss how to effectively use video matrix accounts and introduce different types of video matrix accounts. 1. How to create a video matrix account? To make a good video matrix account, you need to follow the following steps: First, you must clarify what the goal of your video matrix account is, whether it is for brand communication, fan growth or product sales. Having clear goals helps develop strategies accordingly. 2. Choose a platform: Choose an appropriate short video platform based on your target audience. The current mainstream short video platforms include Douyin, Kuaishou, Huoshan Video, etc.
What is the type of return value of Golang function?
Apr 13, 2024 pm 05:42 PM
Go functions can return multiple values of different types. The return value type is specified in the function signature and returned through the return statement. For example, a function can return an integer and a string: funcgetDetails()(int,string). In practice, a function that calculates the area of a circle can return the area and an optional error: funccircleArea(radiusfloat64)(float64,error). Note: If the function signature does not specify a type, a null value is returned; it is recommended to use a return statement with an explicit type declaration to improve readability.
Best practices for type hints in Python
Apr 23, 2023 am 09:28 AM
It’s great to use dynamic language for a while, and the code is reconstructed in the crematorium. I believe you must have heard this sentence. Like unit testing, although it takes a small amount of time to write code, it is very worthwhile in the long run. This article shares how to better understand and use Python's type hints. 1. Type hints are only valid at the syntax level. Type hints (introduced since PEP3107) are used to add types to variables, parameters, function parameters, and their return values, class properties, and methods. Python's variable types are dynamic and can be modified at runtime to add type hints to the code. It is only supported at the syntax level and has no impact on the running of the code. The Python interpreter will ignore the type hints when running the code. Therefore the type
What are the main self-media platforms? What are the types of self-media platforms?
Mar 21, 2024 pm 06:36 PM
With the rapid development of the Internet, self-media has become an important channel for information dissemination. We-media platforms provide a stage for individuals and companies to showcase themselves and spread information. Currently, the main self-media platforms on the market include WeChat official accounts, Toutiao, Yidian News, Penguin Media Platform, etc. Each of these platforms has its own characteristics and provides a wealth of creative space for the majority of self-media practitioners. Next, we will introduce these platforms in detail and explore the types of self-media platforms. 1. What are the main self-media platforms? WeChat official account is a self-media platform launched by Tencent to provide information release and dissemination services for individual and corporate users. It is divided into two types: service account and subscription account. Service account mainly provides services for enterprises, while subscription account focuses on information dissemination. Depend on
C++ function types and characteristics
Apr 11, 2024 pm 03:30 PM
C++ functions have the following types: simple functions, const functions, static functions, and virtual functions; features include: inline functions, default parameters, reference returns, and overloaded functions. For example, the calculateArea function uses π to calculate the area of a circle of a given radius and returns it as output.
Analyzing the new features of PHP8: How to take advantage of stronger types of attributes?
Sep 12, 2023 am 11:26 AM
Analyzing the new features of PHP8: How to take advantage of stronger types of attributes? In recent years, PHP has become increasingly popular in the world of web development. Its flexibility and ease of learning make PHP a popular programming language suitable for a variety of projects. In an effort to continually improve and optimize the language, PHP8 introduces many new features, including stronger typing for properties. In this article, we’ll take a deep dive into the new features of property types in PHP8 and how you can leverage them to improve the reliability and performance of your code. Prior to PHP8, the type declaration of a property could be
