Sql Reporting with SqlExpress
Posted on 2007-12-03
This error is driving me nuts:
An error has occurred during report processing.
Cannot create a connection to data source 'ProcessTrakker'.
The feature: "The edition of Reporting Services that you are using requires that you use local SQL Server relational databases for report data sources and the report server database." is not supported in this edition of Reporting Services.
My database is local.... My datasource is: Data Source = localhost\SqlExpress; Initial Catalog = ProcessTrakker;
I've tried windows authentication.... I've tried sql... I've tried to change the service to local system which just ended up with me having to delete everything, and reinstall.. I've tried using shared data sources and local report data sources...
This kinda error doesn't happen when I can use the deploy options in visual studio, but i can't do this in this case because the place won't let me do an ftp connection, pinholes, etc... basically anything... I have to email myself the reports, and then upload them, and then create a new source, and it just won't work...
I also tried to get rid of the sqlexpress, and use a default instance, and i couldn't get it to work. I know that it should be allowed to do this, and I've got it to work on other systems after some troubles... but i don't know what makes it happy...