Groups | Blog | Home
all groups > sql server reporting services > october 2004 >

sql server reporting services : RS Authoring over the Internet


Jeff Dillon
10/12/2004 10:07:06 PM
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?

Jeff

jerrynixon NO[at]SPAM gmail.com
10/13/2004 1:48:04 PM
Jeff Dillon
10/13/2004 2:23:32 PM
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

[quoted text, click to view]

AddThis Social Bookmark Button