Windows system clr types for sql server 2012

Картинка с сайта: silentinstallhq.com

This article will serve as an informative guide and give you a clear understanding of how to perform silent or interactive installs and uninstalls of Microsoft System CLR Types for SQL Server 2012 using the Powershell App Deployment Toolkit. The PowerShell App Deployment Toolkit can be used to replace your WiseScript, VBScript and Batch wrapper scripts with one versatile, re-usable and extensible tool. This tool is an absolute must for Microsoft Endpoint Manager Configuration Manager (MEMCM) / (SCCM) Administrators or anyone who is responsible for packaging and deploying software.

How to Install Microsoft System CLR Types for SQL Server 2012 Using the PowerShell App Deployment Toolkit

1. Download the Powershell App Deployment Toolkit 3.8.4:
   • https://github.com/PSAppDeployToolkit/PSAppDeployToolkit/releases/download/3.8.4/PSAppDeployToolkit_v3.8.4.zip
2. Download the zip file to a folder created at (C:\Downloads)
3. Open Windows PowerShell by Right-Clicking on Windows PowerShell and selecting Run as Administrator
4. Enter the following command to remove the Zone.Identifier:
   • Unblock-File -Path C:\Downloads\PSAppDeployToolkit_v3.8.4.zip
5. Enter the following command to extract the contents of the zip file:
   • Expand-Archive -Path C:\Downloads\PSAppDeployToolkit_v3.8.4.zip -DestinationPath C:\Downloads\PADT
6. Enter the following commands to copy the AppDeployToolkit & Files folders to “C:\Downloads\SQLSysClrTypes2012”:
   • Copy-Item -Path "C:\Downloads\PADT\Toolkit\AppDeployToolkit" -Destination "C:\Downloads\SQLSysClrTypes2012\AppDeployToolkit" -Recurse
   • Copy-Item -Path "C:\Downloads\PADT\Toolkit\Files" -Destination "C:\Downloads\SQLSysClrTypes2012\Files"
7. We also need to create two additional directories called x86 & x64
   • New-Item "C:\Downloads\SQLSysClrTypes2012\Files\x86" -ItemType Directory
   • New-Item "C:\Downloads\SQLSysClrTypes2012\Files\x64" -ItemType Directory

You should now see the AppDeploymentToolkit folder with files & the Files directory with empty x86 & x64 folders at “C:\Downloads\SQLSysClrTypes2012“

Next we’ll want to download both the 32-bit & 64-bit MSI installers for Microsoft System CLR Types for SQL Server 2012.

• Navigate to: https://download.microsoft.com/download/F/3/C/F3C64941-22A0-47E9-BC9B-1A19B4CA3E88/ENU/x86/SQLSysClrTypes.msi
• Download & Copy the SQLSysClrTypes.msi to “C:\Downloads\SQLSysClrTypes2012\Files\x86\”
• Navigate to: https://download.microsoft.com/download/F/3/C/F3C64941-22A0-47E9-BC9B-1A19B4CA3E88/ENU/x64/SQLSysClrTypes.msi
• Download & Copy the SQLSysClrTypes.msi to “C:\Downloads\SQLSysClrTypes2012\Files\x64\”
• Copy the PowerShell script below to “C:\Downloads\SQLSysClrTypes2012“ & name it Deploy-SQLSysClrTypes2012.ps1

<#
.SYNOPSIS
	This script performs the installation or uninstallation of Microsoft System CLR Types for SQL Server 2012.
	# LICENSE #
	PowerShell App Deployment Toolkit - Provides a set of functions to perform common application deployment tasks on Windows.
	Copyright (C) 2017 - Sean Lillis, Dan Cunningham, Muhammad Mashwani, Aman Motazedian.
	This program is free software: you can redistribute it and/or modify it under the terms of the GNU Lesser General Public License as published by the Free Software Foundation, either version 3 of the License, or any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
	You should have received a copy of the GNU Lesser General Public License along with this program. If not, see <http://www.gnu.org/licenses/>.
