SQL Server connectivity issues from Datamaker

Document ID : KB000016533
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

When trying to connect to my data source and data target,  I was not able to connect to my database in SQL Server.  I end up seeing an error appear in Datamaker with the following message.

 

Connection: Data Target

Profile: travel_e

odbc: 4060

SQLSTATE = 37000

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot open database "travel_e" requested by the login. The login failed.

 

How can I (as an end user of Datamaker) troubleshoot this issue?

Environment:
Windows install of Datamaker (all versions)
Answer:

Issues where you are not able to connect to a SQL Server database tend to be an environment issue and are very rarely product related.

In the case of Microsoft SQL Server,  the Datamaker application connects to the database using an ODBC driver.  When an error like in the above question appears, its because the ODBC layer is not able to connect to the database,  or the user configured with the ODBC driver does not have access to the database.

 

The first recommendation when it comes to a connectivity issue, is to check with your colleagues who may also be using Datamaker on another workstation and see if it works. If the connectivity works on your colleague's machine, then it is going to end up being a local issue with your workstation,  versus a more widespread issue.

 

If the connection profile worked the other day,  but now it is not working,  check with your DBA to see if your password has expired, or if your account has been locked out. 

 

Once you have made it past this step, take a look in your Datamaker logs.   You will find them in the following directory.  

%AppData%\Grid-Tools\DM_Logs\DM<YYYYMMDD>_<GUID>.log  

 

Sort on date in Windows Explorer to show you the newest log at the top of list.  You should see an error as shown below

24-11-2017 13:43:41 - DM Session 0842AD05A1A34A42A07AE5304F822B5D started.

24-11-2017 13:43:46 - Transaction connect : SQLCODE=0, SQLDBCODE= 0, Message="Test Data Repository connection. SQL Text = ""."

24-11-2017 13:45:04 - Title: FATAL CA Test Data Manager - Datamaker logon error

Message: Cannot connect using supplied values.

 

Connection: Data Target

Profile: Travel Target

odbc: 4060

SQLSTATE = 37000

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot open database "travel_e" requested by the login. The login failed.

Detail: 

 

For this sample,  the database account using the travel_e database had an expired password, that prevented the login to the database.

 

If you need to further test your connectivity to your database,  you can always run the ODBC 32-bit Data Source Administrator to test your connectivity between your SQL Server database and your ODBC driver. 

 

Just open your Data Source Administrator tool,  select your Data Source,  and configure to review your settings for the data source. Then you will have the option to test the data source at the end.

 

If you are still having issues with connecting to your  database after doing this basic troubleshooting, please check with your DBA for further troubleshooting ideas that are related to your environment.

 

If you and your DBA are still having issues with the connectivity from Datamaker to your database,  then please open a ticket with support,  and we will be happy to help you out.