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 trying to log in as your own User:
You will need to ensure that you are using the correct password to get into Dimensions. If you are using the correct password and still cannot log in you will need to do the following:
1. Log into the SA account
2. Go to the System tab
3. Go to User Records
4. Locate the user from the list
5. Click onto Options
6. Click on the Edit button
7. Enter a new password
8. Press the Save button
Once the password has been reset, you can now log into Dimensions using the new password. Should you not have access to the SA account, then you will need to speak with your IT team who can assist you with this.
Upon checking User Records, if the user is not displaying within the list then please take a look at this article as the User will need to be set up again. If the user isn't showing then this might be because the user would of been deleted. Please note that their Security Profile settings may not be the same so you would need to follow this article.
As a last resort if your IT are unable to resolve, then Support will try to assist as best we can before redirecting you for Consultancy. For this please raise a new case online and reference the title of this article.