Azure Synapse Storage Event Trigger : Activate/Publish error

Failed to activate

Failed to activate Storage Trigger (Trigger).

Issue: Event Grid Resource provider not registered.

After registering Event Grid resource, trigger activated successfully.

Data Factory Pipeline - Schema import failed

 "Schema import failed: The interactive authoring capability is not enabled on the integration runtime 'AutoResolveIntegrationRuntime'. Please enable interactive authoring first and retry the operation."

Go to Data Factory -> Manage -> Integration Runtimes -> AutoResolveIntegrationRuntime

Enable the interactive authoring.

Interactive authoring capability is used during authoring for functionalities like Test connection /Browse and Preview data / Import parameter / Import schema inside managed Virtual Network.

When enabled, the interactive authoring capability for this VNet integration runtime will disabled after the specified time interval of inactivity (i.e., no interactive commands).

Power BI App workspace creation is disabled

App workspace creation is disabled

Creation of app workspaces is disabled by your tenant admin, or you need permissions to create them. Please contact your tenant admin.

To enable the workspace creation, go to PowerBI Admin portal -> Tenant Settings -> Workspace Settings and enable settings. This option can be restricted to specific AD groups.

Copy Data from On-Prem to Azure Blob via SSIS failed with TLS error

Copy Data from On-Prem to Azure Blob via SSIS using Feature pack for Azure failed with TLS error:

Error:

Microsoft.DataTransfer.ClientLibrary.BinaryTransfer.Run(),''Type=Microsoft.WindowsAzure.Storage.StorageException,Message=The remote server returned an error: (400) Bad Request.,Source=Microsoft.WindowsAzure.Storage,StorageExtendedMessage=The TLS version of the connection is not permitted on this storage account.

Solution as per Microsoft:

Use TLS 1.2

The TLS version used by Azure Feature Pack follows system .NET Framework settings. To use TLS 1.2, add a REG_DWORD value named SchUseStrongCrypto with data 1 under the following two registry keys.

HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\.NETFramework\v4.0.30319
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETFramework\v4.0.30319

Ref: https://docs.microsoft.com/en-us/sql/integration-services/azure-feature-pack-for-integration-services-ssis?view=sql-server-ver15#use-tls-12

SQL 2017 Installation stuck at Install_VSTA2015

SQL 2017 Installation stuck at "Install_VSTA2015_LangSupport_Cpu32_Action"

 

Log file (C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log):

 

Fix:

Run the below command from PowerShell, so the msiserver service will restart automatically

taskkill /F /FI "SERVICES eq msiserver"

PowerShell script to extract Windows Application Pool details

 $sb = {  Import-Module WebAdministration

         $webapps = Get-WebApplication

$list = @()

foreach ($webapp in get-childitem IIS:\AppPools\)

{

$name = "IIS:\AppPools\" + $webapp.name

$item = @{}

$item.server = $env:COMPUTERNAME

$item.WebAppName = $webapp.name

$item.Version = (Get-ItemProperty $name managedRuntimeVersion).Value

$item.State = (Get-WebAppPoolState -Name $webapp.name).Value

$item.UserIdentityType = $webapp.processModel.identityType

$item.Username = $webapp.processModel.userName

$obj = New-Object PSObject -Property $item

$list += $obj

}

$list | Select-object -Property  "server","WebAppName", "Version", "State", "UserIdentityType", "Username" 

}

$computers = Get-Content "C:\serverlist.txt"

foreach ($computer in $computers)  {

$computer

Invoke-command -ComputerName $computer -ScriptBlock $sb | export-csv C:\webAppPool_details.csv -append -NoTypeInformation

}