IP address of a running server

[Former Member]

Microsoft released a preview of PowerBI, an authoring tool for visualizing data from a variety of databases as described here:

http://hodentek.blogspot.com/2015/02/spin-out-cutting-edge-report-with-power.html
http://hodentekmsss.blogspot.com/2015/02/authoring-report-with-power-bi-using.html

I am a Sybase enthusiast and I tested whether or not it can connect to SQL Anywhere 16(being one of the Sybase Databases). However I come up with two different kinds of errors connecting to SQL Anyhwere 16

I have started the demo16 successfully. Now I provide the server name required by PowerBI as demo16 and the database name as demo. It throws an exception as follows:

DataSource.Error: Sybase SQL Anywhere: Connection error: No IP address found for demo16
Details:
    Message=Connection error: No IP address found for demo16
    ErrorCode=-2147467259

I go back and look at the properties of the server and I find an IP Adress (NAT) of the computer on which I am running this server. If I use this information for connecting to server from PowerBI, i get a different error as follows:

DataSource.Error: Sybase SQL Anywhere: Login mode 'Integrated' not permitted by login_mode setting
Details:
    Message=Login mode 'Integrated' not permitted by login_mode setting
    ErrorCode=-2147467259

Is the IPAddress of the demo16 server the same as the local machine? Is it possible to run the demo 16 server in Windows authentication mode?

Perhaps SQL Anywhere 16 is not supported?

[Former Member]

More details of the problem I faced are here with some screen shots: http://hodentek.blogspot.com/2015/02/powerbi-preview-reporting-from-sql.html

Finally found an answer that works

The server name should be : localhost:2638 the database name is: demo

For authentication use database authentication

[Former Member]

Finally I was able to create a report using PowerBI which was so easy to create. I wonder how far SSRS will go. Here is a link to the report post: http://hodentek.blogspot.com/2015/02/powerbi-preview-reporting-from-sql_13.html

[graeme_perrow]

The "'Integrated' not permitted" error is what you'll see if your connection string does not include UID or PWD. Can you post the entire connection string? Feel free to replace passwords with ***.

[VolkerBarth]

Besides that, you might make sure you start the demo database on a v16 network server, not on a personal engine - only the network engine will listen for TCP/IP connections by default, and that might be required for the PowerBI tool.