View Complete Post
The code is very simple:
// Initialise the reporting service Web Service
this.RSWebService = new ReportingService2010();
// Pass windos authentication credentials to Web Service
this.RSWebService.Credentials = System.Net.CredentialCache.DefaultCredentials;
// List children
List<CatalogItem> reports = this.RSWebService.ListChildren(folder, false).ToList();
The SQL Server is installed on a different machine (say server A) from the Web server (say server B). We are using Windows Server 2003.
The code work fine for all the scenario below:
i) Run locally (XP) to call the web service on the sql server
ii) Provide the Network Credentials with the username, password, and domain when calling the web service
iii) If the web server and sql server is using same server (i.e. not distributed)
I'm using windows authentication and impersonation. Any idea?
We are migrating reporting service reports from SQL server 2005 to SQL Server 2008 and facing below login issue.
We got a virtual machine with 2003 server and got SQL Server 2008 installed with reporting service.
I was able to publish my 2005 reports using VS 2005 easily.
1) But when I try to run the reports I am getting below errors at my website home page.
The permissions granted to user 'DomainName\MachineName' are insufficient for performing this operation. (rsAccessDenied)
I could not get why there is no user name in above error and how it says machine name does not have permissioin?
There should be at least some user id mentioned as per me.
What could be the reason of above error?
2) Also when I try to run reports using Reports website (i.e. http://server/Reports URL), I get below errro in executing the reports.
"An error has occurred during report processing. (rsProcessingAborted)Cannot create a connection to data source 'ReportSource'. (rsErrorOpeningConnection)Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'."
Here the question is how it is picking up Anonymous logon. I thought it might be using Network Sevice acct to access reports.
What should I be doing to resolve above errors?
3) Also one more point about the s
I have a report which is working fine on SQL server 2005 reporting service. Recently I moved it to SQL Server 2008 Reporting service but it returns [BC30494] error, saying "Native Compiler returns error: Line is too long". I am using Visual Studio 2008 BI,
just bring rdl of 2005 into a new project.
Does anybody know about this? Does 2008 implement some limitations on rdl size?
I searched about this issue and changed by short textbox name and no helps. There are some expressions inside the report but I couldn't locate which expression caused this error.
wondering why 2005 version works.
Thanks in advanced.
I've read through a lot of posts regarding the problem, but none of the proposed solutions have worked for me. I continue to get an error stating, "The permissions granted to user '<servername>\Rich' are insufficient for performing this operation. (rsAccessDenied)." If I am logged in as the local administrator account, entering the Reporting Services URL in IE doesn't give me that error, but it takes me to a blank page. I haven't been able to get to a SSRS home page at all.
Order of operations:
I've tried running IE as administrator, adding local machine to trusted sites, and just about every other suggestion I've found. I even ran the entire installation logged in as the loc
I would like to creating cross tab with static column after aggregate column. My report showed as below:
Name of employee
Total Rating (Average of Performance rating)
A. Managerial Employee
B. Non-Managerial Employee
Performance Rating is cross tab column
Total Rating is Aggregate column
Previous Average,Previous,Increment is static column
I look forward to hearing from you.
Thanks in advance,
I have an error when i try to access
The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
I have found lots of posts according this error but any of it describes my error.
Do you have any ideas about problem reason?
I am using Forms authentification
Here is my LOG file:
<Product>Microsoft SQL Server Reporting Services Version 2009.0100.1600.01 ((KJ_RTM).100402-1539 )</Product>
<Locale>English (United States)</Locale>
<TimeZone>GTB Daylight Time</TimeZone>
<OSName>Microsoft Windows NT 6.1.7600</OSName>
I just installed SQL Express 2008 R2 on an hp computer running Windows 7. The install reported no errors but when I configured the database service
log on I selected the log on to use my account (has Administrator privileges) and password. When I try to start the service I get the message "The parameter is incorerect. (0x80070057). Any advice will be appreciated.
is possible use reporting services in Sharepoint Foundation 2010 if I have installed SQL Server 2008 R2 RTM - Express with Advanced Services? I tried various settings and configurations, but it not works (I am not able successfully configure Reporting Services
Integration in Central Administration).
Now I am not sure that is possible use reporting services in SPF 2010 + SQL Server 2008 R2 RTM - Express with Advanced Services...