Archive for June, 2008

How to create SQL Server 2005 Clustering with Virtual Server 2005

June 30, 2008

In questo blog http://blogs.msdn.com/blakhani/ potete trovare, organizzato in 5 parti, un ottimo tutorial su come creare un cluster Microsoft SQL Server 2005 utilizzando Microsoft Virtual Server 2005.

Parte 1
Parte 2
Parte 3
Parte 4
Parte 5

SQL Server 2000 error 14274: cannot add, update, or delete a job

June 26, 2008

Questa mattina ho dovuto attivare una nuova procedura su un server con Microsoft SQL 2000 SP4 che era fermo da tempo.
Ho riattivato il SQL Server Agent e ho deciso di eliminare i vecchi processi che oramai erano inutili ed inutilizzati da tempo.

Nel tentativo di eliminarli SQL mi visualizzava una dialog box con il messaggio:
Error 14274: Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server.

Ho scoperto che il problema nasce da fatto che il server (come nome macchina) era stato rinominato, ma non era stata rinominata anche la istanza di SQL.

Quindi i processi presenti erano ancora agganciati ad un nome di server non più esistente e quindi non erano cancellabili.

Ciò è osservabile avviando Query analyzer, collegandosi al server e digitando:

SELECT @@servername

e verificando se il nome del server corrisponde a quello attuale. Ovviamente non dovrebbe corrispondere.

Quindi è necessario modificare il nome dell’istanza utilizando questi 2 comandi in successione:
exec sp_dropserver <‘wrong_servername’>

e qindi:

exec sp_addserver <‘correct_servername’>, ‘local’

A questo punto è possibile verificare il nome di istanza collegata a ciascuno dei job presenti con il comando:

SELECT * FROM msdb..sysjobs

e correggere i nomi errati con il comando:

USE msdb
GO
UPDATE sysjobs SET originating_server = <‘correct_servername’> WHERE originating_server = <‘wrong_servername’>

A questo punto è possibile passare alla eliminazione/modifica dei job presenti.

MS Office SharePoint 2007 Scalability and Performance Whitepaper

June 25, 2008

E’ stato recentemente pubblicato un nuovo e ricco white paper su scalabilità e performance dei sistemi SharePoint 2007.

Il documento è piuttosto corposo (97 pagine) e tratta anche sezioni specifiche in relazione agli impatti delle funzionalità di Search.

Download

Windows Installer. V 3.01.4000.1830 command line syntax

June 23, 2008

msiexec /Option <Required Parameter> [Optional Parameter]

Install Options
 </package | /i> <Product.msi>
  Installs or configures a product
 /a <Product.msi>
  Administrative install – Installs a product on the network
 /j<u|m> <Product.msi> [/t <Transform List>] [/g <Language ID>]
  Advertises a product – m to all users, u to current user
 </uninstall | /x> <Product.msi | ProductCode>
  Uninstalls the product
Display Options
 /quiet
  Quiet mode, no user interaction
 /passive
  Unattended mode – progress bar only
 /q[n|b|r|f]
  Sets user interface level
  n – No UI
  b – Basic UI
  r – Reduced UI
  f – Full UI (default)
 /help
  Help information
Restart Options
 /norestart
  Do not restart after the installation is complete
 /promptrestart
  Prompts the user for restart if necessary
 /forcerestart
  Always restart the computer after installation
Logging Options
 /l[i|w|e|a|r|u|c|m|o|p|v|x|+|!|*] <LogFile>
  i – Status messages
  w – Nonfatal warnings
  e – All error messages
  a – Start up of actions
  r – Action-specific records
  u – User requests
  c – Initial UI parameters
  m – Out-of-memory or fatal exit information
  o – Out-of-disk-space messages
  p – Terminal properties
  v – Verbose output
  x – Extra debugging information
  + – Append to existing log file
  ! – Flush each line to the log
  * – Log all information, except for v and x options
 /log <LogFile>
  Equivalent of /l* <LogFile>
Update Options
 /update <Update1.msp>[;Update2.msp]
  Applies update(s)
 /uninstall <PatchCodeGuid>[;Update2.msp] /package <Product.msi | ProductCode>
  Remove update(s) for a product
