Return
-
Title
I cannot configure my mart server: Data access error. Verify your credentials. -
Description
I cannot configure my mart server: Data access error. Verify your credentials. -
Resolution
Problem: I am trying to configure a SQL server mart and I get "Data access error. Verify your credentials". My username and password are correct.
Solution: the SQL server DBMS was not using port 1433. We had to look up in the event viewer and use the port the SQL server was currently listening on (52783 in this case). Changing the port number from 1434 to 52783 resolved this problem.