Showing posts with label exist. Show all posts
Showing posts with label exist. Show all posts

Friday, March 9, 2012

Reporting Services Help

I am trying to use Report builder in both SQL 2005 and SQL 2000( which does not exist in the version). I am trying to run the reports off of my created vies.
Cany one one explain how to do this.

My process is I open VS 2005 Business Itellgence and select Report Model.
Then I selecet my datasource , then my Data source view, then I create my Model.

However, it only allows me to view mt Tables, not my created views or created Queries.

I need to know how to get my views to be accessible and also is Reporting Model Available for SQL 2000 reporting Services and if not why.

thanks.

danjaman:

also is Reporting Model Available for SQL 2000 reporting Services and if not why.

Report Model is not available for SSRS 2000. It is only available for SSRS 2005

Wednesday, March 7, 2012

Reporting Services Error - SQL Server does not exist or access denied

Hi, I am unable to view my reports once deploying them. The error I get in Report Manager is SQL "Server does not exist or access denied". What is weird about this is that I am able to run the reports within the preview tab (in visual studio .net 2003). When I try to use the same connection string in Report Manager I get the error. Please note that I deploy the reports from my computer onto a different server where I am trying to access them. This problem started after installing some critical windows updates onto my local computer and it is driving me crazy. If anyone could suggest a course of action it would be greatly appreciated - so far I have not been able to make sense of what the problem is.
Thanks.Problem Solved - the database was using port 2433 - so i just changed that in my connection string.