How to resolve "Login timeout expired " error while launching Statistica?

How to resolve "Login timeout expired " error while launching Statistica?

book

Article ID: KB0073608

calendar_today

Updated On:

Products Versions
Spotfire Statistica 13.3,13.4,13.5,13.6 and 14.0

Description

Users may encounter the following error when launching TIBCO Statistia in spite of entering the correct username/password and DSN

Error  -  " Login timeout expired (ODBC RETCODE: -1; State: S1T00, Native: 0, Origin: [Microsoft][ODBC SQL Server Driver]) [CssSPC.cpp(1725)] "


User-added image

Issue/Introduction

How to resolve " Login timeout expired (ODBC RETCODE: -1; State: S1T00,Native: 0, Origin: [Microsoft][ODBC SQL Server Driver])[CssSPC.cpp(1725)] " issue while launching Statistica?

Environment

N/A

Resolution

Generally, the " Login timeout expired " error occurs when an instance of the SQL Server database engine is not running and the SQL Server database engine could not run because of the incorrect server name, network issues, or any firewall restrictions. This is more of a SQL Server related issue rather than Statistica.

One of the resolutions to an issue is by updating the driver of data source from " SQL Server " to "SQL Server Native Client 11.0"

Instructions :
  1. Press Windows + R to open the Run dialog
  2. Type in odbcad32 and click OK to open ODBC data source administration 
  3. Add new data source in system DSN
  4. Locate the "SQL Server Native Client 11.0 " driver and click finish
  5. Add name, description of data source, and the server that needs to be connected, and click 'Next'
  6. After windows or SQL Server authentication, change the settings as per the requirement and test data sources 
  7. If the data source test completes successfully, then close the ODBC administration and restart Statistica

If the above resolution does not work then the " Login timeout issue" could be because of other reasons and in that case, you can contact TIBCO Support at  https://support.tibco.com/s/

Additional Information

https://stackoverflow.com/questions/37071716/odbc-sql-server-driver-login-timeout-expired

https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms190181(v=sql.105)?redirectedfrom=MSDN
Powered by Wolken Software