Summary :
Unable to log in to ABELDent on a workstation even with correct Username and Password. Getting one of the below messages
Solution :
1. Verify that the ABELDent username and password works on the server.
2. If the computers are on workgroup, make sure the windows user credentials used on a workstation exists on the server as well (Both username and password should match)
3. Make sure firewall on the server is not blocking sql connections on the workstation. Open up SQL ports on the server if needed with below commands from Command Prompt ran as administrator
netsh advfirewall firewall add rule name="ABEL SQL" dir=in action=allow protocol=TCP localport=1433
netsh advfirewall firewall add rule name="ABEL SQL UDP" dir=in action=allow protocol=UDP localport=1434
4. If the existing windows user account on the workstation doesn't work, try creating a new windows user account
5. Also make sure enough SQL permissions are given to users
6. To verify SQL connectivity
- Open ODBCAD32 from windows icon
- Under System DSN tab click on Add
- Select SQL server and click on Finish
- Enter "ABEL" in Name field
- Select name of the server in "Server" drop down and click Next
- And Test Connection. Make sure the SQL connection is successful
Product (s): ABELDent LS+
Category: Errors
Classification: Internal/External
Date Created: 16 June 2020
Created by: Kalpana Narendiran