In situations,
- Due to security concerns we want to change schema login password
- Someone had changed schema Login password and now we would like to reset the password
We come across issue where when users are trying to login to X3 folder, experiencing Application connection loading error with below similar message
“Connection to server failed: X3 engine error: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Login failed for user 'SEED'. : ini_com:Variable dimension:!(2)”
To reset the Schema login password, you could try the following steps:
Step 1: Change current schema login password using either
- Sqlcmd command prompt
2. Using SSMS (SQL Server Management Studio)
Step 2: Login to Sage console
- Select Folders in Console
- Select specific folder having the issue
- Select Change Password
- Provide old password (which we set in step 1)
- Provide New password
- Confirm Configuration
- Verify the operation is completed
Step 3: Verify if user can login as normal
