Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 194
  • Last Modified:

Sql server 2005 security

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
susan1978
Asked:
susan1978
  • 2
1 Solution
 
Eugene ZCommented:
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
 
Eugene ZCommented:

SQL Server 2005 – Security and Protection
http://technet.microsoft.com/en-us/sqlserver/bb331769.aspx
0
 
susan1978Author Commented:
I figured it out my self i had to give rights to the user on each leval not just on the lowest leval.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now