Caspol.exe Sql 2008

Jan 22, 2010  Sql Server 2008 Management Tools - Basic 1033 Express Edition 10.0.1600.22 No Package properties: Description: SQL Server Database Services 2008.

By: Ashish Kumar Mehta Updated: 2009-09-16 Comments (8) Related: More >FILESTREAM

Problem
A new feature in SQL Server 2008 is the FILESTREAM feature which allows you to store BLOBs in the NTFS file system instead of in the database. In order to use this new feature it has to be enabled. In this tip I go over four different options to enable the FILESTREAM feature.

Solution
In SQL Server 2008 one can store BLOBs (e.g. Images, video, word, excel, PDF, MP3, etc) in the NTFS file system rather than in a database file. This can be done by using the new FILESTREAM feature which was introduced in SQL Server 2008. However, in order to enable the FILESTREAM feature you need to be a member of the SYSADMIN or SERVERADMIN fixed server roles.

There are different ways in which one can enable FILESTREAM feature in SQL Server 2008. Let us go through each option one by one.

Enable FILESTREAM Feature Using SQL Server Configuration Manager

1. Click Start All Programs Microsoft SQL Server 2008 Configuration Tools SQL Server Configuration Manager.

This will open up SQL Server Configuration Manager as shown in the below snippet

2. In the left panel of SQL Server Configuration Manger, click on SQL Server Services, this will list all the SQL Server 2008 related services on the right side panel.

3. Click on SQL Server (MSSQLSERVER) service instance in case of a default installation. However, in case of a named instance you need to choose SQL Server (Instance Name) service and right click the same to see the properties for the service.

4. In SQL Server Properties dialog box, you need to click on FILESTREAM tab and Enable FILESTREAM for Transact-SQL access checkbox, this will enable the rest of the options.

5. If you are interested in enabling read and write FILESTREAM data from windows, then click Enable FILESTREAM for file I/O streaming access and specify the name of the windows file share in the Windows Share Name textbox.

6. If you require remote clients to access the FILESTREAM data that is stored in the share, then select Allow remote clients to have streaming access to FILESTREAM data option as shown in the below snippet.

7. Finally click OK to save the changes.

Enable FILESTREAM Feature Using Transact SQL (TSQL)

The FILESTREAM feature of SQL Server 2008 can also be enabled using the Transact SQL (TSQL).

In the SQL Server 2008 Management Studio, open a new query window and type the below TSQL Query to enable FILESTREAM feature.

There are 3 levels of FILESTREAM access which are supported in SQL Server 2008 and they are mentioned below for your reference.

• When the value specified is 0 then, FILESTREAM support for the instance is Disabled
• When the value specified is 1 then, FILESTREAM for Transact-SQL Access is Enabled
• When the value specified is 2 then, FILESTREAM for Transact-SQL and Windows streaming access is Enabled

Enable FILESTREAM Feature at SQL Server Instance Level using SQL Server 2008 Management Studio (SSMS)

V4 Elite 3D Female Texture: Lana is a high-resolution full-body female skin texture. Specular and bump maps are also included with this skin texture. Poser Elite Texture Lana V40 DOWLOAND The Victoria 4.2 3D Model Pro Suite contains over worth of Victoria 4 content. This includes everything in the Victoria 4.2 Starter Bundle and Pro Bundle, the V4 Elite Bundle, Victoria 4 Muscle Morphs, Creature Creator Morphs and Add Ons, Victoria 4.2 Bodysuit, and V4 Unimesh Clothing Bundle #3 making this the absolute best value for your money of all the Victoria 4 bundles. Bundle up with Amy, Maya, and Lana – yes, all three of our new Elite textures. After all, each separately cannot give you everything you need. Whether it's Amy's freckles, or Maya's olive skin or Lana's supple lips, they all have something you want. Poser Elite Texture Lana V4 Engine Rating: 5,0/5 6101 votes Professionally lit, extremely high-resolution, full-body photo-reference was captured and then carefully assembled to preserve natural asymmetry and remove all possible seams. Poser Elite Body Shapes V4 V4 Elite Texture: Lana is a Carrara for Victoria 4 for Daz Studio or Poser created by DAZ Originals and -Yannek. V4 Elite Bundle Daz/Poser. Remember that each Elite Skin Texture is wholly original and 100% unique from any other.

The FILESTREAM feature of SQL Server 2008 can also be enabled at the SQL Server Instance level using SQL Server Management Studio by following the below mentioned steps.

1. Connect to SQL Server 2008 Database Instance using SQL Server 2008 Management Studio

