Hey guys, having some trouble with NetAdvantage Reporting. I recently deployed a ASP.Net MVC 4 Web Application to an IIS server and for some reason anytime the report viewer tries to connect to the data I receive this error.
Error in DataContext =DataSources.sqlDataSource1.
->An error occurred while binding an expression.
The chrome console reports this back,
POST http://liniumfb.cloudapp.net/MvcApplication3/ReportService1.svc/ajaxAddress/ProcessReport 400 (Error)
I'm very new to ASP.Net, and IIS and I'm at a lost. Any help would be greatly appreciated.
Sincerely,
Christopher
Hi Christopher,
Maybe this link helps you.
regards!
Simon
So I've been working on this problem and it seems to be an issue with the IIS server and user roles. My application is running in the defaultAppPool and when I change the defaultAppPools Identity to my user name the website loads the database. It seems that the standard practice is to give Network Service permission to access the database by going through SQL Server Management Studio and adding the proper user information to the database and then the standard user folder. I have done this and also changed the security settings on the database files (through windows) to grant access to these files. The problem still occurs when using the Network Service user. Does anybody have suggestions on how I can remedy the situation now?
Thanks
Chris