Archive for September, 2009

SharePoint lavorare con i files AutoCAD di grosse dimensioni

September 30, 2009

Joel Oleson’s Blog – SharePoint Land : File Name, Length, Size and Invalid Character Restrictions and Recommendations:
http://blogs.msdn.com/joelo/archive/2007/06/27/file-name-length-size-and-invalid-character-restrictions-and-recommendations.aspx

Segnalo inoltre questo tool di terze parti che migliora l’integrazione tra Microsoft Office Sharepoint Server 2007 e Autocad.

Autodesk AutoCAD and Microsoft SharePoint Integration by CADnection:
http://www.cadnection.com/Internal.aspx?path=Solution_Product_Features

Advertisements

Project Server 7882: Unable to start services process

September 29, 2009

We did a database move of our Project Server database over the weekend. Rather than use the renameserver command, we figured to take the cautious route and set up an alias from the old SQL Server to the new SQL Server – that worked very nicely.

One of the other changes made was to start up the Search Service – previously we had the Office and SharePoint search services disabled, as they were causing errors with the old SQL Server – long story about that! In doing so, I had to update the SSP config page to start up the services.

Looking in the event log, there were a ton of errors complaining “unable to start service process. SSP: Service: ProjectQueueService”, then the same error with the pjevtsvc instead. There was also a .Net Runtime 2.0 Error, EventType clr20R3, microsoft.office.project.server. system.nullreferenceexception.

I stopped & started both the Timer and Queue services, but that didn’t help. Tried restarting both a few times. Tried an IISReset. Still didn’t help.

My service account was set up to Log On As Service in the Local Security Settings User Rights Assignments, Log On as a service, so that wasn’t it either.

What did the trick was to change the account used for both services in the Services control panel. The services were set to use the Farm account – I switched this back to using the SSP account instead, restarted the services, and we’re up & running with nice quiet logs.

Microsoft Office Project Server Queue Service add a start dependency in the system Registry

September 28, 2009

To add a start dependency in the system Registry, complete the following steps:

1.   To add the key to the Registry, click Start –> Run and type “Regedit” in the Open field. When the system opens the Registry Editor, navigate to the following folder:

HKEY_LOCAL_MACHINE –> SYSTEM –> CurrentControlSet –> Services –> ProjectQueueService

2.   Select the ProjectQueueService, and then click Edit –> New –> Multi-String Value. Name your new string value “DependOnService”

3.   Double click on your new DependonService string value in the right pane of the Registry window and the system displays the Edit Multi-String dialog. Add the value “MSSQLSERVER” to Value data field and click the OK button to complete your entry.

Agent Communications Panel for Microsoft Dynamics CRM 4.0

September 18, 2009

The Agent Communications Panel for Microsoft Dynamics CRM 4.0 is an application add-in to Microsoft Dynamics CRM 4.0. It works with Microsoft Dynamics CRM and Microsoft Office Communications Server 2007 R2, and enables agents to manage their communications (make calls, receive calls, conference, and chat) from their Microsoft Dynamics CRM system.

The Agent Communications Panel is an XAML browser application (XBAP). It is published to a Web server and opened from a Web browser.

Download

Incompatibilità tra MOSS 2007 SP1 e Windows Server 2008 R2

September 16, 2009

Se qualcuno ha la necessità di upgradare un server Windows Server 2008 a Windows Server 2008 R2, e sul server è installato MOSS 2007 SP1… no way.
E’ nota l’incompatibilità tra Windows Server 2008 R2 ed il Service Pack 1 di MOSS 2007.

Stesso problema se, su un server Windows Server 2008 R2, si sta cercando di eseguire una nuova installazione di SharePoint 2007 partendo dal CD con MOSS SP1.

Ovviamente la soluzione è altrettanto nota: aggiornare al Service Pack 2 MOSS 2007 prima di eseguire l’upgrade a Windows Server 2008 R2.
Nel secondo caso procurarsi la ISO o il DVD di MOSS 2007 SP2 prima di eseguire il setup di SharePoint (peccato che su MSDN sia ancora disponibile solo il package con SP1… ma un consiglio può essere quello di prepararsi una ISO/DVD con le tecniche di slipstream installation).

Ovviamente, a maggior ragione, la stessa compatibilità esiste anche con versioni di MOSS 2007 precedenti all’SP1.

In conclusione, un’altra buona ragione per aggiornare l’infrastruttura SharePoint 2007 al SP2 (e successivi cumulative updates). A tal propostito segnalo un comodo post di istruzioni step-by-step scritto da Sandro Rizzetto sul suo blog.

Ottimizzazione delle performance di SharePoint 2007

September 15, 2009

Marwan Tarek ha raccolto sul proprio blog una piccola collezione di suggerimenti e link utili a chi sta affrontando il tema dell’ottimizzazione delle performance su sistemi SharePoint 2007.
Riposto per comodità il decalogo, inserendo il link al post originale.

  1. URL Ping Tool: custom tool (developed by MS team) that recorded the time to first byte for URLs hosted on SharePoint servers; You can find the tool script at the Appendix of SharePoint Performance Optimization White Paper
  2. IIS Compression
  3. SharePoint Caching Options: using the Out Of the Box caching techniques
  4. Limiting Page Payload: analyzing Page size, content and requests using either neXpert over Fiddler recommendations (on IE) or YSlow add-on (on Firefox)
  5. Loading core.js when necessary (Delayed /Lazy loading): core.js has noticeable size of the overall page size, you can delay its loading only when needed, http://support.microsoft.com/kb/933823, Professional SharePoint 2007 Web Content Management Development
  6. Infrastructure: review your network infrastructure and make sure all the network cards configured right and meets the design specifications; move your servers to 64 bit hardware; review Database distribution SQL server settings (Source SharePoint Performance Optimization White Paper)
  7. ISA server caching
  8. Dispose checker tool: this tool checks the assembly is following SPWeb and SPSite dispose pattern best practices http://code.msdn.microsoft.com/SPDisposeCheck
  9. Browser Cache and Content Expiration: manipulate the browser caching settings on the client, you can use Andrew Connell’s tool MetaTagsGenerator
  10. Use Ajax callbacks

