sql server user permissions
SQL Server Reporting Services Configuration How To?
The setup:
I am trying to configure SSRS, and everything goes smoothly until the very end. When the setup is tested via Report Manager and Report Server on the localhost server where the databases are installed, the data sources and models display fine on the Home page for Report Manager... but when trying to access this same page from a different machine, only the very top part of the page appears. The users are not able to view the 'toolbar' nor can they see the Models and Datasources folders.
I've come across and resolved a LOT of issues with the configuration- that include everything from not putting any underscores in the Virtual Directory names to avoid XML issues to setting permissions on folders in the Windows directories... and I believe this may be a security issue as well. Does anyone know a way around this?
Thanks for your help!
In SQL 2K5 in general, you need to be sure that any server references are valid from all intended users' contexts. For instance, if you specify a source server name as "(local)" it may be fine and dandy when mgt studio on that server, but another matter entirely when running it on some other system. So be sure to use server names that can be resolved by any system with intended access. In many cases, such definitions are read from the server and executed from the context of the requesting client.
Good Luck!
[phpbay]sql server user permissions, 30, "11211"[/phpbay]
[phpzon]sql server user permissions, 5, Electronics[/phpzon]
SQL SERVER Tutorial - Security and Network Connectivity- Part1
