Forum Discussion

SSWADOOD's avatar
SSWADOOD
Helper I
4 years ago
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...
report server remove datasource
  • SSWADOOD's avatar
    SSWADOOD
    4 years ago

    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.

SSWADOOD's avatar
SSWADOOD
Helper I
4 years ago

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.

OndraLDHL's avatar
OndraLDHL
New Member
1 year ago

Hi, we had similar issue that for some reason one of Data Sources just disappeared. It was internally in ReportServer DB provided but not accessible from reports or from Data Sources dir. Solution was to use PolicyId from other fully functional Data source possible to find in dbo.Catalog table under Type=5. Now all is ok, and "missing" data source is accesible/visible for reports and also for deployment. So thankyou for good hint! 🙂