Why is SSRS Report Subscription - Shared Schedule dropdown unsorted?
When when creating/changing a SSRS Report Subscription at the point where we need to select a Shared Schedule from the available list, the dropdown that opens is Unsorted and would be nice to have them sorted the same way that they are when Schedules are…
![](https://techprofile.blob.core.windows.net/images/LaMnhm6dYUm819lrFKr8rA.png?8D834F)
SSPI Error when connecting from Intune Managed AVD to SQL Host using SSMS
Hi All, I have a problem when trying to connect to a SQL Server using SSMS via an Entra joined and Intune Managed AVD. The SQL host is in an AD DS where accounts are synced to Entra AD. The error I get is : The target principal name is incorrect. …
![](https://techprofile.blob.core.windows.net/images/J-cKqdzNMkWeJv8idBgCcQ.png?8DC812)
Issue with SQL Server compatibility level 2022 and sp_executesql
One of our customers running SQL standard edition 2022 wanted to explore setting their database's compatibility level to 2022; but when they do this, at least one of our queries fails to return metadata. So they have to keep the compatibility level at…
![](https://techprofile.blob.core.windows.net/images/J-cKqdzNMkWeJv8idBgCcQ.png?8DC812)
SSMA - Convert adhoc DML and DDL queries
Hello, Does Microsoft SQL Server Migration Assistant (SSMA) provide a way to convert an ah-doc DML or DDL query from DB2 z/OS syntax to MS SQL Server? By other means, I have an application that today has queries that execute on a DB2 z/OS and after the…
![](https://techprofile.blob.core.windows.net/images/YC3KiAudCk6A0I6NB9vOyA.png?8DA953)
How can I find my SQL server License to upgrade Report Server Configuration Manager
Our version of Report Server Config Manager is on Evaluation. We license an Azure sql server from Office365 but I cannot find the license key. I need to upgrade the RSCM but it's requiring a key.
![](https://techprofile.blob.core.windows.net/images/J-cKqdzNMkWeJv8idBgCcQ.png?8DC812)
OS and SQL server upgrade
What could be the best upgrade plan for MS SQL server 2012 and Windows server 2012?
![](https://techprofile.blob.core.windows.net/images/J-cKqdzNMkWeJv8idBgCcQ.png?8DC812)
Resource Governor questions.
https://www.sqlshack.com/sql-server-2014-resource-governor/ Greetings. I'm using the link above to configure Resource Governor. I run some queries to max out the RAM usage but my PerfMon counters dont elevate the way theirs do. I can see RAM usage…
![](https://techprofile.blob.core.windows.net/images/J-cKqdzNMkWeJv8idBgCcQ.png?8DC812)
Cannot uninstall SQL Server Integration Services Projects after VS version 16.0.0 (offline) update
Hi MS, We got a Visual Studio version 16.0.0 (Offline) and SQL Server Integration Services Projects installed. I updated VS to version 16.11.0 from an offline layout. I moved on to trying to update the SQL Server Integration Services Projects version…
Lift and Shift SQL server database backups on Azure
HI, Can we schedule daily database backups on Azure portal for lift and shift SQL server which is in AZURE. Thank you
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
Microsoft Applied Skill 4 - Failure to create Databases 1-4
While attempting the "Migrate SQL Server Workloads to Azure SQL Database" it failed to create Databases: DB1, DB2, DB3, and DB4. While DB5 was a partial. Has anyone else had this happen to them? What steps have you taken to resolve this…
Azure - SQL Server on VM: backup DBs directly to blob storage RAGZRS
I'm managing AG of 4 nodes in AZ VMs. SQL Server version is 2016 CU19, largest DB is ~2 TB. Right now we are using Ola Hallengren's scripts with options as below: @MaxTransferSize = 4194304 @NumberOfFiles = 5 (or 10) And backing up to blob…
Azure Synapse "Message Type Not Found" error when running stored procedure: Appears when lines of code reach certain line length
Hi, We need some technical guidance from either a Azure Synapse specialist to resolve an issue which we are unable to understand / fix despite running through the sql logic bit-by-bit, line-by-line. Any guidance or help would be much appreciated. We have…
What to do about "window.$RSjQuery is not a function" in Reserved.ReportViewerWebControl.axd
I inherited an ASP.NET Web Forms project that uses RDLC. It was using the Microsoft.ReportViewer 11.0.3366.16 NuGet package and my task has been to upgrade it to the Microsoft.ReportingServices.ReportViewerControl.WebForms 150.1652.0 NuGet. By…
Installing IBMi Access Driver on Azure Data Factory Integration Runtime
Hello, I've been trying to install the Windows version of the IBM i Access Driver on a Data Factory Integration Runtime through adding a script (main.cmd) and the desired installer in a Blob Container This script seems to work perfectly locally but when…
How to cleanup Python directories Launchpad service
I have installed the Python 3.7 machine learning feature in SQL Server but the memory growth is huge after executing several Python scripts. When you execute a SQL job with a python statement the launchpad creates folders in the…
How to access database by External Datasource using Service Principal Name(SPN)
I am seeking a solution for cross-database access via an external data source using Service Principal credentials. Specifically, I want to perform Transact-SQL queries from one database to another using Service Principal credentials. To achieve this, I…
Analysis Services reads data from a data source, but gives connection error while processing multidimensional analysis
I have built an Analysis Services Multidimensional project using Microsoft Visual Studio Professional 2022 with the SQL Server Analysis Services 16.0 extension connected to Analysis Services on a remote SQL Server 2019 instance. The Visual Studio…
Customer Best Practices Assessment: exclude checks/false positives
Is there any way to customize the BPA in Azure ARC for SQL to exclude certain checks or to flag issues as false positives? I've got certain issues being flagged by the BPA however these can't be resolved as the application accessing the database requires…
Failed to Create Maintenance Plan in SQL Server 2019 show Exception from HRESULT: 0xC0014001 (Microsoft.SqlServer.DTSRuntimeWrap)
Hi, I have been trying to create maintenance plan using maintenance plan wizard in SSMS. As i go through the plan, the prompt show error 'Saving maintenance plan failed' with Exception from HRESULT: 0xC0014001 (Microsoft.SqlServer.DTSRuntimeWrap). The…
![](https://techprofile.blob.core.windows.net/images/J-cKqdzNMkWeJv8idBgCcQ.png?8DC812)
How to create Excel Connection to a SQL database
This connection must be validated by a SQL login to ensure the contents of your databases remain secure. The connection can be refreshed to update the content from the SQL database.
![](https://techprofile.blob.core.windows.net/images/J-cKqdzNMkWeJv8idBgCcQ.png?8DC812)