Analyst login compatibility matrix

Summary

This article defines the supported combinations of:

• Operating Systems
• Microsoft SQL Server versions 
• Connectivity drivers
• OLE DB providers and 
• TLS protocols 

These components are required for Analyst clients to successfully connect to the database through Analyst and the Transaction Server Service.

The article also provides troubleshooting guidance to help diagnose and resolve failed login attempts.

Purpose

The purpose of this article is to:

• Ensure compatibility between Analyst components and the Microsoft SQL Server environment
• Provide guidance when upgrading operating systems or Microsoft SQL Server
• Support the diagnosis and resolution of login and database connectivity issues

 

Compatibility matrix

Supported compatibility matrix
SQL Server Version	Recommended Driver	Supported OLE DB Providers	TLS Version Range	Minimum OS for Max TLS
2025	ODBC 18.0+	MSOLEDBSQL19, MSOLEDBSQL, SQLNCLI11	1.2 – 1.3	Windows Server 2022 / Windows 11
2022	ODBC 18.0+	MSOLEDBSQL19, MSOLEDBSQL, SQLNCLI11	1.2 – 1.3	Windows Server 2022 / Windows 11
2019	ODBC 17.0+	MSOLEDBSQL, SQLNCLI11, SQLOLEDB	1.0 – 1.2	Windows Server 2016+ / Windows 10+
2017	ODBC 13.0+	MSOLEDBSQL, SQLNCLI11, SQLOLEDB	1.0 – 1.2	Windows Server 2016+ / Windows 10+

 

General recommendations

Follow these recommendations to ensure reliable connectivity and compatibility:

• Always verify compatibility after upgrading Microsoft SQL Server or Operating System
• Use the latest supported ODBC drivers and OLE DB providers whenever possible
• Prefer the MSOLEDBSQL provider and avoid deprecated providers such as SQLOLEDB.

 

Troubleshooting failed login attempts

Environment and compatibility considerations

Connectivity issues may occur due to one or more of the following conditions:

• Use of an unsupported or newly introduced operating system
• Mismatch between the Microsoft SQL Server version and the installed driver or provider
• Incompatible or unsupported TLS protocol versions

Security and permissions

Login and connectivity issues may be caused by security or permission‑related changes, including the following:

• Database user permissions modified outside Rebuild_loginname_username_links.sql script
• Use of administrative privileges
• Incomplete user migration when moving databases using third‑party or manual tools

Infrastructure and network changes

Connectivity issues may also result from recent infrastructure or network changes, including the following:

• Installation of security patches that affect database or network connectivity
• Network policies that block required communication, such as: 
  • Firewall 
  • Ports 
  • IP address changes

Configuration issues

Login and connectivity problems may be caused by configuration‑related issues, including the following:

• Incorrect settings in Analyst Configuration Tool
• Outdated or incorrect database connection strings
• Use of non‑recommended or deprecated provider connection strings. 
   
  Use the recommended provider connection strings. Analyst currently supports the SQLOLEDB and MSOLEDBSQL providers, with MSOLEDBSQL preferred where available. The image shows an example of the relevant configuration settings.

  

  Other strings may work also but have not been validated on all configurations.

Additional Considerations for SQL Server Express

• When using SQL Server Express, ensure that the following requirements are met:
  • TCP/IP is enabled in SQL Server Configuration Manager
  • The SQL Server Browser service is running

Failure to meet these requirements may prevent Analyst from connecting to the database.

SKF @ptitude Transaction Server Service issues

In some cases, the service may need to be reinstalled to restore proper operation.

Removing the Transaction Server Service

If required, the Transaction Server service can be removed manually before reinstallation.

Note: This action must be performed with administrative privileges.

To delete the service, run the following command from an elevated command prompt:

SC DELETE "SKF @ptitude Transaction Server"

After removing the service, reinstall the Transaction Server according to the approved installation procedure.

Contacting SKF Technical Support Group

For further assistance please open a support case using the Technical Support group's self-help portal at www.skf.com/cm/tsg. Once your support case is submitted, a technician will contact you to begin working on your issue. For urgent issues we are available at these times by phone:

• Monday through Friday, 5:00 a.m. to 4 p.m. Pacific Time -
  Phone: [phone] within the US or [phone] outside the US.
• Monday through Friday, 8:00 a.m. to 4:00 p.m. Central European Time -
  Phone: [phone].
• Monday through Friday, 7:30 a.m. to 4:30 p.m. India Standard Time -
  Phone: [phone].