August 22, 2017 at 8:49 am
I'm working on a proof of concept project to render mobile reports on phone or tablets. I have made some strides, but I'm stuck on logging into server via Power BI App.
This is what I have so far:
Installed SQL Server 2016 Developer Edition on Local Machine C Drive ( just for proof of concept)
Installed SQL Server Mobile Reports Publisher on Local Machine C Drive
Designed a sample mobile report, and uploaded onto SSRS under Mobile Reports on Local Machine C Drive
IPhone
Set up/logged onto VPN using my phone
Downloaded Power BI App onto my phone.
Connected to Corporate WiFi network
Set SQL Server Network Connections to enable TCP/IP
Issue:
When I try and connect to Server entering in the http:// address it is not working.
This is my first attempt at doing something like this and I consider myself a novice when setting up a server, so I'm sure there is something I'm missing. Any guidance on how to achieve this would be most appreciated.
Thank you,
Cervello
August 22, 2017 at 11:46 am
If you were just using the browser on the iPhone, you'd use an http address. However, I'm not at all familiar with the app you're using, and usually, a connection to SQL Server isn't going to use http protocol, but TCP/IP, so in theory, that would mean an IP address, but again, I don't really know. If the Mobile Report publisher has a web page to go to, not unlike the regular SSRS which is usually http://servername/reports, then maybe that product has a similar page to navigate to.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
August 22, 2017 at 3:03 pm
If you are sure the URL is correct, then I'd be looking at firewall rules. It also seems a bit odd to have your IPhone connected to VPN and connected to corporate WiFi. Are you sure that is the correct process for accessing the internal network inside your corporation? To me that sounds like a nice way to bridge 2 networks.
I've also not worked with mobile reports, but can you view them on your desktop using the URL? If so, you can likely just connect using the mobile web browser and skip the app middleman.
when you say "it is not working", what error are you getting? 404 (ie not found which would mean the URL is not accessable), 403 (not authenticated), 50x (internal server error - ie your computer isn't configured properly) or something else?
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
August 23, 2017 at 8:47 am
I'm sure the URL is correct, and the Power BI App is definitely calling for the URL to make a connection. I read a few threads that said to connect to corporate Wifi and others referencing VPN, so the be honest it is likely not necessary for both. I can view them on my desktop using the URL, but if I try that same URL from my phone it errors out. I left my phone at home today, but will capture the error message tomorrow and post that information. I will also look into the firewall settings. Again not in my wheel house, but I did find a very length article on that topic as well.
Thank you for getting back to me.
Cervello
August 23, 2017 at 9:14 am
Since you can access the report on your desktop but not your mobile, I am expecting that your IT department has stuff blocked OR your local machine firewall is blocking the traffic.
Corporate wifi where I work has access to the internal network, but limited access to external. We even have VPN blocked by corporate wifi to prevent making a network bridge allowing wifi access to VPN.
Can you view it from a different computer on the same network? If not, then I'd say your local firewall is blocking it.
If you can view it from a different computer on the same network, I'd talk to your networking team and see what restrictions they have on wifi and on VPN and explain to them what you are trying to do. If you have a hardware firewall or a GPO that sets up firewall rules or you are not an admin on your machine (which I expect that you are since you could install software), you might not even have the permissions to change things so you can access it from your phone.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
September 9, 2022 at 9:31 am
This was removed by the editor as SPAM
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply