Forum Discussion
Solved
remove data source created on report server
hello, i created two datasource on the report server they were created succssfully , I messed up while working on the security of the second datasource and endedup deleting both builtin administr...
Thanks. i fixed the issue using MS sql server management studion and going into [Catalog] table of the report server and updated the [policyid] column of the 2nd data source same as 1st data source as it had all the correct privileges assigned.
Thanks. i fixed the issue using MS sql server management studion and going into [Catalog] table of the report server and updated the [policyid] column of the 2nd data source same as 1st data source as it had all the correct privileges assigned.
Perfect, it worked like a charm. I was having trouble accessing an old data source and this policy ID update made it possible to access it. Thanks a lot for posting this solution here. Saved lot of time.