Link to home
Start Free TrialLog in
Avatar of picsnet
picsnet

asked on

Sql Reporting with SqlExpress

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...

tony
Avatar of the_b1ackfox
the_b1ackfox
Flag of United States of America image

You may have got this to work in cases where sqlserver express and another version of SQL 2005 installed to the same machine.  But MS ripped out the reporting in the express edition to incent people to used one of the paid versions.  When you have the multiple version installed on the same machine, you will find both versions running as well as multiple instances.
SSRS is now included with the exress edition - but you have to download a specific version of it (SQL Server 2005 Express Edition with Advance Services - http://msdn2.microsoft.com/en-us/library/ms365166.aspx)

Are you using a shared data source or one embedded in the report? Either way, have you checked that the connection string is set after you have deployed? Deploying doesn't overwrite the old datasource by default.

Try deleting the report from the server and then re-deploying it, and then configure the datasource manually. Also check that you haven't got any other data sources being used in the report.
Avatar of picsnet
picsnet

ASKER

yeah i'm using the sql express edition with advanced services and i spent hours changing all the datasources on the reporting server in every configuration i could possibly think of...
You mentioned that you don't get the problem when you deploy from Visual Studio, this means that there probably isn't a problem with SSRS, just a process issue.

After you upload the report manually, can you confirm that you are then manually setting each and every datasource for the report to a pre-created (and tested) shared data source?
Avatar of picsnet

ASKER

i was just changing it for one report and testing... i think i might have did all the reports for the first time, and yeah i know the datasource should work...
Avatar of picsnet

ASKER

a lot of times it seemed like i was changing it, but it just wasn't getting the changes... like when i'd change it to just a local data source instead of a shared... it'd still fuss about the shared data source.  a lot of times at the end i was only uploading one report to test though so the other reports weren't supposed to be in the system.  
ASKER CERTIFIED SOLUTION
Avatar of PFrog
PFrog
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of picsnet

ASKER

it was just installed the day i was playing with it