Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ashishrj
Power Participant
Power Participant

Issue connecting to SQL Server 2016 Reporting Services server from iPad

Hello folks!

As per the documentation given here. I installed a VM for SQL Server 2016 CTP 3.2 in Azure and later tried connecting the same from iPad. But I could not connect successfully (credentials error). It asks for the following details:

Name your server 

Enter server address

Username 

Password

Refer image below from Power BI documentation:

 

pbi_ipad_ssmrp_connectcontosoguy.png

 

Can anybody help me out here what can be the different parameters to pass. What I provided was:

-Server name was I provided was any name. For eg. report_testing

-For server address, my VM server name is of the form servername.cloudapp.net. So I provided  servername.cloudapp.net/reports_preview/

- And finally server username and password

 

But I am not successful. Can anybody help me here. 

Note: I am using SQL Server 2016 CTP 3.2 which is in Azure VM

 

Thanks!

 

 

 

13 REPLIES 13
Yazdanifard
Frequent Visitor

Hi

I have the same issue: "check the address for server" with windows 10 power bi app. 

Any help??! 

 

www,powerbi-tricks.com
sanjayrathod123
Regular Visitor

Hello All,

 

I am also facing same issue in connecting to SSRS 2016 on Azure VM from PowerBI iOS app.

 

Tried following but none resolved the issue

1. Changes SSRS authentication from NTML to basic

2. Added inbound rules in the fire wall

 

Can anybody please help me?

 

Thanks,

Sanjay

ashishrj
Power Participant
Power Participant

Hello everyone,

Anyone can help me understand below error. Am I missing something or providing incorrect details.

 

SQL2016error.png

With the latest RC of SQL Server 2016, the "reports_preview" URLs went away.  It's now just server.com/reports.  I discovered this when my connections to SSRS Datasets via Mobile Report Publisher stopped working after an upgrade to the new RC in April 2016. Could that be causing your problems?

@jayeckles I am still struggling with connecting Power BI to SQL Server 2016 from Power BI iPhone App. Rest works fine. If possible can you please let me know what server name, username and password do we need to pass while connecting. I get an error related to invalid server credentials. 

Thanks !

add 'http://' before the server name. It should work!

@lushanthan I tried adding http:// but still the same error

 'Make sure that you are using SQL 16 Reporting Services Server address' 

Any setting required that I am missing from my end ? 

Hi,

 

The address you input for the mobile app should be something like http://ssrs.contoso.com/reports (or https).

Depending on your authentication type and active directory settings, the user name should be either <username>, <domain>\<username> or <username>@<domain>.

 

If your still seeing this issue, can you please provide us with more info?

1. Which SSRS 2016 version are you using?

2. Are you using http or https? (and if https - is your SSL certificate a self signed certificate?)

3. Did you configure any non-default authentication settings on your SSRS server? (The app currently doesn't support custom authentication such as form)

4. Is your server hosted in your corporate network, or an Azure VM?

 

Thanks,

-David

i have the same issue i can not coonect sql 2016 reporting services from my android app.its working fine on browser but not able to connect from phone.

 

i have give server address :

server address : http:"IP address":port no./reports

domain/username

password

 

however server is in our corporate network.

sql 2016 version :Microsoft SQL Server 2016 (RTM) - 13.0.1601.5 

using http://

its domain based user name and password which working fine in browser on server and outside of server i also can access.

 

 

message i am getting "make sure you are using a sql server 2016 reporting services server"

 

please help me out on this issue.

i have the same issue i can not coonect sql 2016 reporting services from my android app.its working fine on browser but not able to connect from phone.

 

i have give server address :

server address : http:"IP address":port no./reports

domain/username

password

 

however server is in our corporate network.

sql 2016 version :Microsoft SQL Server 2016 (RTM) - 13.0.1601.5 

using http://

its domain based user name and password which working fine in browser on server and outside of server i also can access.

 

 

message i am getting "make sure you are using a sql server 2016 reporting services server"

 

please help me out on this issue.

Hello David,

 

 I am also facing this issue.

 

I have asked about this here as well

 

Is your server hosted in your corporate network and on Azure VM?

Yes

Gaupe
Frequent Visitor

I have the same problem and when I tried to click on Advance Options. The app will be cloced. Have you found any solutions?

ashishrj
Power Participant
Power Participant

@Gaupe Not Yet 😞

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors