| Author |
Topic |
|
Anand.A
Posting Yak Master
109 Posts |
 Posted - 2011-10-19 : 04:12:41
|
| hii m newly for report service..so i want to know about that security in report server..i create a user & role in management studio for one db...now i create one report based on that db and deploy that..in that deployment web page,i open that folder properties..in that security tab..i create new role assignment in that new role which one i want to use [domain\user]which user i want to use management studio user or system administrator user..anand |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-19 : 04:28:02
|
| are you asking about report server roles or sql server roles?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Anand.A
Posting Yak Master
109 Posts |
Posted - 2011-10-19 : 04:37:07
|
| we cant use sql server roles in report server ah??anand |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-19 : 05:03:58
|
| report server have seperate set of roles defined where you can map users to like report browser,report publisher etc------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Anand.A
Posting Yak Master
109 Posts |
Posted - 2011-10-19 : 05:19:46
|
| ya ok thanks...in this user i want to use system administrator users or management studio login useranand |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-19 : 05:37:47
|
| you want to add all users in admin group to reporting server ?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Anand.A
Posting Yak Master
109 Posts |
Posted - 2011-10-19 : 06:22:25
|
| ya thanks how can i create admin groupanand |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
Anand.A
Posting Yak Master
109 Posts |
Posted - 2011-10-20 : 01:38:38
|
| hi i have 3 folder in my report server url home page but cilent want to see only 1 folder how to do this i used item level sequirty but all this folder displayed in tha home page how to do this..and i am using standlone system in that role assigment i want use domain\username so in this which user name i want to use..i want to create new user in my system orto want to use my cilent system user |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-20 : 04:16:18
|
| you need to map client user to a role in db after adding a login for it------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Anand.A
Posting Yak Master
109 Posts |
Posted - 2011-10-20 : 04:54:39
|
| ya ok i create new role assignment for my client user...what is map client user to a role in db ???is this db(schema)anand |
|
|
|
Anand.A
Posting Yak Master
109 Posts |
Posted - 2011-10-20 : 04:59:00
|
| i want to give access permission to my client user to view one folder but in my home page there are 5 folder now.. how to do this??anand |
|
|
|
Anand.A
Posting Yak Master
109 Posts |
Posted - 2011-10-21 : 00:43:14
|
| is there any way to createwhen i deploy my reports to my client...client user will put user name and password to enter in to report..anand |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-21 : 00:44:05
|
| is client user using windows authentication?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Anand.A
Posting Yak Master
109 Posts |
Posted - 2011-10-21 : 01:31:16
|
| yesanand |
|
|
|
|
reporting server role&group