SQL Server Reporting Services Error

  • Hi Folks

    Im a bit of a newbie but getting the hang of it all pretty quick i believe.

    I am running a reportserver which just runs reports. I have a seperate DB server. The connection string is fine and I also set a specific user which is configured in the data source. Lets call it USER for now. THe USER user has read and write access to the DB and Connect has been selected for that user in the permissions tab on that specific Database. THe report was working fine before but we upgraded from SQL 2005 to SQL 2008.

    Ive been playing with since adn its only this report which stopped working, all other have no problem.

    Does anyone have any suggestions as to why I get the above Error when executing the report ???

    Cheers Guys :)))

  • What did you upgrade the Reporting Server or the Database Server?

  • OMG sorry I totally forgot to add this: I upgraded the DB server from sql 2005 to SQL 2008 running a on Server 2008 os 32bit standard. The reporting server is running SQL 2005 on a Server 2008 32 Standard OS.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply