Archive for April, 2009

WSS 3.0 e MOSS 2007 Service Pack 2

April 30, 2009

Ecco i link per scaricare i Service Pack 2 di WSS 3.0 e MOSS 2007.

The 2007 Microsoft Office Servers Service Pack 2 (SP2)
Windows SharePoint Services 3.0 Service Pack 2 (SP2)

Questo l’annuncio ufficiale della Microsoft:


Microsoft SQL Server 2008 Feature Pack

April 26, 2009

Brief Description
Download the Microsoft SQL Server 2008 Feature Pack, a collection of stand-alone install packages that provide additional value for SQL Server 2008.

The Feature Pack is a collection of stand-alone install packages that provide additional value for SQL Server 2008. It includes the latest versions of:

– Redistributable components for SQL Server 2008.
– Add-on providers for SQL Server 2008.
– Backward compatibility components for SQL Server 2008.

Microsoft SQL Server 2008 Reporting Services Report Builder 2.0

April 25, 2009

Brief Description
Report Builder 2.0
Microsoft SQL Server 2008 Report Builder 2.0 provides an intuitive report authoring environment for business and power users. It supports the full capabilities of SQL Server 2008 Reporting Services. The download provides a stand-alone installer for Report Builder 2.0

Microsoft SQL Server 2008 Reporting Services Report Builder 2.0 delivers an intuitive, Office-like report authoring environment enabling business and power users to leverage their experience with Microsoft Office 2007 products. Microsoft SQL Server 2008 Reporting Services Report Builder 2.0 supports the full capabilities of SQL Server 2008 Reporting Services including:
– Flexible report layout caabilities of SQL Server 2008 Report Definition Language
– Data Visualizations including charts and gauges
– Richly formatted textboxes
– Export to Microsoft Office Word format

Features specific to Report Builder 2.0 are focused on simplifying the process of creating and editing reports and queries and include the following:

– Easy to use wizards for creating table, matrix and chart data regions
– Support for directly opening and editing reports stored on the report server
– Support for using server resources such as shared data sources
– Query designers for multiple data sources including a Microsoft SQL Server-specific query designer

Microsoft Office SharePoint Server 2007 (MOSS) – How To Determine Service Pack Version

April 24, 2009

SharePoint Server 2007 (including MOSS 2007) or WSS 3.0

Correct Methods

Central Administration > Operations > Servers In Farm > Database Schema Version – You will see the Database Schema Version in the top of the screen and a list of servers with the version numbers listed in the relevant column against each server in the farm

Site Settings > Modify All Site Settings > Site Information > Database Schema Version – You will see the schema version of the site content database

Query the Versions table of the farm configuration database – The entries in this table will show the version number and the date it was applied to the farm

Misleading Methods – The following methods are documented all over the web, but your results may be misleading

IIS Web Site Properties > HTTP Headers Tab >  Custom HTTP headers box which displays a version number – This shows the build version of MOSS at the time the Virtual Directory [Web Application] was created, which is probably not what you’re looking for.

Add / Remove Programs – Select Microsoft SharePoint Server 2007 or Windows SharePoint Services 3.0 > Click here for support information.  This will show the current version of the software installed on a WFE server, but it does not always update and may differ from other servers on the farm.  For better results, use the methods listed above instead.

Cumulative Update KB956056 & KB956057 –
Infrastructure Update KB951695 & KB951297 –
SP1 + KB948945 –
SP1 + KB941274 –
SP1 + KB941422 –
SP1 –
October 2007 public update –
August 24, 2007 hotfix –
RTM – 
Beta 2 –
Beta 2 TR –
Office 12 PDC Pre-beta –

Microsoft SQL Server 2008 – Installing the AdventureWorks Sample Databases

April 23, 2009

About the Databases

There are several versions of the AdventureWorks databases out there.  There are versions for SQL Server 2000, 2005 and 2008, but this post is concentrated on the 2008 versions.  For SQL Server 2008, there are 3 databases.

AdventureWorks OLTP – A standard online transaction processing database containing a year of data of data for a fictitious bicycle manufacturer (Adventure Works Cycles). This database is useful for demo scenarios, and includes data for Manufacturing, Sales, Purchasing, Product Management, Contact Management, and Human Resources functions.

AdventureWorks DW –  A data warehouse database containing a year of data in a star schema, containing multiple fact and dimension tables.  This database is excellent for constructing SQL Server Analysis Service (SSAS) OLAP cubes and demonstrating the Business Intelligence (BI) capabilities of SQL Server and BI client technologies like MOSS 2007, Reporting Services, and Excel.

The AdventureWorks LT (Light) – A highly simplified and smaller sample database which is helpful for those who are new to relational database technology.

Preparing for the Installation

Before attempting the installation, ensure the following services:

Full Text Search
Ensure you have Full-text Filter Daemon Launcher Service running. NOTE: You may receive an error stating that FILESTREAM is not enabled during the install if this service is disabled, which is a bit misleading.

