Solved

Sql server 2005 security

Posted on 2007-11-15
3
182 Views
Last Modified: 2010-03-19
Hi everyone I keep running into security management issues while setting up sql server 2005 reporting services. The following is my setup. I am running iis and sql server 2005. I want to provide reporting services to all my clients via the public internet. I have about 40 different customers and i want each of them to have access to their data and their data only. In other words when I send them to myserver/reports and they log in i want each customer to only see his reports. I have two virtual directories reports and reportserver. What should the setting be in iis to allow the above scenario. Should i enable annonymous access if yes what should the user name and password be. What kind of authenticated access should i choose. Once this is set up what are the steps or how should i set up the security in myserver/reports so that each user has rights to only his info. Should I use basic windows authentication or should i use something else?

I hope someone can help me this very confusing and frustrating.  Thank you in advance.  
0
Comment
Question by:susan1978
  • 2
3 Comments
 
LVL 42

Expert Comment

by:EugeneZ
ID: 20298475
setup sql server security for users
http://technet.microsoft.com/en-us/library/ms191291.aspx

setup SRS security:
Managing Permissions and Security for Reporting Services
http://technet.microsoft.com/en-us/library/ms156014.aspx
0
 
LVL 42

Accepted Solution

by:
EugeneZ earned 500 total points
ID: 20298480

SQL Server 2005 – Security and Protection
http://technet.microsoft.com/en-us/sqlserver/bb331769.aspx
0
 

Author Comment

by:susan1978
ID: 20374349
I figured it out my self i had to give rights to the user on each leval not just on the lowest leval.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to export SQL to firebase ? 7 67
t-sql need help on t-sql 10 25
Download ms sql express. 2 25
RESTORE MASTER DATABASE -- NOW 2 17
I have a large data set and a SSIS package. How can I load this file in multi threading?
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

808 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