.DESCRIPTION
	The script is provided as a template to perform an install or uninstall of an application(s).
	The script either performs an "Install" deployment type or an "Uninstall" deployment type.
	The install deployment type is broken down into 3 main sections/phases: Pre-Install, Install, and Post-Install.
	The script dot-sources the AppDeployToolkitMain.ps1 script which contains the logic and functions required to install or uninstall an application.
.PARAMETER DeploymentType
	The type of deployment to perform. Default is: Install.
.PARAMETER DeployMode
	Specifies whether the installation should be run in Interactive, Silent, or NonInteractive mode. Default is: Interactive. Options: Interactive = Shows dialogs, Silent = No dialogs, NonInteractive = Very silent, i.e. no blocking apps. NonInteractive mode is automatically set if it is detected that the process is not user interactive.
.PARAMETER AllowRebootPassThru
	Allows the 3010 return code (requires restart) to be passed back to the parent process (e.g. SCCM) if detected from an installation. If 3010 is passed back to SCCM, a reboot prompt will be triggered.
.PARAMETER TerminalServerMode
	Changes to "user install mode" and back to "user execute mode" for installing/uninstalling applications for Remote Destkop Session Hosts/Citrix servers.
.PARAMETER DisableLogging
	Disables logging to file for the script. Default is: $false.
.EXAMPLE
    PowerShell.exe .\Deploy-SQLSysClrTypes2012.ps1 -DeploymentType "Install" -DeployMode "NonInteractive"
.EXAMPLE
    PowerShell.exe .\Deploy-SQLSysClrTypes2012.ps1 -DeploymentType "Install" -DeployMode "Silent"
.EXAMPLE
    PowerShell.exe .\Deploy-SQLSysClrTypes2012.ps1 -DeploymentType "Install" -DeployMode "Interactive"
.EXAMPLE
    PowerShell.exe .\Deploy-SQLSysClrTypes2012.ps1 -DeploymentType "Uninstall" -DeployMode "NonInteractive"
.EXAMPLE
    PowerShell.exe .\Deploy-SQLSysClrTypes2012.ps1 -DeploymentType "Uninstall" -DeployMode "Silent"
.EXAMPLE
    PowerShell.exe .\Deploy-SQLSysClrTypes2012.ps1 -DeploymentType "Uninstall" -DeployMode "Interactive"
.NOTES
	Toolkit Exit Code Ranges:
	60000 - 68999: Reserved for built-in exit codes in Deploy-Application.ps1, Deploy-Application.exe, and AppDeployToolkitMain.ps1
	69000 - 69999: Recommended for user customized exit codes in Deploy-Application.ps1
	70000 - 79999: Recommended for user customized exit codes in AppDeployToolkitExtensions.ps1
.LINK
	http://psappdeploytoolkit.com
#>
[CmdletBinding()]
Param (
	[Parameter(Mandatory=$false)]
	[ValidateSet('Install','Uninstall','Repair')]
	[string]$DeploymentType = 'Install',
	[Parameter(Mandatory=$false)]
	[ValidateSet('Interactive','Silent','NonInteractive')]
	[string]$DeployMode = 'Interactive',
	[Parameter(Mandatory=$false)]
	[switch]$AllowRebootPassThru = $false,
	[Parameter(Mandatory=$false)]
	[switch]$TerminalServerMode = $false,
	[Parameter(Mandatory=$false)]
	[switch]$DisableLogging = $false
)

