August 5, 2016 at 1:38 am
Dear all,
I've been searching for nearly a day on this and it's much harder than I had expected. I have over 20+ reporting services running globally, with over 10k reports and 5k datasources, developed over the years by nearly 30 different developers. I am running a project to go over all logins of all datasources and I need a complete list of all datasources, INCLUDING the loginname used to connect. It turns out this information is nearly impossible to extract, and I've tried quite a lot!
Google:
- Found several scripts, including the XML one. All of them only show datasource name and database, not the login name used to connect to the database
- Tried using the webservice of RS, same issue.
Bing:
- Found nearly the same results, but it's extremely hard to search for the terms 'list datasource loginnames' or 'list data source username'. Everything points back to the regular scripts, that so many DBA's are copying/pasting. They're all the same.... and nothing helps me to list the LOGINS used by these datasources.
I am 100% convinced the datasource loginnames must be stored somewhere inside the database, or the RDL's themselves.
Does anyone have a clue how I can list all datasource login names of these 5000 different datasources?
Clicking on them one by one is impossible, so I really hope someone can point me in the right direction.
I can develop it either in VB.NET or Powershell or SQL, I don't really care which technology is used, as long as it gives me a list of all datasources and the DATABASE Logins used to connect to our databases.
*here's hoping someone tackled this before!
August 5, 2016 at 3:22 am
And finally a colleague of mine found this link inside SQL Server Central itself. 🙂
http://www.sqlservercentral.com/Forums/Topic1312030-150-1.aspx holds the fix for this.
By using reporting services webservice and a management RDL you can retreive this information.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply