Q&A BY TAG 'SQL Server'

You must sign in to ask a question. If you do not have an account, you can register here

Copying ntlmauth.dll to DENODO_HOME/jre/bin
answered 10-02-2019 22:01:51 -0500

Hi, I would like to add my experience with Denodo 5.5 in Windows 2012 64 bit. I had to copy ntlmauth.dll to %DENODO_HOME%/jre/bin and restart the server instead of %SYSTEMROOT%/system32. The latter wouldn't work and raised a "SSO Failed: Native SS...

Answers: 1
Related to: Accessing MS SQL Server using Windows Authentication

NTLM JDBC Data Sources SQL Server SSO

SQL Server recursive query
answered 14-12-2018 05:42:20 -0500

According to https://community.denodo.com/answers/question/details?questionId=90670000000XcjoAAC&title=Can+denodo+Support+to+recursive+queries+%3F Denodo doesn't support recursive query directly. I am trying to create a base view through the method...

Answers: 1

recursive query SQL Server

Not able to connect to SQL Server using an Active Directory account
answered 17-09-2018 08:55:00 -0400

Hello, I am using Denodo 6.0 In the VDP tool, I am trying to connect to a SQL Server database using a Active Directory account (domain \ account name). However, when I test the connection, the tool is telling me: 'Unable to establish Connection. Login ...

Answers: 1

SQL Server Active Directory

Datatype Issue while creating a base view from SQL Server
answered 10-05-2018 03:00:38 -0400

I have a table in Sql server with a column of date datatype. For this instance : Create table table_name ( dob date ) ; I have created base view on top of this table. But in base view, datatype of dob as text datatype in denodo which is not expected...

Answers: 1

DENODO MSSQL datatypes sql server SQLServer Date

ODBC connection issue
answered 07-05-2018 06:50:51 -0400

I am trying to connect sql server 2014. I installed ODBC drivers provided from denodo but connection issue as below. What is the fix for this?? "Unable to establish connection: server closed the connection unexpectedly This probably means the server t...

Answers: 4

ODBC SQL Server

How to connect the Denodo Server to the SQL Server who supports SSL?
answered 16-04-2018 08:31:24 -0400

The Denodo Server is trying to connect to the Client’s SQL Server using JDBC. But, the SQL SERVER forces SSL encryption. The SSL encryption can not be turned off on the client’s server so turning of SSL is not an option. In that case, how to connect th...

Answers: 3

SQL Server SSL

How to connect the Denodo Server to the Microsoft SQL Server who supports SSL?
answered 11-04-2018 04:11:40 -0400

The Denodo Server is trying to connect to the Microsoft SQL Server using JDBC. But, the MS SQL SERVER forces SSL encryption. The SSL encryption can not be turned off on the the server so turning off SSL is not an option. In that case, how to connect th...

Answers: 1

SQL Server MSSQL SSL SQLServer

Denodo connect to SQL server -- cannot log in -- troubleshoot
answered 14-02-2018 03:48:18 -0500

I am using JTDS SQL server 2012 driver, jdbc:jtds:sqlserver://server:port/database; useNTLMv2=true; domain=domainname after I input login and password, I got error message " Unable to estable connection: Login Failed for user xxxx". then I went to VP...

Answers: 3

SQL Server

Denodo connect to SQL server -- cannot log in
answered 05-02-2018 07:28:25 -0500

I am using JTDS SQL server 2012 driver, jdbc:jtds:sqlserver://server:port/database; useNTLMv2=true; domain=domainname after I input login and password, I got error message " Unable to estable connection: Login Failed for user xxxx". then I went to VP...

Answers: 1

SQL Server

Caching Service Views
answered 23-08-2017 08:29:10 -0400

There are 14 Service Views in my database which gives data from 2011 - 2018 (joining different combinedviews). We created partial service views for each of the service view by giving a where condition inside the Partial service view (less than 2016 and...

Answers: 1

cache DENODO Denodo Scheduler 6.0 SQL Server