存取被拒(Microsoft SQL-DMO ODBC SQL状态: 42000)解决方法
错误22002:RegCreateKeyEx()传回错误5,存取被拒(Microsoft SQL-DMO ODBC SQL状态: 42000) SQL Server 2000 为了符合最低权限要求,通常会将SQL Server与SQL Agent启动账户都改为Local Windows User account,后来再去Enterprise Manager config一些组态设定却
错误22002:RegCreateKeyEx()传回错误5,存取被拒(Microsoft SQL-DMO ODBC SQL状态: 42000)
SQL Server 2000
为了符合最低权限要求,通常会将SQL Server与SQL Agent启动账户都改为Local Windows User account,后来再去Enterprise Manager config一些组态设定却出现此错误讯息,回家重新再翻了一下MCSE Training Kit - SQL Server 2000 System Administrator 猜想可能是机码权限问题,果然解决了,提供给大家参考参考
[状况]
当设定SQL Server启动账户改为一般local user account或domain user account之后,
再到Enterprise Manager设定SQL Server属性(组态),将SQL Server或SQL Server
Agent 勾选[自动启动]就会出现此错误讯息
[原因]
使用Enterprise Manager修改SQL Server启动账户,虽然可以将启动账户自动赋予应有的权限,但登录档仍须做一些权限修改才能排除此错误讯息
[解法]
1.启动登录档编辑器
2.修改前先备份登录档
3.找到以下位置
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServer
若是具名个体
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQL$InstanceName
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLSERVERAGENT
若是具名个体
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLAgent$InstanceName
4.在以上机码右键,选择[权限]加入一笔新设定SQL Server启动账户,权限设定为[完全控制]
做完后直接在到Enterprise Manager勾选 自动启动SQL Server,应该就不会再出现错误讯息了
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
Key differences between Microsoft 365 Copilot, Bing Chat Enterprise, and Copilot in Windows
Sep 23, 2023 pm 03:57 PM
Currently, Microsoft offers three different AI assistants to enterprise customers: Microsoft365Copilot, BingChatEnterprise, and Copilot in Windows. We would like to explain the differences between these three options. CopilotinWindows: Copilot in Windows is a powerful tool that helps you complete tasks faster and easier. You can seamlessly access Copilot from the taskbar or by pressing Win+C, and it will provide help next to any application you use. Copilot in Windows features new icons, new user experience and BingChat. it will be 2
Easily remove borders in Microsoft Edge in three simplified steps
Sep 02, 2023 pm 02:57 PM
Many users are dissatisfied with the white border around web pages in Microsoft Edge. They think it's unnecessary and distracting, and they're asking Microsoft to remove Microsoft Edge's bezels entirely. This is similar to the saying "don't fix what's not broken", but Microsoft doesn't seem to have taken this into account. Of course, it's a popular web browser that offers a variety of features, including a built-in ad blocker, tracking prevention, and a password manager. However, some users may find that the browser has a border around web pages. This border can be distracting or unsightly, and there are several ways to remove it. In a lengthy conversation on r/Edge, some regular non-internal users discovered,
Windows 12 will be a free upgrade, no subscription required
Oct 21, 2023 am 11:17 AM
Microsoft doesn't work with subscription-based versions of Windows 12, and you won't be charged any fees. People are still talking about Windows 12 being subscription-based, a rumor based on a string of code in a Windows 11 preview build. Some people are still wondering how Microsoft plans to make their next version of Windows a subscription model. It turns out that the rumor discussed by some media outlets was an "IoT Enterprise Subscription" based on Windows 11, not Windows vNext. For those who don’t know, Windows24H2 or WindowsvNext is the public name for Windows 12. Some media will win
How to log in to a Microsoft account on Windows 10
Jan 01, 2024 pm 05:58 PM
You can log in with a Microsoft account in the win10 system, but there are still many friends who don’t know how to log in. Today I will bring you the method of logging in with a win10 Microsoft account. Come and take a look. How to log in to win10 microsoft account: 1. Click Start in the lower left corner and click the gear to open settings. 2. Then find "Account" and click to open. 3. After entering the account, click "Email and App Accounts" on the left. 4. Then click "Add Account" on the right. 5. After entering the account interface, many options will appear. Click the first "outlook". 6. Enter your account number in the Microsoft account window that appears. 7. After all is completed, you can
Fix: Installation of this app package is not supported
Apr 13, 2023 am 11:43 AM
Microsoft distributes UWP (Universal Windows Platform) and desktop applications as .msixbundles. Apps and AppxBundle app packages in .Windows. Although the Msixbundle, Appx, and AppxPackage installers are reliable ways to sideload app packages, multiple users are unable to do so. Why am I getting an "App package is not supported" error? Some of our readers have received the "Should
Fix 'Your account is currently unavailable' error in OneDrive
Sep 13, 2023 am 08:33 AM
Trying to log in in Windows doesn't work either. However, a check on the Microsoft account showed that there were no issues with it. I am able to log in and out of my Microsoft account on Windows and the web and am able to access all services. Only OneDrive appears to be affected. Microsoft's error message, like most of the time, isn't very helpful because it's too generic to be of much use. It starts with the following statement: "Your OneDrive or profile may be temporarily blocked because it is experiencing an unusually large amount of traffic. In this case, the block will be removed after 24 hours" This is followed by another sentence, Other possible reasons for temporary account suspension are listed: "
How to download and install Clipchamp on Windows 11 and Windows 365
Aug 01, 2023 pm 11:34 PM
Back in September last year, we informed you that Microsoft had just purchased Clickchamp and planned to make it a Windows native application. Recently, we discovered that the Redmond tech giant will be adding the software in the latest DevChannelInsider version. In Clipchamp, users are said to find more unique offerings, such as a stock library filled with more than a million royalty-free videos, audio tracks, and images that can be added to videos. There's even an Azure-powered text-to-speech generator capable of creating voiceovers in more than 70 languages. Clipchamp also connects with OneDrive, which means you can quickly and securely
What software is microsoft sql server?
Feb 28, 2023 pm 03:00 PM
Microsoft SQL Server is a relational database management system launched by Microsoft. It is a comprehensive database platform that uses integrated business intelligence (BI) tools to provide enterprise-level data management. It is easy to use, has good scalability, and has a high degree of integration with related software. High advantages. The SQL Server database engine provides more secure and reliable storage functions for relational data and structured data, allowing users to build and manage highly available and high-performance data applications for business.