Repair Options
 /f[p|e|c|m|s|o|d|a|u|v] <Product.msi | ProductCode>
  Repairs a product
  p – only if file is missing
  o – if file is missing or an older version is installed (default)
  e – if file is missing or an equal or older version is installed
  d – if file is missing or a different version is installed
  c – if file is missing or checksum does not match the calculated value
  a – forces all files to be reinstalled
  u – all required user-specific registry entries (default)
  m – all required computer-specific registry entries (default)
  s – all existing shortcuts (default)
  v – runs from source and recaches local package
Setting Public Properties
 [PROPERTY=PropertyValue]

Consult the Windows Installer SDK for additional documentation on the command line syntax.

Microsoft SQL Server 2005 – Login failed for user ‘username’

June 22, 2008

The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452):
http://support.microsoft.com/kb/555332

You may receive a “Not associated with a trusted SQL Server connection” error message when you try to connect to SQL Server 2000 or SQL Server 2005:

http://support.microsoft.com/kb/889615
 
SQL Server is not set to use both SQL Server and Windows Authentication Mode. 
 
Resolving the problem

To resolve this issue, follow the instructions to set User Authentication.

SQL Server 2000:
 
Go to Start > Programs > Microsoft SQL Server > Enterprise Manager
Right-click the Server name, select Properties > Security
Under Authentication, select SQL Server and Windows
The server must be stopped and re-started before this will take effect

SQL Server 2005:
 
Go to Start > Programs > Microsoft SQL Server 2005 > SQL Server Management Studio
Right-click the Server name, select Properties > Security
Under Server Authentication, select SQL Server and Windows Authentication Mode
The server must be stopped and re-started before this will take effect

Microsoft Virtual Server 2005 R2 SP1 Update

June 21, 2008

E’ uscito il tanto atteso update per Virtual Server 2005 R2 che fornisce il pieno supporto a Microsoft Windows 2008 come Host.

Microsoft Virtual Server 2005 R2 SP1 Update
http://www.microsoft.com/downloads/details.aspx?FamilyID=a79bcf9b-59f7-480b-a4b8-fb56f42e3348&displaylang=en

Additonal Guest Operating System support:
Windows Vista® Ultimate Edition with Service Pack 1 (SP1)
Windows Vista® Business Edition with Service Pack 1 (SP1)
Windows Vista® Enterprise Edition with Service Pack 1 (SP1)
Windows Server® 2008 Core
Windows Server® 2008 Standard
Windows Server® 2008 Datacenter
Windows Server® 2008 Enterprise
Windows Server® 2008 Small Business Server
Windows XP Professional with Service Pack 3
Additional Host Operating System support:
Windows Vista® Ultimate Edition with Service Pack 1 (SP1) (non-production use only)
Windows Vista® Business Edition with Service Pack 1 (SP1) (non-production use only)
Windows Vista® Enterprise Edition with Service Pack 1 (SP1)(non-production use only)
Windows Server® 2008 Core
Windows Server® 2008 Standard
Windows Server® 2008 Datacenter
Windows Server® 2008 Enterprise
Windows Server® 2008 Small Business Server
Windows XP Professional with Service Pack 3 (non-production use only)

Inoltre:

Microsoft Virtual PC 2007 SP1
http://www.microsoft.com/downloads/details.aspx?displaylang=it&FamilyID=28c97d22-6eb8-4a09-a7f7-f6c7a1f000b5

Supporto per sistema operativo guest aggiuntivo:
Windows Vista® Ultimate Edition con Service Pack 1 (SP1)
Windows Vista® Business Edition con Service Pack 1 (SP1)
Windows Vista® Enterprise Edition con Service Pack 1 (SP1)
Windows Server® 2008 Standard
Windows XP Professional con Service Pack 3

Supporto per sistema operativo host aggiuntivo:
Windows Vista® Ultimate Edition con Service Pack 1 (SP1)
Windows Vista® Business Edition con Service Pack 1 (SP1)
Windows Vista® Enterprise Edition con Service Pack 1 (SP1)
Windows XP Professional con Service Pack 3

Dopo aver installato questo aggiornamento dovreste avere:

Versione del prodotto: 6.0.192.0
Versione delle VM Additions:  13.820

Per ulteriori info:

Viitual PC 2007 Service Pack 1 è arrivato
http://blogs.technet.com/italy/archive/2008/05/16/virtual-pc-2007-service-pack-1-arrivato.aspx

