.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

Sharepoint stsadm Restore from Back Up breaks all the deplyed reports link to datasource.

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :C#

Hello Everyone,

Hoping to get some solution to the issue we are having.

We have SSRS reports deployed in Sharepoint 2007. I am trying to restore from a back up of a site collection into another blank site collection. Site backup and restore all works fine and completes successfully using STSADM utility. But after restore the deplyed reports looses the link to datasource.

Can somebody please guide on it?



Pulkit Ojha


View Complete Post

More Related Resource Links

Sharepoint - Webpart doesnt deploy - stsadm reports deployment 'successful'


MOSS 2007 :)

I am having problems deploying a webpart..
This webpart was successfully installed and deployed on a similar environment with no problems. However when trying to deploy it in its intended site it's having some strange problems..

1. I installed the webpart to the server (through stsadm) - return message "Operation completed successfully."
2. I deployed the webpart to the intended site - return message "Operation completed successfully."
3. I performed an IIS reset and navigated to the 'site features' area to find no trace of the webpart to activate.

I ran the 'stsadm -o enumsolutions' command to view the solutions that are deployed, and I see my webpart here:
  <Solution Name="solutionname.wsp">

Can I back up a site from SharePoint 2010 server and restore it on a SharePoint 2010 Foundation serv



I had a simple site in a SharePoint 2010 server, and I backed it up. That server is not available anymore, and all I have available is a SharePoint 2010 Foundation server. Can I restore on that server? I got an error message saying that the versions of "SharePoint Foundation" on the two servers are different. Note that only one of the servers (the destination server) was running SharePoint Foundation, the other one had full SharePoint 2010.

I don't think I am using any features that are not part of SharePoint Foundation... it's an extremely simple site. Just a list with custom list forms edited in SharePoint Designer.



Viewing Reports with SharePoint 2.0 Web Parts

Reporting Services provides several Web Parts that work with specific versions of a report server and in particular deployment modes. If you want to access report server content on a SharePoint site from a native mode report server, use the SharePoint 2.0 Web Parts that are included with Reporting Services. Instructions for installing and using the 2.0 Web Parts are provided in this topic.

Reporting Services: Deliver SQL Server Reports To SharePoint To Enhance Team Collaboration


The solution covered here includes a custom SharePoint Web service that accepts SQL Server-generated report files and, through the WSS object model, stores the file in the appropriate library for enhanced collaboration possibilities.

Ed Hild

MSDN Magazine March 2006

SSRS - Where are the Sharepoint Report Usage Reports provided by Microsoft



Microsoft provided 3 example reports for Sharepoint report usage. Does anyone know where they are located? I used them about 2 years ago.




Attachements problems - also - How to add Office Communicator link to sharepoint Form ?



I have created an Infopath 2007 form and published it to Sharepoint 2007.

1. I can add "attachements" to the form, but the function can handle only one attachement per link. If i need to add 10 attachements, i have to create 10 attachement functions to the form.

Is it possible to create one attachement function in the Infopath form, that is able to save several attachements under it?

2. Is it possible to save .exe, .msi and similar files to the form as attachements? Sharepoint says security settings prohibit this.

3. How can i add a link that shows up as MS Office Communicator link in the form? For example: John Smith in Office communicator is now Online. I want his name and his status to show also in the Infopath form, when somebody opens it in Sharepoint.

Please help!


SharePoint Version 2.0 (WSS 2.0 SP3) Content Database restore to new farm

Is it possible to use an SQL backup from a sharepoint Version 2 SP3 database to restore the content on a new server farm and attach to a new web applicaiton. NOTE: This is WSS 2.0. In WSS 3.0 this is a very simple task, but it is not the same in WSS 2.0 (the add content database option CANNOT be used to attach to an existing content database like it does in WSS 3.0). The options I have found appear to say you need the configuration database from the old server then it can be done. I am migrating from an outsourced deployment, so I do not have access to that. Plan B is to do a sharepoint STSADM backup. THis seems to be a more likey way to do it.

Web Form breaks after using the browser's back button

I have a web form that allows a user to put some data in a textbox and click a button to do a search on that data.  It opens up a Sql Server Reporting Services report using the data they entered on the previous page.  If they use the browser's back button to go back and enter some different criteria to search on, the buttons don't work anymore. Any ideas or suggestions on what would cause this?   Thanks! 

Can't save SQL Server Management Studio sql file back into Sharepoint Document Library

I created an sql query file in SQL Server Management Studio and saved it onto my hard drive.  I then moved that file into a Sharepoint Document Library so others on my team could use that query.I opened the file from within sharepoint, it launched SSMS.I made a change to the file and pressed save.here is the error message that comes up."The operation could not be completed.  The process cannot access the file because it is being used by another process"Am I doing something wrong?

How to get rid of the (More Links.) link on lists in SharePoint 2010?

I have a list of 5 items. The view settings are set so that the Item Limit is 20. I would like the eliminate the (More Links...) link under the list when the web part is on the page. I also tried setting the Toolbar properties to No Toolbar. Any ideas? Thanks.

Custom Web Part Problem After SharePoint Restore

Hi, I've recently moved our sharepoint site and databases (using Microsoft Internal Database) to another standalone server. I did a catastrophic backup and then restored it on the destination server successfully via the central Administration page. I have also copied our custom web part library dll to 'c:\windows\assembly' directory and 'C:\Inetpub\wwwroot\wss\VirtualDirectories\80\bin' directory. I also copied over the old web.config file to 'C:\Inetpub\wwwroot\wss\VirtualDirectories\80'. However, I still seem to be missing something as I get the error below while loading the site. I haven't been able to find a solution so hoping someone has seen it before here. Has anyone seen this happen before? Any advice/help would be greatly appreciated. Many thanks. Mehds ERROR====================================================================================================== The “webpartname” web part appears to be causing a problem. Object reference not set to an instance of an object.  Web parts maintenance page: if you have permission, you can use this page to temporarily close web parts or remove personal settings. For more information, contact you site administrator. ==========================================================================================================

Building Reports in SharePoint Integration Mode

 I configured and connected SSRS to my SharePoint farm, but how do I go about creating reports?  The usual <my server>/reports url is disabled in SharePoint integrated mode.  Can someone point me in the right direction? Thanks, Eric

Integrate Crystal reports with sharepoint?

Hello!Has anyone worked on crystalreports in sharepoint?I am a begginer and i need a good reporting methodcan anyone help me?thanksmona

How to link SharePoint List with MS Access 2007 programmatically

Hi, can anybody tell me how to link SharePoint List with MS Access 2007 without opening Access environment. I want to do it programmatically through C#/VB.net doesn't matter. Your help will very much appreciated. Thank you so much! -Jarexs

Search crawler 'breaks' Document ID link

Hi all - we have a Sharepoint 2010 development server up and running (very much Out of the Box configuration). The Document ID functionality has been enabled and appears to be working OK - each document has its own unique ID as predicted. In a team site (Corporate Comms), we have a document library where our corporate logo has been loaded (a small .bmp file). This image file has a unique Document ID. On the top level site, I have created a link to the corporate logo so that it appears on the 'entry' web page. The link to the image is : http://<servername>/_layouts/DocIdRedir.aspx?ID=CH07-7-1  where CH07-7-1 is the Document ID When first created, everything works OK and the image appears on the front page. However, once a search crawl has been run (either full or incremental), the image disappears and is replaced by a red cross (i.e. the URL link has been broken). I have tried this with a word document link (as opposed to a .bmp image) and this still works OK. I have also tried storing the image in a picture library (as opposed to a document library) and the same thing happens. Is there something funny happening specific to the .bmp image/Document ID/crawler ? Anything I need to configure ? Any help would be appreciated. Thanks, Richard.    

SharePoint 2010 Refinement Panel - Show more link issue

Hi,  I have deployed a Refinement Panel on my search result page. And I have modified the Filter Category Definition to get some Managed Metadata columns. Below are the xml changes: <?xml version="1.0" encoding="utf-8" ?> <FilterCategories>   <Category    Title="Category"    Description="Managed metadata of the documents"    Type="Microsoft.Office.Server.Search.WebControls.TaxonomyFilterGenerator"    MetadataThreshold="3"    NumberOfFiltersToDisplay="3"    MaxNumberOfFilters="20"    ShowMoreLink="True"    MappedProperty="ows_MetadataFacetInfo"    MoreLinkText="show more"    LessLinkText="show fewer" />   <Category    Title="Modified Date"    Description="When the item was last updated"    Type="Microsoft.Office.Server.Search.WebControls.ManagedPropertyFilterGenerator"    MetadataThreshold="5"    NumberOfFiltersToDisplay="6"    MaxNumberOfFilters="0"    SortBy="Custom"    ShowMoreLink="

SharePoint 2010 AD FS 2.0 Integration - login works then fails, looping back to the adfs server

Hello, I setup SharePoint 2010 Claims auth with AD FS 2.0 following this post: http://blogs.technet.com/b/speschka/archive/2010/07/30/configuring-sharepoint-2010-and-adfs-v2-end-to-end.aspx.  I have no access to the ADFS server, but I think they followed the steps as outlined.  If I do an iisreset (or just recycle the app pool of the SharePoint site) I can login successfully using the remote credentials.  Also I can under security in SharePoint search for and find users and roles from the remote ADFS server. If I close my browser, open a new browser and go to the site I am prompted to login again (this is fine).  I do, using the same credentials, and the login fails because I am redirected between the SP and ADFS servers until the ADFS server stops the redirecting.  I have been doing some digging and I found this post: http://blogs.technet.com/b/speschka/archive/2010/08/09/setting-the-login-token-expiration-correctly-for-sharepoint-2010-saml-claims-users.aspx, which describes the situation I have in point # 3 at the bottom.  I have tried setting the token time out as low as 1 second but this hasn't helped. I have also, just to see, tried setting all the other lifetime settings to 1 second - but no luck.  Because the initial login works I think the setup is correct, but something is maintaining some state that is causing the loop
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