Questions on using rsconfig

[vbajock]

Hi all, I'm new to SRSS, at this point I am trying to get past some authentication issues on my web app. I've set up my ReportExecute2005.vb class in my web app, the data I am accessing is not particularly high-security stuff, and I have implemented my actual website security using the ASP.NET 4.0 Security Wizard to set up a separate database for user accounts since I don't want to authenticate these users thru Windows AD. What is the best way for my app to pass a user name and password to SRSS ? I have read up on rsconfig, and wondering if I could just use an AD account by running rsconfig -s SQLServerBox\Instance -e -u somedomain\someADuser -p somepassword and then putting this line into my code that calls the report ?

rs.Credentials = New NetworkCredential("SomeLowRightsADAccountName", "somepassword", "somedomain")

Or am I better off using a non-AD user set up in SQL server ? Can a SQL user be passed to rsconfig ? If so, how do I pass the credentials ?

Thanks for any help!