Annunciata la quarta versione del Microsoft SharePoint Administration Toolkit

September 10, 2009

E’ stata rilasciata la nuova versione del Microsoft SharePoint Administration Toolkit.

Lo strumento, che molti ricorderanno nelle versioni precedenti, consente di estendere diverse funzionalità amministrative di SharePoint.

Tra queste segnalo:

  • SPDiag, la seconda versione di SharePoint Diagnostic Tool, attraverso il quale è possibile ottenere informazioni utili alla risoluzione dei problemi.
    Oltre alle funzionalità per la raccolta dei dati è possibile osseravre il comportamento dell’infrastruttura in un trend di osservazione/analisi.
    Download SPDiag per WSS 3.0
    Download SPDiag per MOSS 2007
  • Permission Reporting Tool, si tratta di una comoda feature che cerca di dare risposta ad una delle più frequenti domande degli SharePoint Administrators: “Ma come faccio a sapere quali sono le effettive autorizzazioni assegnate ad un utente?”.
    L’esigenza del tool nasce dalla spesso non roppo lineare gestione delle permissions su SharePoint, con la frequente necesità di interruzione di ereditarietà nelle autorizzazioni tra siti, liste e item.
    I report consentono di:
    – ricercare i siti con ereditarietà delle permission interrotte (nell’ambito di Site collection), ottenendo un output su file XML fruibile anche da Excel (Broken Inheritance Reports Jobs);
    – verificare, per specifici utenti o gruppi, le effettive autorizzazioni in relazione a un sito, ad una lista/library, ad un item/documento utilizzando il comando Check Effective Permissions;
    – confrontare le effettive autorizzazioni di oggetti, quali siti e liste, attraverso il tool Compare Permissions Sets.
  • Quota Management, che facilita la gestione degli aggiornamenti su dimensione sui quota templates applicati alle site collections. Se lo stesso modello è applicato a più site collection, normalmente sarebbe necessario ripassarsi tutte le site collection manualmente per aggiornare i limite della quota, con questo tool viene accellerata l’applicazione di queste variazioni. Rammento che su SharePoint 2007 le quota sono applicabili solo a livello di Site Collection.
  • Security Configuration Wizard Manifests, ossia un insieme di regole da applicare al sistema per renderlo più sicuro.
    Download la documentazione di SCW.

Ecco i link per il download dell’Administration Toolkit v 4.0:

SharePoint 2007 Productivity HUB

September 9, 2009

Come segnalato da Michael Gannotti, è disponibile per il download lo SharePoint 2007 Productivity Hub.
Ecco di cosa si tratta:

  • Format: Pre-loaded SharePoint site collection, optimized for Web 2.0 functionality and easily deployed within SharePoint Server 2007 environment.
  • Content: Convenient end user productivity training in a variety of formats (documents, videos, podcasts, etc.). Receive free quarterly updates of content that you will learn about through the Productivity blog.
  • Blog: The Productivity blog offers tips and tricks for end user productivity. Use it as is, or your training staff can use the posts as their own to help them get started in running an internal blog.
  • Train the trainer: Includes IT/Manager section to aid with deployment of the site collection, and guidance to develop the Coach program.
  • Products: Office 2007 System applications including SharePoint Server 2007. Windows 7 and others will be added in the future.”

Microsoft Dynamics CRM 4.0 Additional Development Utilities

September 7, 2009

FxCop

http://www.microsoft.com/downloads/details.aspx?familyid=9AEAA970-F281-4FB0-ABA1-D59D7ED09772&displaylang=en

ILMerge

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=22914587-b4ad-4eae-87cf-b14ae6a939b0

.NET Reflector

http://www.aisto.com/roeder/dotnet

Fiddler

http://fiddlertool.com

DebugBar

http://www.debugbar.com

IE Dev Toolbar http://www.microsoft.com/downloadS/details.aspx?familyid=E59C3964-672D-4511-BB3E-2D5E1DB91038&displaylang=en

NUnit

http://www.nunit.org/index.php

RhinoMocks

http://www.ayende.com/projects/rhino-mocks.aspx

Microsoft Dynamics CRM 4.0 Development Tools

September 6, 2009

Source Control
Microsoft Visual Studio Team System

Microsoft Visual SourceSafe

CVS – http://subversion.tigris.org

SVN – http://tortoisesvn.tigris.org

Clear Case – http://www.ibm.com/software/awdtools/clearcase

Vault – http://www.sourcegear.com/vault/

Continuous Integrating Tool

CruiseControl.NET – http://sourceforge.net/projects/ccnet

NAnt – http://nant.sourceforge.net/

Installer

NSIS – http://nsis.sourceforge.net/