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

Unable to connect to Azure SQL because of TCP/IP
answered 11-05-2020 02:28:23 -0400

Hi, I have been unable to connect to my Azure SQL database that i'm running on Azure VM. I am using Denodo Express to tryout the product. It keeps returning the "Unable to establish connection: The TCP/IP connection to the host, port 1433 has failed",...

Answers: 1

Azure Cloud TCP/IP SQL Server

Not able to connect to SQL Server using an Active Directory account
answered 14-04-2020 04:35:40 -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: 2

SQL Server Active Directory

Pass-through security for SQL Server data sources
answered 18-12-2019 17:13:58 -0500

Currently we are using LDAP and Active Directory to allow users to authenticate to data sources in Denodo. We would like the capability to ignore this and use pass-through authentication, based on SQL Server permissions. In other words, if a user has W...

Answers: 1

SQL Server Active Directory Denodo_SQL_Server pass-through

VQL equivalent for T-SQL "WITH (NOLOCK)"
answered 13-06-2019 21:26:31 -0400

Our DBA claims that the Denodo view is causing DEADLOCKs on the SQL Server. They recommended us to pass the query to SQL Server with the "WITH (NOLOCK)" option. Is this possible with Denodo views? If yes, please provide specific example. Btw, the SQL...

Answers: 1

sql server deadlock nolock deadlock read uncommitted sql server

Compare sql Vs vql using denodo testing tool
answered 13-06-2019 12:11:13 -0400

This is the errror I am receiving. Exception in thread "main" java.lang.IllegalArgumentException: Missing configuration parameter 'encoding' at com.denodo.connect.testing.Configuration.get(Configuration.java:106) at com.denodo.connect.testing.Configur...

Answers: 2

Denodo TEsting Tool SQL Server

How to use Microsoft SQL Server 2016 (MS Driver) to connect to SQL Server with Windows Authentication (not SQL Server Authentication)
answered 12-06-2019 12:04:53 -0400

I am unable to configure SQL Server as a Data Source using the "Microsoft SQL Server 2016 (MS Driver)" as the Database Adapater where the user is a Windows Authenticated user (i.e., not a SQL Server Authenticated user) but without having to setup Kerbe...

Answers: 2

Data Source SQL Server MS Driver

Sql Vs vql using denodo testing tool
answered 24-05-2019 08:01:29 -0400

hello, how do I connect sql server using integratedservices; and compare with vql using Denodo Testing Tool. Please help!! Please provide link if there is documentation. When I tried I keep getting java configuration 'encoding' error. I am able to tes...

Answers: 1

Denodo TEsting Tool SQL Server

JDBC Connection to SQL Server Express - URI
answered 29-04-2019 19:00:03 -0400

Running Denodo Express VDP on my laptop. Got SQL Express installed and loaded with AdventureWorks DW 2014 data. What would be the URI if this is the case? I am trying to connect via JDBC using the following URI: jdbc:jtds:sqlserver://IA-EME/SQLEXPRESS...

Answers: 3

SQL Server

Not able to access the Data sources option (Json or SQL)
answered 07-03-2019 05:39:05 -0500

I want to create the jason and SQL base view in Denodo 7.0. When i go to the sources I see only Excel and LDAP option. Other option is there but not able to use.

Answers: 1

SQL Server #HTTP #Post #Rest_API #webservice

Write values to a data base
answered 20-02-2019 18:17:36 -0500

Hi, can we use Denodo to write (insert records, delete recors, modify) the results of a given query to a data base? (i.e i would like to store the results of a query into a SQL data base) Many thanks,

Answers: 1

Insert Operation SQL Server SQL