.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 security groups, ACL of site collection or subsite need to move in to sql server 2008 usi

Posted By:      Posted Date: October 23, 2010    Points: 0   Category :SharePoint

HI Team,

I am new to sharepoint here is my query. i am working on MOSS 2007, SQL server 2008

I want to move the sharepoint security groups, ACL(access control list), user groups all the security and permission related data to sql server 2008 from a particular site collection or subsite. After getting the data in to sql server we should be able to update the users from sql server itself which should reflect in sharepoint sites.

View Complete Post

More Related Resource Links

Office Sharepoint Server Publishing Infrastructure is missing in site collection feature SharePoint

I was trying to activate the Office Sharepoint Server Publishing Infrastructure feature in the site collection features but the feature is simply not there. Is this option not available in SharePoint Foundation 2010?

Moving a larger Sharepoint 2007 site collection over to a new server



We have a Sharepoint 2007 site collection roughly 36 GB in size and have been having problems moving the site to a new server farm (Also 2007). We are trying the Sharepoint backup and restore method, but I understand that this method is not recommended for sites over 5GB. Has anyone moved a site of this size and how did you do it?

Thanks  Ron


Programmatically activate SharePoint Server Enterprise Site Collection features


As my solution requires the enterprise features I'm required to activate them. Right now I'm doing it manually through "site settings -> site collection features", but I want to do it automatically when activating an other part of my solution. I've used PowerShell to see the difference for "Get-SPFeature -site myurl" before and after activating the enterprise feature by hand, but there're at least 10 site collection features being activated through this one click step.

Is there a list of features which are part of the SharePoint Server Enterprise Site Collection features or is there an easier way to activate them all at a time instead of doing it one by one programmatically.

Missing "SharePoint Server Enterprise Site Collection Features" in Site COllection Feature



All collection sites seem to be missing on the "SharePoint Server Enterprise Site Collection Features" in Site COllection Feature. However, I have PowerPivot uninstalled and reinstalled. Not sure if this could be the reason for it.


Sharepoint Groups Across Site Collection



 Is there any work around to inherit the permission groups created in "Root Site collection" to the other site collection in MOSS 2007?Any limelight on this would be of great help.


Karthik S

Domain groups in Cluster Security policy during install of SQL Server 2008

I am trying to install SQL Server 2008 on Windows server 2003 and have a question about the stage of 'Cluster Security Policy'.

We need to select 2 groups here, one for SQL server database domain group and the other for SQL server agent domain admin group.

My question is, is it different from service accounts that we used to specify in previous versions? I remember the wizard asking for service account that the sql services need to run under. Is this domain group part a replacement for those individual service accounts? If yes, do I need to have the service account added to a separate group and select that group in this part of 'Cluster security policy'?


SharePoint Server Publishing feature--Can't activate on site (activated fine at site collection lev

I have five site collections and one of them seems to have an issue with the SharePoint server publishing feature, which is activated at the site collection level. On any of the sites underneath that site collection, the Server Publishing feature is not activated and throws this error when I try to activate:


One or more field types are not installed properly. Go to the list settings page to delete these fields.

 Troubleshoot issues with Microsoft SharePoint Foundation.

Correlation ID: f1915aff-39e6-4e99-ba2f-34faf71f3102

If I try to create an Enterprise Wiki, I get the same thing:

One or more field types are not installed properly. Go to the list settings page to delete these fields.

I won't be able to create the wiki until I can get the SharePoint Server Publishing feature activated.

Any one have any ideas? the other 4 site collections are fine.

Administrator and Developer Guide to Code Access Security in SharePoint Server 2007

Explore configuration options, get best practices for managing CAS in SharePoint environments, and walk through a complex CAS scenario.

Displaying the Server Ribbon and Site Actions Menu on Customized Search Pages Upgraded to SharePoint

Learn how to add the Site Actions menu and SharePoint Server ribbon to SharePoint Server 2007 search pages that you upgrade to SharePoint Server 2010 by using visual upgrade.

Video: Site Collection Solution Galleries in SharePoint 2010

This demonstration shows the solution gallery and solution management features of SharePoint 2010. (Length: 4:01)

Cannot add SQL Server 2008 R2 Report items to SharePoint Server 2010 document library

Using account which is the primary parent site administrator, can upload RDS and RDL files to the document library (however, cannot open report). User is also a domain admin with SA on the database instances. Cannot add Report Data Source with "New Document" icon. The permissions granted to user '[domain]\[user]' are insufficient for performing this operation. Under "Site Settings", "Managed Shared Schedules" fails with same error. Attempting to deploy from BIDS results in the same permissions error. Sharepoint Server 2010, Report Server 2008 R2. RS and SP databases hosted on remote server (SQL Server 2008 R2). All connections (SharePoint services, RS services, users) except SQLAgent authenticating to remote SQL Server with Kerberos (all SPNs look correct). Single site, site collection "/". Document directory called "Reports". Windows Integrated Security (Negotiate). How would I troubleshoot/solve problem?

SharePoint Search not working on one site collection

I am running into some weird behavior with how SharePoint is crawling site/list data.  Let's say our main intranet site is http://www.intranet.com: Most of our older sites are setup with URLs like http://www.intranet.com/sites/sitename .  Crawling is working fine on these sites and I can execute a search and find all of the results I would expect.  At some point recently (before I joined this firm), they made a decision that all new sites would have the URL http://www.intranet.com/SiteDirectory/sitename .  Any sites which fall into this bucket are not being crawled, it would seem. If I check Central Adman>Shared Services>Search Administration, I can see that the first content source being crawled is http://www.intranet.com so I would imagine this crawl should pick up anything under /SiteDirectory/ but it is not.  I also checked the Crawl Settings on this page and it is set to "Crawl everything under the hostname for each start address".  Lastly, I see that there were only 21 errors in the last full crawl but none of these errors apply to a /SiteDirectory/ site. In short, what could be causing the crawl to apparently skip all of the sites within /SiteDirectory/ and how can this best be fixed?

Sharepoint 2003 + Windows Terminal Server 2008 + Office 2007 problem?

Hi, We have a customer where some users runs Windows Terminal Server 2008 with Office 2007. They open documents from a Sharepoint 2003 site. When they open an excel sheet they get a button in the document which says "Server workbook: Click edit workbook to edit this workbook" and there is a button: "edit workbook" The users clicks "edit workbook" but get an error message saying there is no connection to the server.  They are able to edit the document, but not save it back to the sharepoint site. Most other users work on their local computer with Office 2003. Here, everything works fine and there are no button/message stating its a server workbook.   Is this caused due to some compatability issues between Sharepoint 2003 and Office 2007?   Best regards, Thomas Hansen ErgoGroup AS

sp2010 - move site template ( or site ) from one site collection to another ?

Is it possible to save a site as a template in site collection A and move it to site collection B ? Can this be done using out of the box functionality through the browser or do I need to use powershell or some other tool ? please advise. thanks and regards, Counie  

Cannot access parent site list from subsite in XSLt List View webpart in sharepoint designer 2010

Hi    We are using sharepoint 2010  for internet facing sites for our big client in healthcare domain .  I am using XSLT list view webpart in sharepoint designer 2010 for retrieving contents from sharepoint list & displaying it by using XSLT List view webpart in publishing sites. We are having lot of list in rootsite collection, If i am creating pages by using XSLt list view webpart in root site collection I can access the list,View and Display in Pages by XSLT List view webpart. Now the requirement is i have to access the list in roosite collection(parent site) from subsites.  In Sharepoint designer 2010, while i am inserting XSLT list view webpart, i could not find datasource to access the list that exist in rootsite collection(Parent site) from subsite. Below is the the code i am using for accessing the list& view from parent site & creating the pages in parent site by using xslt list view webpart,now i wants to access parent site list from subsite by using XSLT list view webpat in subsite pages.  Pls let me know what i have to change in the code level <WebPartPages:XsltListViewWebPart runat="server" Description="The list for the conditions details" ListDisplayName="" PartOrder="2" Default="FALSE" HelpLink="" AllowRemove="True" IsVisible="True" All

Upgrading to SharePoint 2010 Foundation on SBS Server 2008

Hi all, I've just tried to install SharePoint Foundation on 2010 on Windows Small Business Server 2008 and whilst the literature I've found suggests that this is supported, I receive the following error: SharePoint 2010 Products cannot be installed in Stand-alone mode on a Domain Controller.  For more information on upgrading, see http://support.microsoft.com/?kbid=975805. What's funny about the KB ID, is that it doesn't exist.  The pre-requisites for SharePoint 2010 Foundation installed OK and the SharePoint installer has detected that it will perform an in-place upgrade.  the STSADM -o preupgradecheck output is below. Any idea's?  It would be really great if we could start using the shared workspace and ribbon features that are inherent with SPF2010. Jason.  

SP2010 - move libraries from a site in one site collection to a site on a different site collection

can this be done simply through 1) opening sitecollectionA.siteA in windows explorer 2) opening sitecollectionB.siteA in windows explorer 3) copying library in 1) to location in 2) Is this best practice or is there an OOTB option to achieve this ? could SharePoint WorkSpace be used ? thanks and regards, Counie
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