Notes for changing the connected database of AOS

Source: Internet
Author: User

Problem description:
Today, I directed the configuration of the changed AOS server to another database. The following error occurs:
Object Server 01: Internal error occurred executing stored procedure when creating session for the AOS.
Cause:
The error description indicates that an error occurred while executing the stored procedure for creating the AOS dialog. The new database was found to be programmable-> stored procedure, it is found that there are two stored procedures: createserversessions and createusersessions, which should be an error when calling the first stored procedure. where is the problem? Generally, this issue is related to permissions.
The AOS server accesses the database server through the domain name \ AOS server's computer name $. If a database is specified during AOS installationProgramThe account is automatically added to the database. If the account is not installed through the installation program, you need to manually add it to the database.
Solution:
Check the database-> whether the security domain name \ AOS server's computer name $ this account
View the properties of the two stored procedures-> permissions, whether the domain name \ AOS server computer name $ this account is available.
If not, add it.

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.