Rank: Newbie
Groups: Registered
Joined: 3/9/2018(UTC) Posts: 2  Location: Georgia
|
Is there a way to deploy this to Azure to generate a live dashboard for an Azure based SQL Server?
We are looking for alternatives to the long ended Azure Reporting Service.
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
Hi, no sorry no experience so far with an Azure deployment...
The Web Report Server is a standard ASP.Net application, accessing the repository files, so it should not be difficult.
Thank you for any feedback.
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 3/9/2018(UTC) Posts: 2 Location: Georgia
|
I have it deployed to Azure, and I have the repository directory moved. I'm able to log in if I select basic authentication or pass through if I select no security.
The problem I'm having now is that I can't see any report files in the directory. If I add a directory under the reports directory I am able to see the directory but none of the files. I have moved all of the files from the d:\programdata\Seal Report Repository into the new repository with the same directory names.
For the install I copied all of the files from the 'web' directory up to Azure, created a repository directory within that directory, created the subdirectories, and then pointed the web.config file to the new repository directory.
I'm guessing it is some sort of security thing? Any thoughts?
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
You are right, you should change the Repository Folder in your web.config.
Then, I would say that the process/user impersonated by IIS has no right to list files in the directory you are pointed to...
What authentication method is used in IIS (Anonymous I guess, if so check the that user identity used has rights on the repository folder).
Check also the identity of the application pool if you can do that in Azure.
Thank you to let us know.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 5/18/2018(UTC)
Posts: 40
Thanks: 2 times
|
As a long term follow up it does work fine in Azure. It takes a little futzing with setting the repository folder, but if you create an app service you can use the editor to manually push all of the files up using the App Service Editor.
You can use F12 in your browser to figure out what you missed/don't have lined up quite right. I put the repository under the wwwroot folder and set the repositorypath to just the name of the folder. It is then tied to Azure AD so it requires a login with 2FA.
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
