I start a network server using dbsrv17 as in here:

C:\Program Files\SQL Anywhere 17\Bin64>dbsrv17 -xs http(port=8082) "C:\Users\Public\Documents\SQL Anywhere 17\Samples\demo.db"

note: The documentation shows a different location for the samples folder.

The network server starts with these final few lines: Starting on port 2638 TCPIP link started successfully HTTP listener starting on port 8082 Now accepting requests

Now I try to connect to it using Power BI with the following information: Server: Localhost:2638 database: demo

It comes up with a screen requiring authentication information with two options Windows | Database.

If the database option is chosen with the dba/sql username\ password pair, it accepts and comes out with the timeout error (Timeout occurred while waiting for response).

Is there a way to set up the timeout and check it so that the problem may now point to Power BI's timeout?

Another related question, is it possible to use Windows authentication?

The computer is x64bit with Windows 10 operating system.

I could do connect Power Bi to SQL Anywhere 16 in a the past: http://hodentek.blogspot.com/2015/02/powerbi-preview-reporting-from-sql_13.html

asked 05 Sep '16, 20:14

mysorian's gravatar image

mysorian
1189913
accept rate: 0%

Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×178

question asked: 05 Sep '16, 20:14

question was seen: 1,251 times

last updated: 05 Sep '16, 20:14