Data Browser
- Viewing Site
Sector 23 Code Bank
Logged in as:
Guest
Similar Topics...
Kill all connections to SQL Server Database
Sql Server 2008 Comma Delimited List
Determine which roles can access a .NET page
SSRS 2005 Pad Left to a number
SQL Server Rank/Partition
SSRS Aggregate of an aggregate
VS 2008 Port changing in solution file
SQL Server 2008 Maintenance Cleanup Task to delete database backup files
Problems creating a foreign key in Sql Server
Add existing solution to git using visual studio
The Traveling Salesman - Greedy Solution in Javascript for Mapping
Sql Server Identity Insert
SSRS Send multi valued parameter filter to stored procedure
Sql Server Statistics
SSRS Parameter default value is blank when deployed to server
Remove orphaned SQL Server Replication Publications
sql server date parts
Restore Mapping from Sql Server User to Login
How to Truncate a SQL Server DateTime
string trim in sql server
Testing SQL Code without cache - SQL Server
Retain Date Format when Exporting to Excel from SSRS 2005
SSRS 2010 Rendering in IE11
SSRS - Comparing multi-value parameter to NULL crashes report viewer
SQL Server 2008 will not shrink transaction log
Call Bing REST Mapping Services from .NET
Angular drop down select item with null value
JavaScript: Insert an item into an array
Customize selected item in ng-select
How to Submit a Sitemap File to Google
IE 10 .NET button will not post back, but link button does
Uninstall Outlook Add-In doesn't remove Menu
jQuery Mobile - All Hyperlinks go to blank page that doesn't load
Ok Google, what does a total lunar eclipse look like?
What does enableSessionState=ReadOnly actually do?
DateRangePicker (DanGrossman) does not support two digit years
Selenium does not always Click on Anchor Links, Checkboxes, or other Elements
overflow-x does not work in Chrome
Angular ui-grid does not clear cell data when reloaded
SQL exception thrown from stored procedure does not raise exception in C#
Granting SQL user rights to start a SSIS Job
Reporting Services - The Item '/Data Sources' Does Not Exist - Lost Administrator rights to SSRS
Somehow lost admin privileges to view/edit the datasources and
roles
for
SSRS
.
Solution
:
On the reporting
server
, reset the
SSRS
server
by performing the following:
1.
Open
SQL
Server
Configuration
Manager
2.
Right
click
'
SQL
Server
Reporting
Services
-
properties
'
3.
Log
On tab: choose 'Configure...' /
Connect
.
4. Verify
that
the '
Web
Service
Identity
' has
a
red
X
and is not configured (if it is, then this is not the
solution
that
will help you)
5. Use the
buttons
on the
left
to
create
a
new
Report
Server
Virtual Directory and
Report
Manager Virtual Directory (append 2 to the dir
name
so it is
unique
)
6.
Delete
the old directories from
IIS
and
application
pools
7. Now
create
new
virtual directories again with the
same
name
8. In '
Web
Service
Identity
' section,
create
your
report
server/manager
app
pools with correct
identity
.
9. Verify
that
SSRS
is
back
up.
Created By: amos
1/5/2011 5:13:05 PM
Updated:
1/5/2011 5:13:24 PM