We have reports in SharePoint integrated mode which are really slow when compared to native mode. I have been asked to research and give info on what exactly causes the delays.
Any articles which give me information as to what happens when a report is run from SharePoint server and where does it log.
I have recently installed Reporting Services Integrated mode with minor issues and at the end I was able to execute reports as well as add the content types.
I am now working on doing the same exact thing except I do not see Report Server Content types. I am able to upload a report and execute it but cannot add the Content Types. When I login into Central Administrator I see the content type in there. Is there something I am missing to add it to "My Site"
Thank you,
Dave
We have a Report Server integrated with SharePoint. A month ago we deployed a report (rdl file) in SharePoint, but the person who deployed it was no longer connected with us. So we decided to deactivate it in our Active Directory. Yesterday, our users returned issues regarding they are unable to access their report. I believe the issue was "object reference not set to an instance of an object".
So I tried to download the rdl file and redeployed it but i am getting error upon deploying to SharePoint. My workaround is to delete the rdl file in SharePoint, redeploy the shared datasource and shared datasets and the rdl file. It went and was now able to run the report in SharePoint.
Is there something relation/happened when deactivating the account in AD that users unable to access the report in SharePoint?
i have created an report which retrieve data from table which contains a datetime field. The data of that particular field is stored in UTC time. when i navigating the report from sharepoint site i wish the datetime field will be converted into local time based on the selected timezone of the user.
View 6 Replies View Relatedissue where SSRS reports being executed from a report library in SharePoint intermittently are reloaded after hitting the apply button to run. We are using SSRS 2010 and SharePoint 2013 in integrated mode. So a user clicks on the report, fills in the parameters and hits apply. Maybe 70% of the time the report runs fine. The other 30% the report just reloads and wipes out any parameter selections. We do have a load balancer in front of the web servers.
I've ran fiddler to capture some of the error logging.
HTTP/1.1 401 Unauthorized
Cache-Control: private
Content-Length: 16
Content-Type: text/plain; charset=utf-8
SPRequestGuid: 3101219d-876e-60c8-a883-dcdee38b81b5
request-id: 3101219d-876e-60c8-a883-dcdee38b81b5
[code]....
Things we have tried. Multiple versions of IE 8,9,10,11, Firefox, Chrome. All browsers seem to exhibit the behavior.
We ran so more traffic monitoring and it doesn't appear on these refreshes that report actually connects to the data context so it seems to be failing prior to that. (Possibly at the SharePoint server. Logging from the server apparently didn't show much in terms of when this occurred) It doesn't seem to matter if the report has 1 or 10 parameters.
We did notice that when we took the load balancer out of the equation and just hit the web server directly, the refreshes "appeared" to decrease in regularity but still occur.Also, the reports do not exhibit the refresh issue when running locally within Visual Studio 2013.
Hi,
I am receiving the following error when I run the report builder query. I am able to successfully select the dimensions and measures that I am intrested in but when I run the report I get the error message.
The 'PerspectiveID' custom property for the 'query' perspective is either not set or is not set to the string data type.
----------------------------
Semantic query execution failed.
----------------------------
Query execution failed for data set 'dataSet'.
----------------------------
An error has occurred during report processing.
I am testing this against both Adventureworks standard and enterprise cubes. Additionality I saw a post in this forum
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=368962&SiteID=1
that seemed related but I am using reporting services in sharepoint integrated mode so I am having a hard time trying to troubleshoot this.
Thanks,
Larry
We have SSRS reports (pointing to SQL 2012) containing cascading parameters that we have deployed on SharePoint 2013 and once a user makes a selection to the parent parameter, child parameters are getting refreshed based on the selection in the parent parameter and then we see this:
Once we hit Apply, the Loading image comes up and approximately10 seconds later, The whole webpage gets refreshed and the parameter selections get reset to default parameters.
This is getting frustrating because there are about 10 parameters in the report and once a user makes selections and hit apply if the page gets reset, the user has to make all the selections again.
We are working with Microsoft support on this who suggested us to increase the timeout setting of DistributedCache service on all our SharePoint servers which did seem to work initially but I do see this issue happening occasionally.
Hi,
I got the following exception from the code listed below:
System.Web.Services.Protocols.SoapException occurred
Message="The operation is not supported on a report server that is configured to run in SharePoint integrated mode. ---> The operation is not supported on a report server that is configured to run in SharePoint integrated mode."
Source="System.Web.Services"
Actor="http://haileizws32b:8080/ReportServer/ReportService2005.asmx"
Lang=""
Node="http://haileizws32b:8080/ReportServer/ReportService2005.asmx"
Role=""
StackTrace:
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.PerformancePoint.Planning.Client.Common.ReportServer.ReportingServices2005.ListChildren(String Item, Boolean Recursive) in c:Officedev14ppsplanningclientCommonReportingServices2005.cs:line 1001
at Microsoft.PerformancePoint.Planning.Client.Common.DataAgent.RetrieveDirectoryStructureFromReportingServices(Object caller, Object parameters) in c:Officedev14ppsplanningclientCommonAgentsDataAgent.cs:line 2027
InnerException:
The code is like:
ReportingServices2005 reportingServices = new ReportingServices2005();
reportingServices.Url = "http://haileizws32b:8080/ReportServer/ReportService2005.asmx";
reportingServices.Credentials = System.Net.CredentialCache.DefaultCredentials
CatalogItem[] items = reportingServices.ListChildren("/", true); <== This code throws the exception.
I can browser and view the items from both Sharepoint site and ReportServer site without problem.
Can you tell me what is wrong?
Thanks a lot!
Hi,
is possible to integrate SQL Server Express with SharePoint or it's possibile to integrate only the SQL Server 2005 version?
Thank's
Hi!
I wonder where in Reporting Services Configuration
i can change the mode to Share Point Integrated?
Do i need to create a new database,
or can i change the mode for the one i use?
//C
Up until an hour ago, I was using the Sql Server Reporting Services Report Viewer webpart in Sharepoint with forms authentication, and was not having an issue. The only thing that I did (or remember doing) before things went sour was upload a new report to the document list and since then whenever I try to access a report, manage the data source on a report, change the report URL in the webpart, I get the following message:
An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> The request failed with the error message:
--
<html><head><title>Object moved</title></head><body>
<h2>Object moved to <a href="/_layouts/login.aspx?ReturnUrl=%2f_vti_bin%2fReportServer%2fReportService2006.asmx">here</a>.</h2>
</body></html>
--.
I found some related posts and have tried the following, but none have helped:
Removed all reports and reuploaded only the one that was definitely working.
I changed the application pool for the report server to be the same app pool as Sharepoint (runs under domain admin account).
I changed the application pool for the report server back to it's original (which the Reporting Services Configuration prefers - was running under Network Service acct before the problem started, now running under domain admin acct)
I can browse to http://server/reportserver.
I'm running under forms authentication, which had been working.
I can access the three configs for Reporting Services under Application Management in Central Admin - I've tried changing the settings.
I can access http://server/_vti_bin/reportserver/reportservice2006.asmx as well as http://server/_vti_bin/reportserver/reportserviceauthentication.asmx (that was suggested in one post)
I've restarted IIS numerous times, and also finally rebooted the server.
I've created a new document list and set it for report content, just like the other list.
I also just noticed that even though I've set up my admin account as a site collection administrator, I now no longer see my report options under the New button in the document library (both the old and new). I don't know if this is related.
I'm sure that this is a case of something minor that I did that I forgot about. Any suggestions or other troubleshooting that I can do?
Thanks!
daw
I am trying to run a Reporting services report and pass a parameter using url access and SP Integrated mode.
I have managed to come up with the following: http://DashBrdRptSite/reportserver?http://npvmdashbrd1:2764/Reports/dashbrdrptstore/real%20time%20running/test.rdl&rs:Command=Render&Year=2006&Year=2007&Month=1
This works perfect as long as I run it from the actual server that has Sharepoint and reporting services installed.
If I try to run it from my desktop, I get prompted for a user name and password. And now matter how many times I enter my user/pass... it does not work.
If I just run the sharepoint link that appears on the report when I run it from within sharepoint... such as
http://npvmdashbrd1:2764/Reports/DashBrdRptStore/_layouts/ReportServer/RSViewerPage.aspx?RelativeReportUrl=%2fReports%2fDashBrdRptStore%2fReal+Time+Running%2ftest.rdl&Source=http%3a%2f%2fnpvmdashbrd1%3a2764%2fReports%2fDashBrdRptStore%2fReal%2520Time%2520Running%2fForms%2fAllItems.aspx&DefaultItemOpen=0
That runs no problem no matter where I run it from (my desktop or the Sharepoint Server), but it looks like I cannot pass it parameters. I guess becuase it is useing RSViewerPage.aspx.
Can someone please help me out?
Thanks
Hi there,
I'm running MOSS 2007 in Integrated Mode, and I have a number of reports that are deployed to the Reports Library, and are working just fine when you go there and run them interactively.
Now however, I need to address the report via a URL, and pass it a parameter. Just to add a bit more pain, the report is in mdx, and expects an mdx parameter.
Here is the parameter "prm_cost_centre":
[DIM LEARNER AIM].[COST CENTRE DESC].&[Business]
Here is the URL of the report:
http://vmmoss:88/ReportsLibrary/Report1.rdl
(If you hit that URL as is, it runs fine, using the default parameter)
Now, I know that we have to escape the ampersand, so I'm thinking that this URL should do it.
http://vmmoss:88/ReportsLibrary/Report1.rdl&rs:Command=Render&prm_cost_centre=[DIM LEARNER AIM].[COST CENTRE DESC].%26[Business]
But it doesn't - It throws a 400 Bad Request error.
I know I must be very close, but I just can't work out what URL I need to pass in order to get the damn thing to run.
Any ideas?
I verified logs for reporting services integrated with SharePoint and I found many errors like this:
Cannot find site lookup info for request Uri [URL].
what is wrong with configuration?
I have a report in which the jump to URL always works in Preview mode in Visual Studio. However, when I publish it to Sharepoint the link does not seem to want to render.
Most of the time if the link is short like http://server.domain.com it works fine.
When I try ="http://servername/projectcontrols/reports/Pages/PhaseExpenditureBreakdown.aspx?Phase="&Fields!PhaseName.Value as the expression it never works in Sharepoint, but does work in Preview Mode.
If I try ="http://"&Fields!PhaseName.Value then it renders the URL in Sharepoint.
Is there some kind of size limit to the URL?
We have been successful in creating a custom Excel Renderer that works very well on a server configured for SSRS Native mode. However we have another server that is configured to work in SSRS integrated mode that we can not get this custom renderer to work properly. The steps we follow are:
After the report results are displayed we select Actions -> Export -> Excel Custom . So I can see the name of our custom rendering type.
After a very short amount of time (no more than a second or 2) I get a frame that says: an unexpected error has occurred. Here is the URL of the web site:
http://sharepointserver/sites/BI/Reports/Reserved.ReportViewerWebPart.axd?ReportSession=2jqe4e45sm0sze553avovv55&ControlID=5c4fbb59def64efdac050393cd3fb338&Culture=1033&UICulture=1033&ReportStack=1&OpType=Export&FileName=edi001&ContentDisposition=OnlyHtmlInline&Format=CUSTOM_RENDERER
Is there anything that has to be done differently to get a custom renderer to work in SharePoint integrated mode?
Note: here is the article we followed to initially create the renderer that will work in SSRS native mode:
http://msdn.microsoft.com/msdnmag/issues/05/02/CustomRenderers/
Any help would be appreciated, thanks.
I'm deploying a performance point site which includes several parameterized SSRS reports. Reporting services is configured to run in Sharepoint integrated mode.
I'd like to pass the parms to certain reports via URL posts when a user clicks on certain fields in a scorecard.
I can setup the basic URL to open a report, as follows:
http://okcrptdev003:81/sites/pps/PPS%20Reports%20Library/Production%20Control/Monthly%20Flash%20Report%20-%20Mgt%20Summary%20Oracle.rdl
When this URL is executed, the sharepoint site redirects with the following URL, which opens the report and prompts for a text date paramater (DatePrompt) in the format dd-mmm-yy (i.e. 01-Sep-07)
http://okcrptdev003:81/sites/pps/_layouts/ReportServer/RSViewerPage.aspx?RelativeReportUrl=/sites/pps/pps%20reports%20library/production%20control/monthly%20flash%20report%20-%20mgt%20summary%20oracle.rdl
I attempted to modify the original URL call to include the date parameter as follows:
http://okcrptdev003:81/sites/pps/PPS%20Reports%20Library/Production%20Control/Monthly%20Flash%20Report%20-%20Mgt%20Summary%20Oracle.rdl&rs:command=render&DatePrompt=01-Sep-07
This resulted in a page not found error.
I then modified the redirected URL to see if that would work:
http://okcrptdev003:81/sites/pps/_layouts/ReportServer/RSViewerPage.aspx?RelativeReportUrl=/sites/pps/pps%20reports%20library/production%20control/monthly%20flash%20report%20-%20mgt%20summary%20oracle.rdl&rs:command=render&DatePrompt=01-Sep-07
This will open the report, but it ignores the parameter and continues to prompt for the date.
Does anyone have any suggestions?
Thanks, mike
Hi,
I'm working with the Dec CTP of SQL 2005 SP2 and the associated Sharepoint addin.
I've been able to get a report created in VS2005 and manually uploaded to the Document Library holding reports, and the report works when I open it (using an internal datasource, not shared).
My first problem is I can't get VS2005 to deploy datasources or reports to my doc library.
I have configured
TargetDataSourceFolder http://server/site/doclib
TargetReportFolder http://server/site/doclib
TargetServerURL http://server/
When I try to deploy my Shared Data Source, it asks me to login, and will not accept my credentials (I am farm administrator, and site collection administrator, and local administrator, and a site owner)
Secondly, for the report I manually uploaded, I can't edit it in Report Builder (from Sharepoint) because I get stuck on entering something that works into the Select Site or Server dialog box. I've tried http://server/ and http://server/site/ and http://server/site/doclib
Can I have some tips please?
Thanks
Martin
I am trying to follow the instructions on:
http://technet.microsoft.com/en-us/library/bb677365.aspx
they contain many "if"s and links to other sites and I got totally confused and stuck.
The idea is - I need to have one machine with SQL for reporting services and SharePoint databases and the reporting services and the other machine for a complete SharePoint installation (the main server of the farm)
Now I have done the following:
two servers (lets call them SQL and MOSS)
The domain contains the following users:
sqlservices: for running all the SQL services and reporting services
moss: for administering MOSS databases
moss-services: for running all the MOSS services
Machine SQL - installed Windows Server 2003 Standard Edition SP1, joined to the domain as SQL
The following is done from a local Administrator account:
IIS 6 with ASP.NET installed
SQL Server 2005 with SP2, Reporting services installed but not configured
all the services are running as domainsqlservices
.NET 3.0 installed
http://support.microsoft.com/kb/918642 fix installed
done WINDOWSMicrosoft.NETFrameworkv2.0.50727aspnet_regiis i
MOSS as Web Front installed, not configured
Machine MOSS - installed Windows Server 2003 Standard Edition SP1, joined to the domain as MOSS
The following is done from a local Administrator account:
IIS 6 with ASP.NET installed
.NET 3.0 installed
http://support.microsoft.com/kb/918642 fix installed
done WINDOWSMicrosoft.NETFrameworkv2.0.50727aspnet_regiis i
Computers->My computer->DCOM Config->IIS WAMREG admin Service->PropertiesSecurity->Customize->Edit, added domainmoss-services and domainMOSS users with rights Local launch, Local activate
MOSS Complete installed, configured for: New server farm
Database server: SQL
Username: domainMOSS
Port: Default
Auth: NTLM
SharePointRS.msi installed to enable RS in SharePoint Admin page
Then temporarily gave to the user domainMOSS sysadmin rights in the SQL server on the SQL machine to avoid errors with creating databases while configuring SharePoint from the Admin Portal.
From the Admin Portal configured
Office SharePoint Server Search with domainmoss-services account
Shared Services Administration New SSP created with 2 separate web apps for SSP and MySites, both app pools run as domainmoss-services and SSP itself runs as domainmoss-services
Windows SharePoint Services Search configured, Service Account - domainmoss-services, Content Access Account - domainmoss-services
Everything went OK.
Now came back to the machine SQL:
run Reporting Services Configuration and:
Report Server Virtual Directory created new, called it ReportServer. When hit Apply, the applicatin suddenly quit, but I checked the Virtual Directory was registered on the IIS and working.
Checked if Windows service identity is domainsqlservices, OK.
Web service identity: Application Pool: New
Name: ReportServer
Windows Account: domainsqlservices
Apply, everything went fine.
Database setup: choose server SQL, Connect
Database name: New name: ReportServer,
checked Create the report server database in SharePoint Integrated Mode
OK
Credeantials Type - Service credentials (I guess it means previously set domainsqlservices will be used)
Apply,OK, everything went fine.
Launch SharePoint Products and Technologies Configuration Wizard, Connect to an existing farm, Database server: SQL, Retrieve datbase names: selected SharePoint_Config, Username: domainMOSS, Next, everything fine here.
Now as far as I understand I need to give reporting services an access to SharePoint databases? Went to the machine MOSS, launched SharePoint 3.0 Central Administration:
Application Management-> Reporting Services-> Manage integration settings, URL: http://SQL/reportserver, Windows Authentification, OK
then back, Grant database access-> Server Name: SQL, OK, now it is asking for credentials. And now the problem: no matter what I enter (domainsqlservices, domainMOSS) I get a message: A connection to the computer cannot be established?. Why, why, why?
I can ping the server, SharePoint services are running fine and they are using the SQL server on the SQL machine and there are no errors in the event viewer (they should be if there were any problems to connect the SQL databases).
If I enter wrong credentials, I receive "Unable to log on with the given username and password.", so I guess there IS a connection to the computer (or how else could SharePoint determne that login is wrong?).
Also, if I open http://SQL/reportserver, I get The report server has encountered a configuration error? and the log in C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesLogFiles says SharePoint content service is null. Report Server may not have joined the SharePoint farm, or Report Server service account may not have been granted access to farm.? I guess it is OK while I have not granted access to the SharePoint databases?
Please, show me, what did I do so wrong that A connection to the computer cannot be established?? How can I grant the access and finalize configuring Reporting Services?
Thanks.
Hi
Having finally managed to get over the hump of getting Sharepoint integrated mode working in a farm install, I am having a problem deploying reports from Visual Studio to Sharepoint.
I have set the deploy properties as follows:
TargetDataSourceFolder: http://ppdwn-bl10:8888/ReportTest/Data Sources
TargetReportFolder: http://ppdwn-bl10:8888/ReportTest/Harvest Reports
TargetServerURL: http://ppdwn-bl10:8888/
Visual Studio is updated to Service Pack 2, as is of course the report server.
The reports APPEAR to deploy - they actually appear in the document library after deployment! But the result is:
------ Build started: Project: Harvest Reports, Configuration: Debug ------
Build complete -- 0 errors, 0 warnings
------ Deploy started: Project: Harvest Reports, Configuration: Debug ------
Deploying to http://ppdwn-bl10:8888/
Deploying data source 'http://ppdwn-bl10:8888/ReportTest/Data Sources/ReportWarehouse.rsds'.
Report Server has encountered a SharePoint error.
Deploying report 'http://ppdwn-bl10:8888/ReportTest/Harvest Reports/ColourBreakdown.rdl'.
Report Server has encountered a SharePoint error.
Deploying report 'http://ppdwn-bl10:8888/ReportTest/Harvest Reports/ColourBreakdownSaleable.rdl'.
Report Server has encountered a SharePoint error.
Deploying report 'http://ppdwn-bl10:8888/ReportTest/Harvest Reports/FaceBreakdown.rdl'.
Report Server has encountered a SharePoint error.
Deploying report 'http://ppdwn-bl10:8888/ReportTest/Harvest Reports/LustreBreakdown.rdl'.
Report Server has encountered a SharePoint error.
Deploying resource 'http://ppdwn-bl10:8888/ReportTest/Harvest Reports/paspaley.gif'.
Report Server has encountered a SharePoint error.
Deploying report 'http://ppdwn-bl10:8888/ReportTest/Harvest Reports/ShapeBreakdownByPercentage.rdl'.
Report Server has encountered a SharePoint error.
Deploying report 'http://ppdwn-bl10:8888/ReportTest/Harvest Reports/ShapeBreakdownByPM.rdl'.
Report Server has encountered a SharePoint error.
Deploying report 'http://ppdwn-bl10:8888/ReportTest/Harvest Reports/Summary.rdl'.
Report Server has encountered a SharePoint error.
Deploy complete -- 9 errors, 0 warnings
========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========
========== Deploy: 0 succeeded, 1 failed, 0 skipped ==========
Unfortunately I cannot view the reports in Sharepoint - I can see them in the document library but when I click them I get the same error, except in the web browser. "Report Server has encountered a SharePoint error".
The Report Server log shows the following:
w3wp!library!1!03/06/2007-09:38:24:: Call to GetPermissionsAction(http://ppdwn-bl10:8888/ReportTest/Harvest Reports/ColourBreakdown.rdl).
w3wp!library!1!03/06/2007-09:38:24:: Call to ListParentsAction(http://ppdwn-bl10:8888/ReportTest/Harvest Reports/ColourBreakdown.rdl).
w3wp!security!a!03/06/2007-09:38:24:: i INFO: Exception while running with elevated privileges
w3wp!security!a!03/06/2007-09:38:24:: i INFO: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
w3wp!library!a!03/06/2007-09:38:24:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: Report Server has encountered a SharePoint error., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: Report Server has encountered a SharePoint error.
w3wp!security!a!03/06/2007-09:38:25:: i INFO: Exception while running with elevated privileges
w3wp!security!a!03/06/2007-09:38:25:: i INFO: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
w3wp!library!a!03/06/2007-09:38:25:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: Report Server has encountered a SharePoint error., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: Report Server has encountered a SharePoint error.
Any help would be appreciated.
Thanks
Adam
I encounter this error when user try to subscribe using email delivery
to one of the report. I have configured the Reporting Services to use
Sharepoint integrated mode. This user is a regular user that has read
access to the report item.
Below is the message detail:
A subscription delivery error has occurred. (rsDeliveryError)
A subscription delivery error has occurred. (rsDeliveryError)
One of the extension parameters is not valid for the following reason:
The account you are using does not have administrator privileges. A
subscription cannot be created for [emailaddress].
(rsInvalidExtensionParameter)
Is it true that user needs to have administrator privilege in order to
subscribe for report? I don't think so, right?
Regards,
Gunady Ng
Well, I have SQL Server 2005 SP2 Reporting Services installed and configured in sharepoint integrated mode, so I am deploying reports in sharepoint libraries. Also I configured sharepoint to use forms authentication with builtin AspNetSqlMembership provider, but after this action I couldnot open reports through sharepoint library, instead of this, error was displayed mentioned below. I searched and found hotfix Cumulative Update 3 build 3186 for this issue, request it from microsoft support and applied it, but nothing has changed!
Error I have been experiencing is following:
An unexpected error occurred while connecting to the report server.
Verify that the report server is available and configured for
SharePoint integrated mode. --> The request failed with the error
message:
--
<html><head><title>Object moved</title></head><body>
<h2>Object moved to <a href="/_layouts/login.aspx?ReturnUrl=
%2f_vti_bin
%2fReportServer%2fReportService2006.asmx">here</a>.</h2>
</body></html>
I continued to dig and find out that this hotfix should update Microsoft.ReportingServices.SharePoint.UI.WebParts.dll from version 9.0.3042.0 to new version 9.0.3180.0, but when I checked file version after applying hotfix, it remained the same as was before i.e. 9.0.3042.0. Apparently this cumulative update does not fix this issue.
anyone has any idea how to solve it? Thanks in advance.
sorry for my poor english :-)
We are researching a SSRS and SharePoint integrated mode install and I have a question about report development. When SSRS is installed as integrated mode, there is no report sever to publish to and the reports are published to document libraries. What do you do when developing reports in Visual Studio? How do I publish the new reports?
I saw a white paper what seemed to suggest that you have to do report development in a native reporting services environment and re-publish to SharePoint. Is that true?
Here's a link to a blog that has the information:
http://blogs.msdn.com/sharepoint/archive/2007/02/19/microsoft-sql-server-2005-sp2-reporting-services-integration-with-wss-3-0-and-moss-2007.aspx
Thanks for the Help!
-Scott
we are about to start a logshipping with the secondary server in read only mode.
I just wanted to know the disadvantages of using a read only on the secondary server.
I mean whether the transactional logs will be restored periodically or it won't be restored till users are connected on the secondary server.
My database went into suspected mode. and after we had run some script, it came out from the suspected mode. but we encountered this error while opening table in database.
2009-11-02 15:46:42.90 spid51 Error: 824, Severity: 24, State: 2.
2009-11-02 15:46:42.90 spid51 SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:43686; actual 0:0). It occurred during a read of page (1:43686) in database ID 23 at offset 0x0000001554c000 in file 'H:MSSQL.SQL2008MSSQLDATAmy_db.mdf'.
Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
Hi,
Currently, our Report Builder is running on Local Intranet mode. I'm investigating what the security implications are in changing it to Internet mode. However, I've not been able to find any documentation on this.
Does anyone know of any documentation that addresses this issue or have experience that they can share with changing Report Builder security zone from Intranet mode to Internet mode?
Thanks very much.
I am setting up sharepoint and sql server integration environment. I am considering the following topology: PowerPivot for SharePoint 2013 and Reporting Services in SharePoint mode Two Server Deployment
[URL]
I am looking to follow the topology example by the letter, which involves installing PowerPivot for SharePoint (aka SSAS in SharePoint mode) in the same server as my SQL, and installing SSRS in SharePoint (SP) integrated mode in the same server as SharePoint.
I understand, however, that if I wanted to install SSRS in SP mode in the same server as SQL, I could but only if the server contains the SP Object Model.
My first question is, what would involve having the SP Object Model in the SQL Server?
Would only installing SP binaries be enough; or Do I need to do a minimal install of SP in the SQL server enough for it to joing the SP farm? And most importantly, what would be the licensing implications for SP in case I want proceed down this route and have SSRS in SharePoint mode installed in the same server as the SQL?
We have a reporting database which is refreshed daily from prod backup and later creating new tables/views/indexes as part of the refresh job. Is there a better approach we can implement in sql 2012/2014 for this scenario since we are planning to migrate to sql2014.
View 5 Replies View RelatedI Want to test for Automatic switch between primary and secondary.
How do i do it ?
or
I need this for some purpose : How to set suspect mode for a database ?
Hello,
does anyone know, when will the functionality of linked reports, my reports, data-driven subscriptions in MOSS integrated mode be enabled? Now it is according to Microsoft not supported. Will this be supported in the future ?Thanks.
Hello,
I have configured Reporting services to use MOSS integrated mode. I have two servers, one for MOSS and the other for SQL database and reporting server.
Since I am using NTLM for IIS authentication, I can only use "Trusted Account" for Reporting Service Integration.
Then I created a report in SQL Server BI development studio and deployed to a MOSS document library. The deployment was successful. However, when I tried to open the report, I got the following error message:
An error has occurred during report processing.
This data source is configured to use Windows integrated security. Windows integrated security is either disabled for this report server or your report server is using Trusted Account mode.
I have tried to switch to "Windows Authentication" for Reporting Service Integration, but this will give error for "Set Server Defaults" screen. Also the deployment from BI studio to MOSS will fail with authentication error. So I think I have to stay with "Trusted Account" option there.
What should I do to make the report accessible while using "Trusted Account"? Is there any configuration which has to be done for this purpose? Any input is appreciated.
Thanks,
Jun
I have a database that I am trying to recover space from, it consists mostly of unallocated space, but I can’t seem to get that unused space released.
Database size: 40,245.13 MB
DatafileMB: 38,063.63, DataAvailableMB: 37,085.15
LogfileMB: 2181.51
Sysfiles shows:
fileidgroupidsizemaxsizegrowthstatusperfname
114872144-112820SomeDB
202792332684354561010486420SomeDB_log
The DB is in simple recovery mode. There are no open transactions (used dbcc opentran).
The server is running SQL Server 2014 and the DB is in compatibility mode SQL Server 2008 (100). It was upgraded to 2014 a month or two ago.
I have tried to re-size the log to 100mb, but any way I have tried (none gave errors), the log file remains the same size. I have tied to shrink the log file (through the UI and via DBCC commands) without success; no errors, but also no change in file size.
I have checked Log Reuse Waits, just in case, and as expected it showed “NOTHING” (select log_reuse_wait_desc, name from sys.databases)
I tried running a checkpoint, but that did not allow any resize or shrink to work.
I have tied creating large transactions to move the used point in the log file, in case this was the issue. I did this by creating tables that I drop after large inserts. While it shows me that the log space % used increased, the log file still does not allow the space to be reduced.
The following is what I was using for the transactions to get the log used.
BEGIN TRAN
select a.* into testtable from sysobjects a, sysobjects b, sysobjects c
ROLLBACK TRAN
Each insert creates 93,576,664 rows.
Running dbcc SQLPerf(logspace) :
DBLogSize(MB)LogSpaceUsed(%)Status
SomeDB2181.534.204890
Running dbcc loginfo:
RecoveryUnitIdFileIdFileSizeStartOffsetFSeqNoStatusParityCreateLSN
0211437342728192602640
02114373427211437424645701280
Do I just need to continue running large transactions until the log space used gets high enough to get the “end point” in the log to really move? Is there an easier way to accomplish this (I have several DBs that have the almost identical problem), what I am using moves the Log Space Percent Used about a percent on each execution.
I can't find any literature on the native mode SSRS databases.
so something similar to the MSDB sys tables [URL] Is documentation non existent?