Brian's questions

We're running into a problem with certain files and folders on our Windows 2003 R2 file share. The problem only affects OS X 10.6 clients.

Certain files and folders on the share seem to lose their filetype association. For 10.6 clients, the file or folder becomes greyed out. Older OS X clients (ours here are running 10.4, I don't have a 10.5 machine to test with) and windows machines have no problem.

In addition to becoming greyed out, if it's a folder, the icon displayed in the list view is the generic document icon. (You know, the blank piece of paper with the top-right corner folded down) Quick look and Get info both still indicate the "kind" is folder, but double-clicking the folder does nothing. The folder behaves completely normally in the terminal, only finder has the issue. Renaming, moving, or copying the folder to a local drive does not resolve the issue.

We're no longer using Office Project Server, and I've removed it from the farm in which it was installed. However, now that it's been removed, I am unable to access the "Manage Content and Structure" link on some of our SharePoint sites. I get an error indicating that SharePoint

Failed to find the XML file at location '12\Template\Features\PWSCommitments\feature.xml'

Anyone have an idea how to fix this?

I'm setting up SQL Reporting services with SharePoint integration. I've created my new reporting database, installed the SharePoint Web Front End Role on the reporting server, installed the reporting add in on all my WFEs and run through the configuration in central admin.

I'm running MOSS 2007 SP2 and SRS 2005 SP2

I've got all green checks across my reproting services configuration, but if I try to browse to the Report Server virtual directory, I get the following error.

Reporting Services Error

Report Server has encountered a SharePoint error. (rsSharePointError) Get Online Help Access to this Web site has been blocked. Please contact the administrator to resolve this problem. Access to this Web site has been blocked. Please contact the administrator to resolve this problem.

SQL Server Reporting Services

If I take a look at the logs, I get some more detail.

w3wp!library!1!2/11/2010-18:18:23:: 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. ---> Microsoft.SharePoint.SPException: Access to this Web site has been blocked.

Please contact the administrator to resolve this problem. ---> System.Runtime.InteropServices.COMException (0x81020071): Access to this Web site has been blocked.

Please contact the administrator to resolve this problem. at Microsoft.SharePoint.Library.SPRequestInternalClass.GetSiteFlags(String bstrUrl) at Microsoft.SharePoint.Library.SPRequest.GetSiteFlags(String bstrUrl) --- End of inner exception stack trace --- at Microsoft.SharePoint.Library.SPRequest.GetSiteFlags(String bstrUrl) at Microsoft.SharePoint.SPSite.get_ReadLocked() at Microsoft.ReportingServices.SharePoint.Server.SharePointImpersonatedWeb.<>c__DisplayClass1.b__0() --- End of inner exception stack trace --- w3wp!security!1!2/11/2010-18:18:23:: i INFO: Exception while running with elevated privileges w3wp!security!1!2/11/2010-18:18:23:: i INFO: Report Server has encountered a SharePoint error. w3wp!webserver!1!2/11/2010-18:18:23:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: Report Server has encountered a SharePoint error. ---> Microsoft.SharePoint.SPException: Access to this Web site has been blocked.

Please contact the administrator to resolve this problem. ---> System.Runtime.InteropServices.COMException (0x81020071): Access to this Web site has been blocked.

Please contact the administrator to resolve this problem. at Microsoft.SharePoint.Library.SPRequestInternalClass.GetSiteFlags(String bstrUrl) at Microsoft.SharePoint.Library.SPRequest.GetSiteFlags(String bstrUrl) --- End of inner exception stack trace --- at Microsoft.SharePoint.Library.SPRequest.GetSiteFlags(String bstrUrl) at Microsoft.SharePoint.SPSite.get_ReadLocked() at Microsoft.ReportingServices.SharePoint.Server.SharePointImpersonatedWeb.<>c__DisplayClass1.b__0() --- End of inner exception stack trace --- at Microsoft.ReportingServices.SharePoint.Server.SharePointImpersonatedWeb.<>c__DisplayClass1.b__0() at Microsoft.ReportingServices.SharePoint.Server.Utility.<>c__DisplayClass5.b__3() at Microsoft.SharePoint.SPSecurity.CodeToRunElevatedWrapper(Object state) at Microsoft.SharePoint.SPSecurity.<>c__DisplayClass4.b__2() at Microsoft.SharePoint.Utilities.SecurityContext.RunAsProcess(CodeToRunElevated secureCode) at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(WaitCallback secureCode, Object param) at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(CodeToRunElevated secureCode) at Microsoft.ReportingServices.SharePoint.Server.Utility.RunElevated(CodeToRunElevated code) at Microsoft.ReportingServices.SharePoint.Server.SharePointImpersonatedWeb.ImpersonateSharePointSiteByUserName(String wssUrl, String userName) at Microsoft.ReportingServices.SharePoint.Server.SharePointImpersonatedWeb.GetSharePointImpersonatedWeb(String wssUrl, UserContext userContext) at Microsoft.ReportingServices.SharePoint.Server.SharePointDBInterface.internalFindObjectsNonRecursive(String wssUrl, CatalogItemList& children)
at Microsoft.ReportingServices.SharePoint.Server.SharePointDBInterface.FindObjectsNonRecursive(String wssUrl, CatalogItemList& childList, Security secMgr, IPathTranslator pathTranslator, Boolean appendMyReports) at Microsoft.ReportingServices.Library.ListChildrenAction.PerformActionNow() at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute() at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderFolder() at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent() at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()

I'm trying to retrieve content from the _catalogs directory of a SharePoint site using a script. I've no idea where to start. My first thought was to use wget, but I soon discovered that the the _catalogs folder isn't available over http. As far as I can tell, it's only available in SharePoint Designer. Is there a way to retrieve this content via a script?

I'm looking for advice from anyone out there who has experience integrating SharePoint with a business intelligence application like Cognos.

Our BI team wants to be able to report on data stored in SharePoint. Their tool of choice is Cognos. What's the best way to get the data they're looking for OUT of SharePoint and into Cognos BI for analysis?

To clarify I'm NOT looking for a way to display Cognos reports in SharePoint. We want to take the list data from SharePoint and use Cognos to report on it.

I'm having trouble with a site collection in a MOSS2007 farm. I'm trying to enable the Publishing feature at the site collection level. When I try to activate the Feature from Site Settings -> site Collection features, I get one of those incredibly helpful SharePoint error messages.

Error. Cannot complete this action. Please try again. 

So I thought I'd try with stsadm, and I ran this

stsadm -o activatefeature -name Publishing -url http://server/site

I got the more helpful error message

Provisioning did not succeed. Details: Failed to create the 'Pages' library.
OriginalException: The feature failed to activate because a list at 'Pages' already
exists in this site.  Delete or rename the list and try activating the feature
again.

Now that's more like it! I checked, and sure enough there was a Pages library. I deleted it. I ran stsadm again fully expecting it to work this time. No dice. I'm getting the same error, but now there's no 'Pages' document library. I emptied the recycle bin. Same error. I'm stumped.

Per the two suggestions below, I made sure that the site collection recylcle bin was also emptied and that there were no 'Images' or 'Documents' libraries hanging around. I still can't activate the feature.

I've used the stasadm -o backup/restore commands to migrate a site collection to a new URL.

The new site seems to be working fine, with one exception. Document libraries that contain folders don't work properly.

I'm able to access the library, but clicking on a folder within the library just sends me to a generic error page with the unhelpful message "Cannot complete this action." I can't create new folders within the library either.

Anyone else run into this behavior?

Is there a way to distribute a client-only rule to Outlook 2003 and 2007 clients?

We'd like a way for to have emails from corporate communications generate a desktop alert or perhaps be flagged for followup automatically. It would need to be deployable centrally using Active Directory or Exchange.

My first thought was group policy, but apparently Outlook rules aren't part of what you can control using group policy.

Has anyone implemented something similar?

Possible Duplicate:
Can you help me with my software licensing question?

I can't seem to find a clear answer to this question.

What type of licenses do I need to buy ensure that everyone in my organization is licensed to use Active Directory. We want to use AD to authenticate users in our timekeeping system. Am I going to need server CALS? Is there a special AD license?

We have about 5000 users who'd need to authenticate to this system.

Is there a way to import information into a survey from an external datasource? I have a user who has a spreadsheet full of measures (Over 300 of them) who would like to create a few surveys in SharePoint so that he could ask our users to rate some software based on these measures.

Manual data entry of all 300+ measures directly into a survey would take a LOT of time. Is there an easy way to get these measures into a survey?

Thanks to Adam for his answer below. As an admin, some pointers as to how to use these objects from Power Shell or Iron Python would help as well.

I'm running into a problem with the Redmine Bitnami stack intaller on Windows Server 2003. Setting up my project, I'm trying to add a remote subversion repo to the project, but it's erroring out. A little googling led me to some discussions on the Redmine site that leads me to believe the issue is caused by the fact that the repo I'm accessing is SSL enabled and the cert needs to be accepted before I can connect.

All the solutions are geared toward Unix/Linux though (i.e. simply su to the redmine user, run svn command line tool and accept the cert.) but I can't do that because I'm running Windows.

How can I store the SVN cert for the SYSTEM user on Windows?