When I tried to access the report manager after a fresh installation of Sql Server Reporting Serivces 2016 using the url http://localhost/Reports , I received the below error.
By default the installation gives access to Builtin\Administrators. In order to resolve this error below are the
steps that you can follow.
Step 1 Run
internet explorer as Administrator and open the Report Manager URL http://localhost/Reports
Step 2 Click on Site Settings icon and then
click on Security as shown. You can see
only one assignment of roles here for Builtin\Administrators
Click on Add group or user assign the role assignment as shown below.
Re-open internet explorer (non-admin)
and recheck the url. You will not get the error anymore.
Sunday, September 17, 2017
Below is a process that I follow every year to create a partition in existing multi-dimensional SSAS cubes that I maintain. Log in to t...
This morning I was trying to call a stored procedure and insert the results in a temp table using the following code -- create table #...
Did you ever have a situation where you felt like converting a Sql Server Analysis Services in Multidimensional Mode to Tabular Mode ? ...
I was trying to build an SSIS package that one of my colleagues has created. The first error that was thrown was as below: Exception des...