If you did not enable FILESTREAM services during the SQL Server 2008 install, you’ll need to light it up prior to installing the sample AdventureWorks OLTP and DW databases.  If you don’t, the AdventureWorks database installation will fail trying to restore the database, and will warn you that FILESTREAM needs to be enabled. To enable FILESTREAM services on SQL Server 2008, see my post, How To Enable FILESTREAM Feature On SQL Server 2008.

Installing the Sample Databases

1. Download the msi installer for SQL Server 2008 AdventureWorks databases you want to install from CodePlex
2. Ensure you have Full-text Filter Daemon Launcher Service running
3. Ensure you have FILESTREAM services enabled on your SQL Server 2008 server (see notes above)
4. Run the msi installer and click through the intro and license screens
5. Turn on the restore database options during the install, as shown below.  This option will automatically restore the databases, but it is turned off by default. 
6. Select the database server and click Next to complete the installation
7. Repeat steps 1 through 6 to install the DW BI and/or LT databases databases
8. If you did not turn on the restore database options (step 5), you will need to attache the database manually after the install is complete.  You can attach them by running database restore SQL scripts located in C:\Program Files\Microsoft SQL Server\100\Tools\Samples\.

How To Enable Filestream Feature On SQL Server 2008

April 22, 2009

Filestream is a new feature of SQL Server 2008 that supports BLOB file storage on NTFS file shares managed by SQL Server.  The Filestream feature is disabled during the default SQL Server 2008 installation.

To enable Filestream feature on SQL Server 2008:

Open SQL Server Configuration Manager (Start > Programs > Microsoft SQL Server 2008 > Configuration Tools > SQL Server Configuration Manager)

Navigate to the SQL Server Services node and select the SQL Server instance you want to modify SQL Server (MSSQLSERVER)

Click the Filestream tab and select the checkboxes to enable Filestream and enter a share name for the files.

Reporting Services integration with WSS 3.0 and MOSS 2007

April 21, 2009

Configurazione dell’integrazione con SharePoint in più server

Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Readme for Microsoft SQL Server 2005 Reporting Services Add-in for SharePoint Technologies

Microsoft Dynamics CRM 4.0 Internet Facing Deployment Scenarios

April 20, 2009

Microsoft Dynamics CRM 4.0 Internet Facing Deployment Scenarios:
Examples of how to configure the Microsoft Dynamics CRM 4.0 On-premise and Online E-mail Router in different deployment scenarios:
Microsoft Dynamics CRM 4.0 E-mail Router Readme (On Premise):

Microsoft Small Business Server 2008

April 19, 2009

Before you deploy SQL Server in your Windows SBS 2008 domain, be aware of the following restrictions:

The versions of SQL Server that are included in Windows SBS 2008 Premium are licensed for installation only in your Windows SBS 2008 network. You cannot install SQL Server on a server that is not in the Windows SBS 2008 domain.

You can install SQL Server on the server running Windows SBS 2008 or on the second server that you set up for your Windows SBS 2008 domain. However, for security reasons, it is recommended that you do not install the SQL Server on a domain controller. It is recommended that you install SQL Server on the second server in the Windows SBS 2008 domain.

Tratto da:
Using SQL Server in Windows Small Business Server 2008 Premium Edition:

Ed inoltre:
Windows Small Business Server 2008 Technical FAQ:

Can I install SQL Server 2008 from Windows Small Business Server 2008 Premium Edition on the first server?
Yes, this is a supported scenario. However the SQL Server 2008 management tools will not install on the same server; you must install them on another server.

Dal punto: “Installing SQL Server on a domain controller”

The Microsoft Dynamics CRM Developer Toolkit

April 14, 2009

For CRM developers, aligning the engineering delivery and process quality of their CRM projects can substantially increase overall productivity. In addition, by documenting, communicating, and following a consistent process for implementing CRM in Enterprise scenarios, developers can scale projects more quickly and efficiently by adding and ramping up consultants regardless of their previous experience with any specific project.

To provide developers with the ability to create and manage on-premise CRM solutions in an integrated Visual Studio environment, the Microsoft Dynamics CRM Engineering for Enterprise (CRM E2) team initiated and sponsored the development of the Microsoft Dynamics CRM Developer Toolkit. The Toolkit has been designed to make it easier for developers to customize, extend, and maintain an on-premise CRM solution, all from within an integrated Visual Studio environment. Key benefits for developers include the ability to:

  • View All CRM Entities – Displays a listing of CRM entities that are dynamically available from the CRM Explorer within Visual Studio 2008
  • Create and Update CRM Entities – Allows for creating new entities and updating existing entities from within the CRM Explorer experience
  • Create a Wrapper Class – Provides the ability to auto-generate wrapper classes for entities, which exposes the CRM entities and their corresponding attributes as classes and properties respectively to enable development of code to interact with the entities
  • Generate Plug-in Code – Enumerates the available Plug-ins for an entity and generates the code necessary to jumpstart the plug-in development process
  • Integrate the Build and Deploy Process – Simplifies the process of building and deploying a CRM solution
  • Deploy Across Multiple Servers – Assists in deployment and maintenance of Windows installer packages across multiple environments