2. In the Object Explorer, right click the database instance and select Properties to view the Server Properties

3. On the left panel click on the Advanced tab, then click on the drop down list next to Filestream Access Level and select Full access enabled option as shown in the below snippet

4. Finally click OK to save the changes.

Enable FILESTREAM Feature during the Installation of SQL Server 2008

The FILESTREAM feature can also be enabled during the installation of SQL Server 2008. A DBA can enable this feature by clicking on the FILESTREAM tab of the Database Engine Configuration screen and can choose all the available options as per his requirement as shown in the snippet below.

Next Steps:

• If you haven't started working with SQL Sever 2008, download a 180 day evaluation from this site to get started on these new topics
• Here is another tip related to this topic - Using FILESTREAM to Store BLOBs in the NTFS File System in SQL Server 2008
• Review the SQL Server 2008 Books on Line content for FILESTREAM for additional information

About the author

Recently I was trying to help one of my clients to install Service Pack 3 for SQL Server 2008 R2 instance. Nothing was coming up when we were hitting setup.exe. I looked into my own blog and found Installation Log Summary File Location – 2012 – 2008 R2. But there was no file getting generated. I looked around of MSDN and found: https://msdn.microsoft.com/en-us/library/ms143702.aspx. The reason was there was exit code 0x80004005.

It says that we should look into %TEMP% folder. So I went to Start > Run > %TEMP% and found sqlsetup.log file as below.

03/01/2016 10:04:11.954 Setup launched
03/01/2016 10:04:11.955 Attempting to determine media source
03/01/2016 10:04:11.956 Media source value not specified on command line argument.
03/01/2016 10:04:11.957 Setup is launched from media directly so default the value to the current folder.
03/01/2016 10:04:11.957 Media source: D:SOFTWARESP3
03/01/2016 10:04:11.958 Attempt to determine media layout based on file ‘ D:SOFTWARESP3mediainfo.xml’.
03/01/2016 10:04:11.981 Media layout is detected as: Core
03/01/2016 10:04:11.982 Not a slip stream media, so continuing to run setup.exe from media.
03/01/2016 10:04:11.983 /? or /HELP or /ACTION=HELP specified: false
03/01/2016 10:04:11.984 Help display: false
03/01/2016 10:04:11.985 Checking to see if we need to install .Net version 3.5
03/01/2016 10:04:11.985 Checking to see if we need to install MSI version 4.5
03/01/2016 10:04:11.986 RedistMSI::GetExpectedBuildRevision – Setup expects MSI 4.5.6001.22159 at the minimum
03/01/2016 10:04:11.987 Attempting to get Windows Installer version
03/01/2016 10:04:11.988 Windows Installer version detected: 5.0.7601.18493
03/01/2016 10:04:11.990 RedistMSI::IsVistaRTM – Not Vista RTM build
03/01/2016 10:04:11.991 Required version of Windows Installer is already installed
03/01/2016 10:04:11.992 .Net version 3.5 is already installed.
03/01/2016 10:04:11.992 Windows Installer version 4.5 is already installed.
03/01/2016 10:04:11.993 Patch related actions cannot be run from the local setup.exe, so continuing to run setup.exe from media.
03/01/2016 10:04:11.993 Attempt to initialize SQL setup code group
03/01/2016 10:04:11.994 Attempting to determine security.config file path
03/01/2016 10:04:11.995 Checking to see if policy file exists
03/01/2016 10:04:11.996 .Net security policy file does exist
03/01/2016 10:04:11.997 Attempting to load .Net security policy file
03/01/2016 10:04:12.000 Error: Cannot load .Net security policy file
03/01/2016 10:04:12.001 Error: InitializeSqlSetupCodeGroupCore(64bit) failed
03/01/2016 10:04:12.002 Error: InitializeSqlSetupCodeGroup failed: 0x80004005
03/01/2016 10:04:12.002 Setup closed with exit code: 0x80004005

All I can see is that there is something wrong with .NET security. I asked my .NET expert friend to know if there is any tool to reset the permission? He told CASPOL.EXE can be used to reset the policies.

So, we went into following directory “C:WINDOWSMicrosoft.NETFramework64v2.0.50727” and ran this command: – caspol.exe -machine -reset

C:WINDOWSMicrosoft.NETFramework64v2.0.50727>caspol.exe -machine -reset

If it would have been a 32-bit machine, we would have run the same command under “C:WINDOWSMicrosoft.NETFrameworkv2.0.50727” folder.

After doing above, the setup was able to start and finish as well.

Reference: Pinal Dave (https://blog.sqlauthority.com)