StreamBase application cannot access a Microsoft SQL Server database

StreamBase application cannot access a Microsoft SQL Server database

book

Article ID: KB0076109

calendar_today

Updated On:

Products Versions
TIBCO Streaming -

Description

StreamBase application cannot access a Microsoft SQL Server database even though the database can be accessed from the same machine using Microsoft SQL Server Management Studio.

Resolution

In order to truly confirm that there is no issue with connectivity, you should access the database over JDBC (since this is how the StreamBase application connects during runtime). Instead of using the Microsoft SQL Server Management Studio, please use a jdbc-enabled utility such as DB Visualizer to confirm the connection is successful.

Issue/Introduction

StreamBase application cannot access a Microsoft SQL Server database