Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 Report Builder

Author  Topic 

mvanwyk
Yak Posting Veteran

99 Posts

Posted - 2007-04-23 : 09:14:06
Hi SQL TEAM

I have a few issues and I hope someone can assist me.

I have a Windows 2003 Server Running SQL 2005 with The reporting Server enabled.

I can publish all reports from Visual Studio directly to the server.

When I browser to my server for example
http://myserver/reports/
I get prompted for username and password
Username: Administrator
Password:****************
All this works 100%

When I assign a "New Role" I select "New Role Assignment"
Type in the Windows User account username for example "report"
And assign "Report Builder" permission and the "OK" to save.

When I log in using "report" user account I am able to view the properties tab which allows me to change any other user account permissions.

How do i restrict these users.
   

- Advertisement -