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