CODEWITHSUNDEEP
sql-serversql-server-2014datazen-server
denzel
denzel

Reputation: 33

DataZen - Data Connection cannot connect to SQL Server

I'm trying to create a data connection in DataZen to SQL Server 2014, but for any reasons it cannot connect.

My connection settings in SQL-Server: SQL Server 2014

I want to connect to the adventureworks database in DataZen: Data Connection

But every time I get the following error: enter image description here

I am really desperate right now and appreciate every tip. I tried with "secure connection" and without, also with username and without. The admin-user in DataZen is called "admin". But I don't think, that this makes any difference?!

Thank you very much!

Upvotes: 0

Views: 1464

Answers (2)

bcaspar
bcaspar

Reputation: 403

I encountered a similar issue-- the resolution was to add a new SQL login (in SSMS) with SQL Server authentication. Make sure to give this user appropriate permission on the tables you'll be working with in DataZen. Once I did that I was able to use that new login to successfully test the connection.

Upvotes: 0

Origin
Origin

Reputation: 272

  • Put IP address of the server in Data Source
  • Put Database name in Initial Catalog
  • Then specify the username and password(for connecting to DB)
  • Test connection

Upvotes: 0

Related Questions