Try {
	## Set the script execution policy for this process
	Try { Set-ExecutionPolicy -ExecutionPolicy 'ByPass' -Scope 'Process' -Force -ErrorAction 'Stop' } Catch {}

	##*===============================================
	##* VARIABLE DECLARATION
	##*===============================================
	## Variables: Application
	[string]$appVendor = ''
	[string]$appName = 'Microsoft System CLR Types for SQL Server 2012'
	[string]$appVersion = ''
	[string]$appArch = ''
	[string]$appLang = ''
	[string]$appRevision = ''
	[string]$appScriptVersion = '1.0.0'
	[string]$appScriptDate = 'XX/XX/20XX'
	[string]$appScriptAuthor = 'Jason Bergner'
	##*===============================================
	## Variables: Install Titles (Only set here to override defaults set by the toolkit)
	[string]$installName = ''
	[string]$installTitle = 'Microsoft System CLR Types for SQL Server 2012'

	##* Do not modify section below
	#region DoNotModify

	## Variables: Exit Code
	[int32]$mainExitCode = 0

	## Variables: Script
	[string]$deployAppScriptFriendlyName = 'Deploy Application'
	[version]$deployAppScriptVersion = [version]'3.8.4'
	[string]$deployAppScriptDate = '26/01/2021'
	[hashtable]$deployAppScriptParameters = $psBoundParameters

	## Variables: Environment
	If (Test-Path -LiteralPath 'variable:HostInvocation') { $InvocationInfo = $HostInvocation } Else { $InvocationInfo = $MyInvocation }
	[string]$scriptDirectory = Split-Path -Path $InvocationInfo.MyCommand.Definition -Parent

	## Dot source the required App Deploy Toolkit Functions
	Try {
		[string]$moduleAppDeployToolkitMain = "$scriptDirectory\AppDeployToolkit\AppDeployToolkitMain.ps1"
		If (-not (Test-Path -LiteralPath $moduleAppDeployToolkitMain -PathType 'Leaf')) { Throw "Module does not exist at the specified location [$moduleAppDeployToolkitMain]." }
		If ($DisableLogging) { . $moduleAppDeployToolkitMain -DisableLogging } Else { . $moduleAppDeployToolkitMain }
	}
	Catch {
		If ($mainExitCode -eq 0){ [int32]$mainExitCode = 60008 }
		Write-Error -Message "Module [$moduleAppDeployToolkitMain] failed to load: `n$($_.Exception.Message)`n `n$($_.InvocationInfo.PositionMessage)" -ErrorAction 'Continue'
		## Exit the script, returning the exit code to SCCM
		If (Test-Path -LiteralPath 'variable:HostInvocation') { $script:ExitCode = $mainExitCode; Exit } Else { Exit $mainExitCode }
	}

	#endregion
	##* Do not modify section above
	##*===============================================
	##* END VARIABLE DECLARATION
	##*===============================================

	If ($deploymentType -ine 'Uninstall' -and $deploymentType -ine 'Repair') {
		##*===============================================
		##* PRE-INSTALLATION
		##*===============================================
		[string]$installPhase = 'Pre-Installation'

		## Show Welcome Message
		Show-InstallationWelcome

		## Show Progress Message (with the default message)
		Show-InstallationProgress

        ## Remove Any Existing Versions of Microsoft System CLR Types for SQL Server 2012
        Remove-MSIApplications -Name 'Microsoft System CLR Types for SQL Server 2012'
  
		##*===============================================
		##* INSTALLATION
		##*===============================================
		[string]$installPhase = 'Installation'

        If ($ENV:PROCESSOR_ARCHITECTURE -eq 'x86'){
        Write-Log -Message "Detected 32-bit OS Architecture." -Severity 1 -Source $deployAppScriptFriendlyName

        ## Install Microsoft System CLR Types for SQL Server 2012 (x86)
        $MsiPath32 = Get-ChildItem -Path "$dirFiles\x86" -Include SQLSysClrTypes.msi -File -Recurse -ErrorAction SilentlyContinue
        If($MsiPath32.Exists)
        {
        Write-Log -Message "Found $($MsiPath32.FullName), now attempting to install $installTitle (x86)."       
        Show-InstallationProgress "Installing Microsoft System CLR Types for SQL Server 2012 (x86). This may take some time. Please wait..."
        Execute-MSI -Action Install -Path "$MsiPath32"
        Start-Sleep -Seconds 5
        }

        }
        Else
        {
        Write-Log -Message "Detected 64-bit OS Architecture" -Severity 1 -Source $deployAppScriptFriendlyName

        ## Install Microsoft System CLR Types for SQL Server 2012 (x86)
        $MsiPath32 = Get-ChildItem -Path "$dirFiles\x86" -Include SQLSysClrTypes.msi -File -Recurse -ErrorAction SilentlyContinue
        If($MsiPath32.Exists)
        {
        Write-Log -Message "Found $($MsiPath32.FullName), now attempting to install $installTitle (x86)."       
        Show-InstallationProgress "Installing Microsoft System CLR Types for SQL Server 2012 (x86). This may take some time. Please wait..."
        Execute-MSI -Action Install -Path "$MsiPath32"
        Start-Sleep -Seconds 5
        }

        ## Install Microsoft System CLR Types for SQL Server 2012 (x64)
        $MsiPath64 = Get-ChildItem -Path "$dirFiles\x64" -Include SQLSysClrTypes.msi -File -Recurse -ErrorAction SilentlyContinue
        If($MsiPath64.Exists)
        {
        Write-Log -Message "Found $($MsiPath64.FullName), now attempting to install $installTitle (x64)."       
        Show-InstallationProgress "Installing Microsoft System CLR Types for SQL Server 2012 (x64). This may take some time. Please wait..."
        Execute-MSI -Action Install -Path "$MsiPath64"
        Start-Sleep -Seconds 5
        }
        }
    
		##*===============================================
		##* POST-INSTALLATION
		##*===============================================
		[string]$installPhase = 'Post-Installation'

	}
	ElseIf ($deploymentType -ieq 'Uninstall')
	{
		##*===============================================
		##* PRE-UNINSTALLATION
		##*===============================================
		[string]$installPhase = 'Pre-Uninstallation'

		## Show Welcome Message
		Show-InstallationWelcome

        ## Show Progress Message (With a Message to Indicate the Application is Being Uninstalled)
        Show-InstallationProgress -StatusMessage "Uninstalling the $installTitle. Please Wait..."

		##*===============================================
		##* UNINSTALLATION
		##*===============================================
		[string]$installPhase = 'Uninstallation'

        ## Uninstall Any Existing Versions of Microsoft System CLR Types for SQL Server 2012
        Remove-MSIApplications -Name 'Microsoft System CLR Types for SQL Server 2012'

		##*===============================================
		##* POST-UNINSTALLATION
		##*===============================================
		[string]$installPhase = 'Post-Uninstallation'


	}
	ElseIf ($deploymentType -ieq 'Repair')
	{
		##*===============================================
		##* PRE-REPAIR
		##*===============================================
		[string]$installPhase = 'Pre-Repair'


		##*===============================================
		##* REPAIR
		##*===============================================
		[string]$installPhase = 'Repair'


		##*===============================================
		##* POST-REPAIR
		##*===============================================
		[string]$installPhase = 'Post-Repair'


    }
	##*===============================================
	##* END SCRIPT BODY
	##*===============================================

	## Call the Exit-Script function to perform final cleanup operations
	Exit-Script -ExitCode $mainExitCode
}
Catch {
	[int32]$mainExitCode = 60001
	[string]$mainErrorMessage = "$(Resolve-Error)"
	Write-Log -Message $mainErrorMessage -Severity 3 -Source $deployAppScriptFriendlyName
	Show-DialogBox -Text $mainErrorMessage -Icon 'Stop'
	Exit-Script -ExitCode $mainExitCode
}

Ok, all the hard work is done and now you can install or uninstall Microsoft System CLR Types for SQL Server 2012 using one single PowerShell script. Simply change the DeploymentType parameter to install or uninstall. Logging functionality is built-in automatically and you can view the log files under “C:\Windows\Logs\Software”.

Microsoft System CLR Types for SQL Server 2012 NonInteractive Install (PowerShell)

NonInteractive means Very Silent, i.e. no blocking apps. This is automatically set if it is detected that the process is not running in the user session and it is not possible for anyone to provide input using a mouse or keyboard.

• Open Windows PowerShell by Right-Clicking on Windows PowerShell and selecting Run as Administrator
• Change the directory to “C:\Downloads\SQLSysClrTypes2012”
  • PS C:\Downloads\SQLSysClrTypes2012>
• Enter the following command:

Powershell.exe -ExecutionPolicy Bypass .\Deploy-SQLSysClrTypes2012.ps1 -DeploymentType "Install" -DeployMode "NonInteractive"

Microsoft System CLR Types for SQL Server 2012 Silent Install (PowerShell)

Silent means no dialogs (progress and balloon tip notifications are suppressed).

• Open Windows PowerShell by Right-Clicking on Windows PowerShell and selecting Run as Administrator
• Change the directory to “C:\Downloads\SQLSysClrTypes2012“
  • PS C:\Downloads\SQLSysClrTypes2012>
• Enter the following command:

Powershell.exe -ExecutionPolicy Bypass .\Deploy-SQLSysClrTypes2012.ps1 -DeploymentType "Install" -DeployMode "Silent"

Microsoft System CLR Types for SQL Server 2012 Interactive Install (PowerShell)

Interactive means the install will show dialogs including progress and balloon tip notifications.

• Open Windows PowerShell by Right-Clicking on Windows PowerShell and selecting Run as Administrator
• Change the directory to “C:\Downloads\SQLSysClrTypes2012”
  • PS C:\Downloads\SQLSysClrTypes2012>
• Enter the following command:

Powershell.exe -ExecutionPolicy Bypass .\Deploy-SQLSysClrTypes2012.ps1 -DeploymentType "Install" -DeployMode "Interactive"

How to Uninstall Microsoft System CLR Types for SQL Server 2012 Using the PowerShell App Deployment Toolkit

Microsoft System CLR Types for SQL Server 2012 NonInteractive Uninstall (PowerShell)

NonInteractive means Very Silent, i.e. no blocking apps. This is automatically set if it is detected that the process is not running in the user session and it is not possible for anyone to provide input using a mouse or keyboard.

• Open Windows PowerShell by Right-Clicking on Windows PowerShell and selecting Run as Administrator
• Change the directory to “C:\Downloads\SQLSysClrTypes2012“
  • PS C:\Downloads\SQLSysClrTypes2012>
• Enter the following command:

Powershell.exe -ExecutionPolicy Bypass .\Deploy-SQLSysClrTypes2012.ps1 -DeploymentType "Uninstall" -DeployMode "NonInteractive"

Microsoft System CLR Types for SQL Server 2012 Silent Uninstall (PowerShell)

Silent means no dialogs (progress and balloon tip notifications are suppressed).

• Open Windows PowerShell by Right-Clicking on Windows PowerShell and selecting Run as Administrator
• Change the directory to “C:\Downloads\SQLSysClrTypes2012“
  • PS C:\Downloads\SQLSysClrTypes2012>
• Enter the following command:

Powershell.exe -ExecutionPolicy Bypass .\Deploy-SQLSysClrTypes2012.ps1 -DeploymentType "Uninstall" -DeployMode "Silent"

Microsoft System CLR Types for SQL Server 2012 Interactive Uninstall (PowerShell)

Interactive means the install will show dialogs including progress and balloon tip notifications.

• Open Windows PowerShell by Right-Clicking on Windows PowerShell and selecting Run as Administrator
• Change the directory to “C:\Downloads\SQLSysClrTypes2012“
  • PS C:\Downloads\SQLSysClrTypes2012>
• Enter the following command:

Powershell.exe -ExecutionPolicy Bypass .\Deploy-SQLSysClrTypes2012.ps1 -DeploymentType "Uninstall" -DeployMode "Interactive"

Always make sure to test everything in a development environment prior to implementing anything into production. The information in this article is provided “As Is” without warranty of any kind.

If you’re looking to get Microsoft System CLR Types for SQL Server 2012 up and running on your system, you’re in the right place. Essentially, these types are part of the SQL Server Feature Pack, and they’re necessary for running certain applications that connect to SQL Server. In this article, we’ll walk through the steps to download and install these types, as well as provide some useful tips and answer common questions.

Step by Step Tutorial: Installing Microsoft System CLR Types for SQL Server 2012

Before diving into the steps, let’s quickly talk about what we’ll be doing. We’ll be downloading the necessary files from the Microsoft website and then going through the installation process. It’s pretty straightforward, but important to get right.

Step 1: Visit the Microsoft Download Center

Start by visiting the Microsoft Download Center.

Once there, you’ll need to search for «Microsoft System CLR Types for SQL Server 2012» to find the right download page. Make sure you’re getting it from the official Microsoft website to avoid any security risks.

Step 2: Download the Appropriate Files

Next, download the files that match your system’s architecture (32-bit or 64-bit).

Be sure to choose the correct version that matches your system’s architecture. If you’re unsure whether your system is 32-bit or 64-bit, you can check in the System Information on your computer.

Step 3: Run the Installer

Once the download is complete, run the installer to install the CLR Types.

Follow the prompts in the installation wizard. It should be a standard installation process, accepting the license terms and selecting the installation directory if necessary.

Step 4: Complete the Installation

Finish the installation and close the installer once it’s done.

You won’t see any fancy fireworks when the installation completes, but it’s an essential part of ensuring that certain applications can run smoothly on your system.

After you’ve completed the installation, any applications that require these CLR Types should be able to run without issues. If you were previously experiencing errors or issues related to these types, those should be resolved.

Tips for Working with Microsoft System CLR Types for SQL Server 2012

1. Always download software from official sources to avoid malware or other security issues.
2. If you’re unsure about your system architecture, check your system information before downloading files.
3. Restart your computer after the installation to ensure that all changes take effect.
4. Keep your system updated to avoid compatibility issues with applications that use the CLR Types.
5. If you encounter issues after the installation, check that the CLR Types are correctly installed and consider consulting Microsoft support.

Frequently Asked Questions

What are Microsoft System CLR Types for SQL Server 2012?

These are components that allow applications to read SQL Server data types.

Do I need to install these types for every version of SQL Server?

Yes, each version of SQL Server has its own CLR Types package that should be installed.

Can I install the 32-bit version on a 64-bit system?

It’s recommended to match the CLR Types to your system’s architecture for the best compatibility.

What should I do if I encounter errors during installation?

Make sure that you’re downloading the installer from the official Microsoft site and that your system meets the requirements.

Are there any other components I need to install with the CLR Types?

It depends on the application you’re running, but some might require additional components from the SQL Server Feature Pack.

Summary

1. Visit the Microsoft Download Center.
2. Download the appropriate files.
3. Run the installer.
4. Complete the installation.

Conclusion

In conclusion, getting the Microsoft System CLR Types for SQL Server 2012 installed on your system is a crucial step for ensuring smooth operation of various applications. The process is simple and only requires a few steps: visiting the Microsoft Download Center, downloading the appropriate files, running the installer, and completing the installation. Once installed, these components enable applications to correctly process SQL Server data types, preventing potential errors and compatibility issues.

Additionally, always remember to download software from trusted sources, match the software version to your system’s architecture, and keep your system updated. If you run into any issues, restart your computer and check that the installation was successful. If problems persist, don’t hesitate to reach out to Microsoft’s support for assistance.

By following this guide and keeping the provided tips in mind, you should have no trouble managing Microsoft System CLR Types for SQL Server 2012 and any applications that depend on them. Happy computing!