Enable FileStream in SQL Server 2008

Problem:

Today I tried to install Sample database of "Adventure works 2008" in my system, then it throws the error like…

"AdventureWorks2008 OLTP requires FILESTREAM which is not enabled for the instance you selected. FILESTREAM must be enabled BOTH via the Sql Server configuration Manager and via Management Studio for this instance."

Solution:

This Error Message itself provides the solution for the problem. We have to enable FILESTREAM in two locations. One is SQL Server Configuration Manager and other location via SQL Server Management Studio (SSMS). Here I explained that "how and where we have to enable the FILESTREAM"

SQL Server Configuration Manager:

• Go To Start --> Programs --> Microsoft SQL Server 2008 --> Configuration Tools --> SQL Server Configuration Manager

• Right Click on the SQL Server Services Instance, Then Select Properties
• Go To FILESTREAM Tab
• Check Enable FileStream, as shown in the Exhibit

• Click Apply
• Restart SQL Server Services

SQL Server Management Studio (SSMS):

• Right Click on the SQL Server Database, Select Property

• In Advanced Section, Select FileStream Access Level to "Full Access Enabled"


• Select Ok
• Restart SQL Server Services again

After Enabled FileStream in the given two locations, I continued my installation, it is installed well.

Microsoft .NET Services SDK (Nov 2009 CTP)

Microsoft .NET Services is part of the Azure Services Platform. Microsoft .NET Services includes two services: the Access Control Service and the Service Bus.

This SDK includes API libraries and samples for building connected applications with the .NET platform. It spans the entire spectrum of today’s Internet applications – from rich connected applications with advanced connectivity requirements to Web-style applications that use simple protocols such as HTTP to communicate with the broadest possible range of clients.

Download SDK

SSIS 2005 Vs. SSIS 2008 - View - Find Results Menu

SSIS 2005  - View - Find Results Menu

SSIS 2008  - View - Find Results Menu

SSIS 2005 Vs. SSIS 2008 - Default Menu

I started exploring the changes and new features, which are implemented along with SSIS 2008 release, including look and feel, IDE Appearance, new and modified features etc.,

Here I mentioned some of new changes in menu structure.

When You Open, SQL Server Integration services (SSIS) IDE (Visual Studio), it will display the default Menu structure.

If we compare the menu structure of VS IDE for SSIS 2008 with 2005,

1. Community menu has been removed from 2008, which was there in 2005
2. Test menu is added newly in 2008

SSIS 2005  - Default Menu

 

 SSIS 2008  - Default Menu

SSIS 2005  - Community Menu

SSIS 2008  - Test Menu