.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Having Trouble deploying first report, I think it is permissions problem

Posted By:      Posted Date: October 24, 2010    Points: 0   Category :Sql Server

I think I got SSR installed ok.  From the Configuration Manager when I click on Web Service URL and Report Manager URL, IE opens and returns the correct pages.  I see report manager screen etc.

In BIDS I created a solution and a report that previews fine.  The properties page of the solution has a targetServerURL the same as what is in the Configuration Manager, web service URL tab; " http://IMB-T22:8080/ReportServer ".  IBM-T22 is the name of my computer.  8080 is the port it is using.  Port 80 is used by IIS and not running.

The TargetFolder was created ok...AdventureWorks, but the report does not deploy correctly.  If I deploy it times out.  If I debug I get I get the name of my report can't be found or a permissions error. 

In the solution property page I have tried various differnt TargetServerURLs..Localhost/ReportServer...ibm-t22/ReportServer...ibm-t22:8080/ReportServer...Nothing seems to work.  Please help

I belive I am having permissions problem.  I can connect to database from BIDS and preview data in my report.

When I installed SQL Server 2008 SR2, I used an account name "NT Authority/Sytem"   I used this because it was in drop down and was having problems with "Owner"

In Reporting Services Configuration Manager I have the foll

View Complete Post

More Related Resource Links

A connection could not be made to the report server - Problem deploying an SSRS report from Business

I’m having trouble with what seems to be a common issue for people, regarding deployment of an SSRS report from Business Intelligence Development Studio. Unfortunately none of the solution I have seen posted here (and elsewhere) have been able to help me so far.   Two of my collegaues can both deploy with no problem, and I am using exactly the same Target destinations as them (TargetDataSourceFolder, TargetReportFolder, TargetServerURL).   I have posted the error message below, which from my basic understaning would indicate, I think, a security issue (perhaps something local to my PC, or user account)   Has anyone experienced this particular issue who might be able to help?   Best wishes, Jamie TITLE: Microsoft Report Designer ------------------------------ A connection could not be made to the report server http://turpin-net.turpin-bg.local/Reportserver. ------------------------------ ADDITIONAL INFORMATION: Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message: -- <HTML dir="ltr"> <HEAD><meta name="GENERATOR" content="Microsoft SharePoint" /><meta name="progid" content="SharePoint.WebPartPage.Document" /><meta HTTP-EQUIV="Content-Type" content="text/html; c

problem deploying report model to wss3 site

hi, im having trouble deploying my report model. when i click on deploy i have to enter a user name and password (i asume that it is the username and password i use to enter my wss 3 site) after that it begin to deploy then i get these 2 errors: Error 1 The required field UserName is missing from the input structure. c:\documents and settings\administrator\my documents\visual studio 2005\projects\essreportproject\essreportproject\ESSP.ds 0 0  Error 2 The path of the item '/Data Sources/ESSP' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash. c:\documents and settings\administrator\my documents\visual studio 2005\projects\essreportproject\essreportproject\ESSP.smdl 0 0  when i go to my page in wss3 i can see the datasource and model directory, but i cant use them can someone help me with this and explain it for me.  

Problem deploying custom report item. Items shows in preview screen in VS, but not in server deploye


I have developed a custom report item that works fine in design and preview mode while in Visual Studio. I cannot get it to show up on my deployed reports. Here's what I have done so far:

1. Deployed the report using Visual Studio

2. updated the rsreportserver.config file with the following entry:

      <ReportItem Name="PedigreeChart" Type="Uabr.Rap.PedigreeChart.PedigreeChartRenderer, Uabr.Rap.PedigreeChart" />

3. Updated the rssrvpolicy.config file with the following entry.

                    Description="This code group grants Uabr.Rap.PedigreeChart.dll FUllTrust permission. ">
                                Url="C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin\Uabr.Rap.PedigreeChart.dll" />

I've also tried using the StrongNameMembershipCondition

Crystal Report vs 2003 convert to vs 2008 parameter problem


Hi friend,

I have a project develop with Visual Studio 2003, when i convert the project to Visual Studio 2005 is work well. But when i convert to Visual Studio 2008, the crystal report when have pass parameter will prompt the parameter field to re-type then show the report.

But in this converted project i create a new report and pass the parameter is ok. That means i wan re-do all report @.@??

Does someone can help me solve this problem??

Thank you

page postback problem with crystal report


Hi , i am creating crystal report with asp.net it is working showing data but  data is of two page its is take round trip action but report is not show 
until again i click on show button in this it is not propersly showing that data is how.

<br />
    <asp:Button ID="btnShow" runat="server" OnClick="btnShow_Click" Text="Show Report" />
<CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server" AutoDataBind="true" DisplayGroupTree="False" EnableDatabaseLogonPrompt="False" /> CrystalReportViewer1.ReportSource = null; SqlCommand cmd = new SqlCommand(strcmd, c.con); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); ReportDocument doc = new ReportDocument(); doc.Load(AppDomain.CurrentDomain.BaseDirectory + "\\rptQuotation.rpt"); doc.SetDataSource(ds.Tables[0]); // login info SqlConnectionStringBuilder csb = new SqlConnectionStringBuilder(ConfigurationManager.ConnectionStrings["conStr"].ConnectionString); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new Tabl

Report printing problem(ssrs 2005)

HI   i have a SSRS 2005 report with width as 32 inches i have a requirement to print the report in a3 landscape  but when i print the report it comes in 3 page width   is there any way to auto scale the report into a3 size without affecting the view in the report viewer   Thanks varun kumar

Deploying problem with SQL Express 2008 R2

Scientific software package works fine with SQL Express 2008 R2 on developing (mother) PC and Admin login mode, but difficulties are found elsewhere during installing and deploying on the client PCs.  We have used from year 2000 BDE (Borland Database Engine), which worked fine until now, but recently customers had been installing problems with Vista, Windows 7 and the local administration rights or permissions.   Thus I thought to test NT AUTHORITY\NETWORK SERVICE authentication, as this system is hopefully working again decades with coming new Windows versions. As not need to touch databases, ADO and authentication matters during last decade, I’m newbie with those topics.  Worked now few days with this problem, installed and unistalled SQL servers according to instructions, tested different connecting strings and now cannot found correction.  Solution is maybe and hopefully simple.   Attached is log data cut from (old and many times corrected) the main mother XP platform in Admin and Client (Guest) modes.  Same tests are done also with fresh XP installation on VirtualBox.  Used connecting strings are presented inside log files:           Main mother XP at Admin login:   2010-08-20 08:24:45.82 Server      Server local connection provider is ready to accept connection on [ \\.\pip

Problem using an action to link to a report in another site

Hi ! I'm using SSRS 2008 with WSS 3.0 (integrated mode) and I want, from a report in a site A, to link to a report in a site B. I'm using the full path to the report and when I paste it in a browser, it correctly shows the report. When I click on the link of the action in the report from site A, a report (having the same name) from site A is displayed instead... Any help would be appreciated Thanks Paul

Report viewer problem in Publish Website

hi all,          I have done website designing and i published that website in vs2005 after that i transfer to iis webroot. when i open the report viewer page i got the below error,An error occurred during local report processing.    The definition of the report 'Main Report' is invalid.      The report definition is not valid. Details: Data at the root level is invalid. Line 1, position 1.the same reportviewer page opened when i was upload to webroot without publishing website..i added all report dll file, but i got the above error (published website)Thank You,Arunabathan.G  

Report Builder 2.0 Permissions

I've recently moved from SSRS 2008 Standard/SharePoint Integrated to SSRS 2008 Standard/Native.   I have some users with full permissions to a single folder within the SSRS site.  They need to access ReportBuilder.  In my testing, I've added my user account to SystemUser on site settings, as well as given it full permissions to the folder.  However, I keep receiving insufficient permissions exceptions when trying to connect with ReportBuilder.  For the site URL in ReportBuilder, I've tried both http://servername/reportserver and http://servername/reportserver/folder_name.   Any ideas? Thanks

Having problem accessing multi-choice parameter in SQL Query in Report.

Hi, I have a report with a multi-choice input parameter. My report contains a dataset that uses CHARINDEX on this multichoice parameter. The dataset query is in text, not in stored procedure. When I run the report I get "the charindex requires 2-3 arguments the reason being that the SQL is run as follows (You can see the multi-choice list screws up the string: exec sp_executesql N'Select test.Region [Region], test.Location [Location], nvarchar3 [Year], nvarchar4 [StatisticType], nvarchar5 [StatisticType2], ntext2 [Detail], float1 [Amount]   from [WSS_Content].[dbo].[AllUserData] UD   inner join [WSS_Content].[dbo].[AllLists] AL on AL.tp_ID = UD.tp_ListId and AL.tp_Title=''Statistics''   left outer join   (       Select UD.tp_id [ID],nvarchar1 [Region],     nvarchar3 [Location]   from [WSS_Content].[dbo].[AllUserData] UD   inner join [WSS_Content].[dbo].[AllLists] AL on AL.tp_ID = UD.tp_ListID and AL.tp_Title=''Regions''   where UD.tp_ListId = AL.tp_ID   and UD.tp_ListId = AL.tp_ID   and UD.tp_DeleteTransactionId = 0x0   and tp_IsCurrentVersion = 1   ) test on test.id = UD.int1   where UD.tp_ListId = AL.tp_ID   and UD.tp_ListId = AL.tp_ID   and UD.tp_DeleteTransactionId = 0x0   and tp_IsCurrentVersion = 1  &n

Trouble importing strange column format report from Excel 2007 to SQL 08

Hi, I'm not sure whether this belongs in this section or the SSIS one so hopefully I've got it right!  Hoping someone will be able to help with a problem I'm having importing a report with header and detail rows from our antiquated POS system into SQL 2008 tables.  The reports export in Excel 2007 format and for each header row there can be one or more detail rows starting from column B.  As such I've tried several things such as openrowset, an Access 12.0 OLE DB source in SSIS and even COM automation of Excel to try and write a conditional split which will hold the header details in variables then write them to rows alongside the detail rows.  I've pasted a small sample of the data here as I wasn't able to attach it: 01/07/2010 @ 11:18 Page: 1 RECEIVING: Voucher Journal Sort: VC|Str|Vou Date|Vou #|Document SID Filter: Voucher Date: 01/06/2010@12:00a..30/06/2010@11:59p Include Item detail: DCS|Item#|Desc1|Attr|Material|Size|Qty VC Str Vou Date Vou # Qty ABC 001 15/06/2010 12345 38 E NN 66 200148 XXXXXXXX RED SHAD E NN 66 200149 YYYYYYYYY BLACK GO E PP 60 200154 ZZZZZZZZZ BLACK CDE 002 16/06/2010 13839 8 F SA 35 217500 XXXXXXXX Natural F SA FL 218674 YYYYYYYYY Chalk F SA WE 221462 ZZZZZZZZZ White FGH 001 21/06/2010 13905 3 F SH 85 126260 XXXXXXXX Navy IJK 001 23/06/2010 13914 3 E AA 61 250005 YYYYYY

drilldown report problem

Hi, We are using SSRS 2005 and Sql Server 2005. I have a requirement to do drilldown report with +/-. I need to do group by CID. This is how my data looks CID    TID  fund position amount 1        11    xx    high      700 1        12    yy    Low      500 2        13    zz    Med       600           14    zz    high      800 So, TID is unique and I have to group by CID. Some rows will not have CID. What I have to do is, When I group by CID and enable +/-, all my empty CID rows are coming under + sign with out CID. My requirements are: If CID is there and there are more that 1 row for that CID, enable +/-. IF CID exists and only 1 row for that CID, do not give +/- If there is no CID, show all those transactions as independent individual transactions with out +/- sign. When I group by CID, I need to show total amount also in group header.  I appreciate your response, if some one can help me in figuring out this. Thanks, Spunny  

Problem with Report parameter inside SSRS Report Viewer webpart with deployment from one server to a

Hi all,I've got this problem.me and my team have developed a lot of reports by using a SSRS configured in Sharepoint Integration Mode.For accessing these report we are using the Sql Server 2008 Report Viewer Webpart.One of its parameter is the Report ur that is an absolute url so the problem is when I move our solution from server1 to server2 I have to re-editing all pages where I've added the Report Viewer webpart for updating the report url with the new servername otherwise it's impossible to view the report.Is there any official or unofficial way to solve this problem ?many thanks

Data Driven Subscription problem - sub runs slowly, has 40 errors out of 300, but report server trac

I have two report servers and a single separate SQL Server 2008 server hosting the data source database and the report server catalogues. There is a data driven subscription that runs off a sproc that returns 300 rows with email addresses for this report to be emailed to. The report itself contains around 30 subreports each with its own sproc to retrieve data. As the report is executing there are long pauses between the times when emails are actually sent out, and the subscription status will finally end with something like "Done: 300 processed of 300 total; 40 errors." I am not sure how to go about troubleshooting this problem. Details: I kicked it off at (say) 2:00 PM. Within 3 minutes in the report server execution log I saw 300 entries. There were exactly 300 people who should receive reports, so the master report should have executed 300 times and sent out 300 emails. So this looked good in the execution log. But when I checked report manager's status page for the subscription it was listed as processing 50 out of 300... Then all activity stopped, about 15 minutes some more reports started emailing out, and now I see there are around 590 rows in the execution log and maybe 97 emails sent out... Then finally I get a grand total of 846 rows in the execution log and a grand total of 260 of 300 emails sent out with 40 errors so 260+40=300 exactly. The time betw

Deploying report from Visual studio 2008 to report server

Hi, When I try to deploy report from visual studio 2008 into report server in dev. enviroment, I am getting error messag saying ...specified data source is not found and permission granted to user is insufficient. But I am a content manager in specified report. Please any help ful suggestions!

Report on Sites, Lists and Libraries with Unique Permissions

I would like to get a report on Sites, Pages, Lists, Libraries, Items and Documents under a Site Collection having Unique Permissions. What is the best way to accomplish that ?
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend