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?

asked 11 Feb '15, 20:50

mysorian's gravatar image

mysorian
1186612
accept rate: 0%

edited 11 Feb '15, 22:58

Graeme%20Perrow's gravatar image

Graeme Perrow
8.5k371109


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 ***.

permanent link

answered 11 Feb '15, 23:00

Graeme%20Perrow's gravatar image

Graeme Perrow
8.5k371109
accept rate: 52%

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.

(12 Feb '15, 03:08) Volker Barth

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

permanent link

answered 12 Feb '15, 16:34

mysorian's gravatar image

mysorian
1186612
accept rate: 0%

1

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

(19 Feb '15, 15:12) mysorian
Your answer
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:

×127

question asked: 11 Feb '15, 20:50

question was seen: 1,713 times

last updated: 19 Feb '15, 15:12