When logging in as SA
Please confirm with your IT department on what the 'SA' password is. This is usually the same as the SQL Server 'SA' login.
If your IT are unable to log into Dimensions or SQL Server as the 'SA' account, then they would need to log into the SQL Server and SQL Management Studio with the windows authenticated administrator account, in order to reset the 'SA' password.
If you are able to log into the SQL server with the 'SA' account, then the sql permission of the SA user would need to be checked. Please ensure that the 'SA' is both a sysadmin, and the user mapping has the db_owner permission for the database in question.
If this needs to be amended, another SQL / Windows authenticated admin will need to make this amendment. Note: you may get a SQL error ”Cannot use the special principal ‘sa’".
If so, this is a Microsoft SQL error and not an Access error, and thus your IT would need to further investigate.
Following this, you can then log into Dimensions as another user and follow the below in order to reset the SA password within Dimensions, and can set the new password the same as the working password for SA on the SQL server.
When logging in as your own user
Confirm you are using the correct password. If the password is correct but you still cannot log in, ask an administrator to reset it: 1. Log in to Dimensions with the SA account. 2. Click the System tab. 3. Click User Records. 4. Find the relevant user in the list. 5. Click Options. 6. Click Edit. 7. Enter a new password. 8. Click Save. You can then log in with the new password. If you do not have access to the SA account, contact your IT team for assistance. If the user does not appear in User Records, they may have been deleted and will need to be set up again. Note that their Security Profile settings may not be the same. If IT cannot resolve this, contact support. See Get support in Dimensions.