[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Programaticly adding users to reporting services

Posted on 2009-02-24
1
Medium Priority
?
126 Views
Last Modified: 2012-06-27
I am using forms authentication and reporting services for reports. Every time a user is added to the applications table i manuall enter the user name into the security of the reporting server and give him rights in reporting server.  THe user in the application can edit his username. When he does that it breaks his rights to to his folders because the username in reporting services stays the same. I am also running into other problems like the username might not be unique in the datbase which is okay but in reporting services it is not ok it causes a conflict. Is there any way for me to edit the username or add a new username in reporting service programaticly via store proc so that it matches with the username in my sql table? Is there a better way to handle this so there is less customer frustration nad less manual work?
0
Comment
Question by:susan1978
1 Comment
 
LVL 51

Accepted Solution

by:
Mark Wills earned 1500 total points
ID: 23728596
Maybe think about useing Role based security : http://www.devx.com/dotnet/Article/27133
or if really needed, then a custom extension to RS security : http://www.devx.com/dotnet/Article/26759/0/page/1   -- which is part 1 of the above article.
And there is an example on codeplex : http://www.codeplex.com/MSFTRSProdSamples/Wiki/View.aspx?title=SS2005!Security%20Extension%20Sample&referringTitle=Home
And if you are a member of SQLMAG, then : http://www.sqlmag.com/Articles/ArticleID/93771/93771.html

Sorry about the links, but really it is the best way
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question