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

Connecting to SQL Server using Windows Authentication with an SA Account
answered 05-05-2021 17:28:44 -0400

I have credentials for a QA SQL Sever enviroment but it requires Windows Authentication and you have to sign in as the SA account in order to access the DB. Is there a way to force this using the JDBC string? Or - do I need to do some type of authent...

Answers: 1

JDBC SQL Server password authentication

Connection with sql server database
answered 30-12-2020 00:52:28 -0500

Hi Team, I have to read one view from sql server database.How we can set up connection with sql database and can access view. Thanks in advance.

Answers: 1

SQL Server

Connecting MS SQL Server through Denodo Testing tool throws error.
answered 15-10-2020 07:07:41 -0400

I'm trying to establish a connection to SQL Server using the below properties through config file. mssql.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver mssql.jdbcUrl=jdbc:sqlserver://sqlsrv- devtest.database.windows.net:1433;databaseName...

Answers: 1

SQL Server SQL

Need help creating a Base View from a SQL Server Stored Procedure
answered 18-08-2020 08:14:29 -0400

I have a SQL Stored Procedure which I will use to create a Base View in Denodo. The issue is that the Stored Procedure takes an User-Defined Table type as input parameter. If I select the SP and click Create from Selected I get an error that says the ...

Answers: 3

Base view Create Base View Stored Procedure SQL Server

SQL Server date datatypes error in conversion for base views
answered 15-06-2020 04:04:07 -0400

¬°Hello dear Gurus! I'm facing an odd issue for which I found no way to solve it. Source Server DataBase is SQLServer 2016. SQL Server has Collation SQL_Latin1_General_CP1_CI_AS Conflicting datatypes: datetime2, smalldatetyme Here's dataty...

Answers: 1

Date Conversion datetime Base view Error SQL Server

SQL Server date conversion error in BaseView
answered 15-06-2020 04:02:11 -0400

Hello Support Team We are having a big stopper in a project with an odd issue for which we can't find a way to solve it. Technical data is and Consultant has already raised the same question: Source Server DataBase is SQLServer 2016. SQL Server...

Answers: 1

Date Conversion Base view VDP 7.0 SQL Server

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