Microsoft Windows 2008 è supportato con Virtual Pc solo come sistema operativo Guest ed in versione Standard.

Si aprono quindi tutta una serie di possibilità nuove per virtualizzare i prodotti Sharepoint.

TechNet Virtual Labs: SharePoint Products and Technologies

June 20, 2008

Al link sottostante la pagina dei Technet Virtual Labs.

Si tratta di una serie di laboratori gratuiti, accessibili online tramite l’installazione di un controllo ActiveX e corredati da una serie di esercizi da completare per familiarizzare con i prodotti Sharepoint.
La durata massima di ogni lab è di 90 minuti, ma può essere ripetuto a piacere senza limiti.

Al link seguente potete scaricare un esempio dei PDF guida con gli esercizi da svolgere.

TechNet Virtual Lab: What’s New in Microsoft Windows SharePoint Services 3.0 Feature Walkthrough

TechNet Virtual Labs: SharePoint Products and Technologies
http://technet.microsoft.com/it-it/bb512933(en-us).aspx

SharePoint Server 2007

  • TechNet Virtual Lab: Search Administration and Customization in Microsoft Office
  • SharePoint Server 2007 TechNet Virtual Lab: Microsoft Office SharePoint Server 2007 Installation and Configuration
  • TechNet Virtual Lab: Enterprise Search Protocol Handlers
  • TechNet Virtual Lab: Business Data Catalog in Enterprise Search
  • TechNet Virtual Lab: Configuring Microsoft Office SharePoint Server for Enterprise Search
  • TechNet Virtual Lab: Enterprise Search Overview
  • TechNet Virtual Lab: Forefront Security for SharePoint
  • TechNet Virtual Lab: Getting Started with the Business Data Catalog in Microsoft Office SharePoint Server 2007
  • TechNet Virtual Lab: Synchronizing data between SharePoint 2007 and Groove 2007
  • TechNet Virtual Lab: Synchronizing data between SharePoint 2007 and Groove 2007
  • TechNet Virtual Lab: What’s New in Microsoft Office SharePoint Server 2007
  • TechNet Virtual Lab: Microsoft Office SharePoint Server 2007 Records Management Deployment and Configuration
  • TechNet Virtual Lab: Microsoft Office SharePoint Server 2007 Enterprise Features Administration
  • TechNet Labcast On-Demand: Deploying Microsoft Office SharePoint Server
  • TechNet Labcast On-Demand: Administering Microsoft Office SharePoint Server 2007
  • TechNet Labcast On-Demand: Implementing Search and Indexing

Windows SharePoint Services 3.0

  • TechNet Virtual Lab: Using Microsoft Windows PowerShell for Administration and Customization of Microsoft Windows SharePoint Services 3.0
  • TechNet Virtual Lab: Enterprise Search Protocol Handlers
  • TechNet Virtual Lab: Microsoft Windows SharePoint Services Installation and Configuration
  • TechNet Virtual Lab: Customizing Enterprise Search
  • TechNet Virtual Lab: Enterprise Search Security and Compliance
  • TechNet Virtual Lab: Creating Workflows for Microsoft Windows SharePoint Services 3.0
  • TechNet Virtual Lab: What’s New in Microsoft Windows SharePoint Services 3.0 Feature Walkthrough
  • TechNet Virtual Lab: Introducing Content Types for Microsoft Windows SharePoint Services 3.0
  • TechNet Virtual Lab: Microsoft Windows SharePoint Services Installation and Configuration

SharePoint Portal Server 2003

  • TechNet Virtual Lab Express: Introduction to SharePoint Portal Server
  • TechNet Virtual Lab: Creating Connectable Web Parts for Microsoft SharePoint Products and Technologies
  • TechNet Virtual Lab: Managing Microsoft Office SharePoint Portal Server 2003 Content and Navigation
  • TechNet Virtual Lab: Creating a Custom Site Definition for Microsoft Windows SharePoint Services
  • TechNet Virtual Lab: Microsoft Office SharePoint Portal Server 2003 People and Personalization
  • TechNet Virtual Lab: Using Microsoft Office FrontPage 2003 to Customize Microsoft Windows SharePoint Services
  • TechNet Virtual Lab: Microsoft SharePoint Products and Technologies Permissions Management

Windows Sharepoint Services 3.0 Flash Demo

June 15, 2008

