Troubleshooting
Problem
Gentran login attempt fails.
Symptom
Database exception encountered upon login attempt.
ODBC DSN Test Connection fails. SQL State: '01000' SQL Server Error: 10061
Diagnosing The Problem
Invoke odbcad32.exe (C:\Windows\SysWOW64\odbcad32.exe) to launch ODBC Data Source Administrator > System DSN and follow the screens to Test Connection; Test Connection fails.
Microsoft SQL Server Login
Connection failed:
SQL State: '01000'
SQL Server Error: 10061
Microsoft SQL Server Login
Connection failed:
SQL State: '01000'
SQL Server Error: 10061
Resolving The Problem
In ODBC DSN, in the Microsoft SQL Server DSN Configuration screen > Which SQL Server do you want to connect to? Server field, edit the Server field by entering the fully qualified server name and save the change.
For example: fully qualified server name ABCD.corp.efgh.com instead of server name ABCD.
ODBC DSN Test Connection successful. Gentran login attempt successful.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS6V3G","label":"Sterling Gentran:Server for Microsoft Windows"},"ARM Category":[{"code":"a8m50000000L2SsAAK","label":"Sterling Gentran:Server for Microsoft Windows-\u003EDatabase-\u003EODBC connection"}],"ARM Case Number":"TS020039742","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.1.0;5.2.0;5.3.0;5.3.1"}]
Historical Number
TS020039742
Product Synonym
GSW
Was this topic helpful?
Document Information
Modified date:
12 August 2025
UID
ibm17242048