Showing posts with label authoring. Show all posts
Showing posts with label authoring. Show all posts

Saturday, February 25, 2012

RS Authoring over the Internet

It appears that to enable true authoring over the internet, you need to
create local users on the RS/IIS box, and create identical SQL logins so
remote users can build their DSN's for their reports.
Other ideas?
JeffFor one, use AD groups in SQL.|||Nope, doesn't work. Just tried it again to verify. I created a local user on
the box, added him to a local group, created a login for the group, and
added the login to the database role.
When trying to connect over the internet using ISQLW for example, I get
"login failed for user 'erstesting'". Native SQL logins work just fine.
Jeff
"Jerry Nixon" <jerrynixon@.gmail.com> wrote in message
news:36f558cf.0410131248.5c092472@.posting.google.com...
> For one, use AD groups in SQL.