Per chi non ne fosse a conoscenza segnalo al link sottostante una demo in Flash dei Windows Sharepoint Services 3.0.

Si tratta di una presentazione in inglese, della durata di circa 5 minuti che illustra molto bene le potenzialita del prodotto.  E’ molto utile da mostrare a clienti e personale commerciale.

Sharepoint Services 3.0 Flash Demo
http://www.microsoft.com/sharepoint/demo.mspx

Autenticazione Kerberos in MOSS 2007

June 14, 2008

Kerberos is a secure protocol that supports ticketing authentication. A Kerberos authentication server grants a ticket in response to a client computer authentication request, if the request contains valid user credentials and a valid Service Principal Name (SPN). The client computer then uses the ticket to access network resources. To enable Kerberos authentication, the client and server computers must have a trusted connection to the domain Key Distribution Center (KDC). The KDC distributes shared secret keys to enable encryption. The client and server computers must also be able to access Active Directory directory services. For Active Directory, the forest root domain is the center of Kerberos authentication referrals.

To deploy a Microsoft Office SharePoint Server 2007 server farm using Kerberos authentication, you must install and configure a variety of applications on your computers. This article describes an example Office SharePoint Server 2007 server farm, and provides guidance for deploying and configuring the farm to use Kerberos authentication to support the following functionality:

  • Communication between Office SharePoint Server 2007 and Microsoft SQL Server database software
  • Access to the SharePoint Central Administration Web application
  • Access to the Shared Services Provider (SSP) Web application
  • Access to end-user Web applications, including a Portal site Web application, a MySite Web application, and an SSP Administration site Web application

Tratto da:

Configure Kerberos authentication (Office SharePoint Server):
http://technet.microsoft.com/en-us/library/cc263449.aspx

Consiglio inoltre di dare un’occhiata ai due Blog sottostanti che trattano molto bene l’argomento:

A Marvellous Point : Configuring Kerberos for SharePoint 2007: Part 1 – Base Configuration for SharePoint:
http://blogs.msdn.com/martinkearn/archive/2007/04/23/configuring-kerberos-for-sharepoint-2007-part-1-base-configuration-for-sharepoint.aspx

A Marvellous Point : Configuring Kerberos for SharePoint 2007: Part 2 – Excel Services and SQL Analysis Services:
http://blogs.msdn.com/martinkearn/archive/2007/04/27/configuring-kerberos-for-sharepoint-2007-part-2-excel-services-and-sql-analysis-services.aspx

James World : Essential Tips On Kerberos for SharePoint Deployers:
http://blogs.msdn.com/james_world/archive/2007/08/20/essential-guide-to-kerberos-in-sharepoint.aspx

Doveste poi incontrare qualche problema , i link seguenti sono un buon punto d’inizio:

Troubleshooting Kerberos Errors

How to configure a Windows SharePoint Services virtual server to use Kerberos authentication and how to switch from Kerberos authentication back to NTLM authentication: http://support.microsoft.com/?kbid=832769

How to use Kerberos authentication in SQL Server: http://support.microsoft.com/kb/319723

Apertura in sola lettura dei documenti di Office 2003 – 2007 in Internet Explorer

June 13, 2008

Se un documento viene aperto direttamente dalla Document Library in Sharepoint, non si verifica nessun problema e viene richiesto se vogliamo accedervi in modalità Read Only (con la possibilità successiva di editarlo) o in modalità Editing.

Se un documento viene aperto da un link all’interno di una mail” preparata” direttamente dalla Document Library non si verifica nessun problema.

Se invece copiamo direttamente il link dalla Document Library Sharepoint e lo incolliamo altrove e proviamo ad aprire il documento, questo verrà aperto in modalità Read Only, senza la possibilità di modifcarlo in un secondo tempo.

Per cui non si vedrà la possibilità di effettuare modifiche successivamente al file.

La KB seguente risolve nella maggior parte dei casi il problema:

Apertura in sola lettura dei documenti di Office 2003/2007 in Internet Explorer:
http://support.microsoft.com/kb/870853/en-us

I documenti potrebbero essere aperti in modalità Read Only anche cliccando sul risultato fornito da una ricerca con Search Server 2008 che mostra dati provenienti da una Document Library Sharepoint indicizzata.


Follow

Get every new post delivered to your Inbox.

Join 29 other followers