Solution to the logon problem that occurs during the connection between MCGS and SQL database

Source: Internet
Author: User

When using MCGS and SQL, if the database username used in the script is SA, a small box will pop up after the system is started, asking you to log on again, even if you click the trust link, or not.

At this time, you can add a new login name for the database. In SQL2000, add the username to the security option in the Database Enterprise Manager. After adding the username, do not forget to go to the server role, select a permission for the newly added login name. I chose the first permission to perform any operations in the database.

If you start the system at this time, it will prompt you "the database disk is incorrect and cannot be started", because the configuration has not been updated in the data source ODBC, and SA was used before, change it to the new Login Name and restart 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.