Workaround 1: If you set the SA password when you install the database, you can clear the sa password. (people who are accustomed to installing the full version of SQL2000 can try this Chinese law)
Workaround 2: Install the SQL2000 database, but install the window validation mode and modify it into a mixed authentication mode. (You can use the SA Password Modification tool to modify the validation mode)
Workaround 3: The MDAC build may be corrupted. (MDAC version 2.8 installs the same data access core components as Microsoft SQL Server OLE DB Provider, ODBC Driver.) MDAC 2.8 The final release of the redistributable installer installs the core components of Data Access with Microsoft Windows Server 20,031.
This version does not include Microsoft Jet, Microsoft Jet OLE DB Provider, Desktop Database Drivers ODBC Driver, or Visual FoxPro ODBC Driver.
MDAC (Microsoft Data Access components)
(1) ActiveX data Object (ADO): An advanced, Easy-to-use interface to OLE DB.
(2) OLE DB: A low-level, high-performance interface for connecting to a variety of data stores. Both ADO and OLE DB can handle relational (tabular) and non relational (hierarchical or streaming) data.
(3) Open Database Interconnection (ODBC) is another low-level, high-performance interface designed specifically for relational data storage.
)
Workaround 4: Replace and re-register Msadox.dll and msadomd.dll two files under the C:\Program Files\Common Files\system\ado\ folder
Click to run input REGSVR32 C:\Program Files\Common Files\system\ado\msadox.dll
REGSVR32 C:\Program Files\Common Files\system\ado\msadomd.dll
PS: Workaround 4 is generally used to deal with this type of problem and one of the quickest solutions. If none of the above 4 can solve the problem, you can only redo the system.
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.