sa password was changed or system error

Source: Internet
Author: User
Tags microsoft sql server odbc ole
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.

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.