How to fix SSRS issues when running them on Windows 11?
SSRS reports that had been running on Windows 10 are not running on Windows 11. Kerberos authentication issues.
SQL Server Reporting Services
Analysis Services Processing Task: Error A connection cannot be made
Hi, We are executing an SSIS package.. it fails with the below error Analysis Services Processing Task: Error A connection cannot be made. Ensure that the server is running. We have a separate SSAS instance on this server which is up and running.…
SQL Server Analysis Services
Polybase accessing s3 storage error - Content of the directory cannot be listed
I have the following script for accessing on-prem S3-compatible storage. CREATE DATABASE SCOPED CREDENTIAL s3 WITH IDENTITY = 'S3 Access Key', SECRET = '****:****' ; END GO CREATE EXTERNAL DATA SOURCE ds_s3 WITH ( LOCATION =…
SQL Server
Unable to install SQL server. Error code : -2068119551
I keep fail to install the SQL server. I have already tried using Basic and Media which is ISO. When i used ISO, the error is -The MOF compiler could not connect with the WMI server. This is either because of a semantic error such as an…
SQL Server Database Engine
Problem upgrading encryption for multidimensional analysis services database in SQL 2022
I am migrating 2 analysis services databases that are in multidimensional mode from a 2017 instance to a 2022 instance that has had the CU1 update applied. I need to upgrade the encryption on these DBs so i can amend the connection string. This article…
SQL Server
SQL Server
SQL Server Analysis Services
SQL Server Analysis Services
Problem upgrading encryption for multidimensional analysis services database in SQL 2022
I am migrating 2 analysis services databases that are in multidimensional mode from a 2017 instance to a 2022 instance that has had the CU1 update applied. I need to upgrade the encryption on these DBs so i can amend the connection string. This article…
SQL Server
SQL Server
SQL Server Analysis Services
SQL Server Analysis Services
How to fix SQL Server Setup has encountered the following error: Failed to retrieve data for this request..
I'm trying to patch SQL Server 2019 in a clustered environment. The setup is failing with this error: Setup has encountered the following error: Failed to retrieve data for Summary.txtthis request..Detail.txt
SQL Server Database Engine
Why TUF file is required in Log shipping when uncommitted transactions are already in memory?
I know that while restoring the log backup, un-committed transactions will be recorded to the undo file and only committed transactions will be written to disk there by making users to read the database. When we restore next Tlog backup SQL server will…
SQL Server
Issue to restore the schema
Dear all, How to resolve it below? Exclusive access could not be obtained because the database is in use. I ran the following USE db_to_restore go ALTER DATABASE db_to_restore SET SINGLE_USER WITH ROLLBACK IMMEDIATE go but it…
SQL Server Database Engine
I need to find a missing report
I'm searching for a report for one of our specialists on 04/07/25 who is no longer with TD as of this month. However the specialist name is no longer listed under the team manager for TD bank. I've left a comment but I have no idea who it goes to our…
SQL Server Reporting Services

Third party backup tools for SQL server
Anyone please share a few names of good and faster backup tools for SQL server? Preferably a snapshot of physical file backup It is for stand-alone server and should support VM too.
SQL Server Database Engine

Sql Server to Excel
Hi Trying to export data from sql server to a Table formated excel. But after the data insert the Format of excel not coming properly. I mean the odd and even rows with different color Thanks
SQL Server Transact-SQL

SQL Server Management Studio 18 - Maintenance Plan
I have setup SQL backups to run daily at midnight for 5 servers, all works fine except 1 server does not run/create backup files. No errors or logs just does not run and not sure why. Any suggestions? Thanks! David
SQL Server Transact-SQL

Can I do an SQL Server Edition upgrade from Express to Developer on Azure VM?
I'm trying to upgrade an SQL Express database that comes with an application to SQL Developer edition. The machine is an Azure VM, not Azure SQL server instance. The application is Best Practice, a medical practice management software. The base…
SQL Server Migration Assistant

MDS migration - No data in the mdm view MasterDataServices
Hi , I migrated a model of Master Data Services using MDSModelDeploy.exe createpackage -package "C:\temp\pck.pkg" -model "Product" -service MDS1 -includedata -version VERSION_1 and MDSModelDeploy.exe deploynew -package…
SQL Server Database Engine
SQL Elastic Pool Stuck on Scaling for 22 Hours
For performance testing I've scaled my SQL Elastic Pool from: General Purpose - 18 vCores - 2TB Storage to Business Critical - 128 vCores - 3TB Storage The main database in the pool has between 1TB to 1.5TB of data in, the rest have under 100GB and the…
SQL Server Database Engine
PDF Export with a custom font giving the error "Cannont find or create the font 'xyz,Bold'."
I've ran into an issue I have never seen before, maybe somebody could help before I pull my hair out any more. We've got some reports we did for a customer in SSRS. They work fine and render fine. Recently the customer gave us a custom font their…
SQL Server Reporting Services
SSIS Execute SQL Task Error on Variable
I'm selecting a Number(38,0) data type field from an Oracle table and am attempting to pass the value returned from that Oracle select statement into an Int64 type variable in Visual Studio. The query I'm using is select max(<field_name>) from…
SQL Server Integration Services
SQL Server error code 4014 on Linux
Hi there! I'm getting an error 4014, severity 20, state 10 error in my SQL Server error log. It seems to happen at random intervals. This is for a SQL Server 2022 instance running on Red Hat Enterprise Linux 9.5. The client is making a connection using…
SQL Server Database Engine
While upgrading SQL server showing mentioned error all settings and bit are same.
While upgrading SQL server showing mentioned error all settings and bit are same urgent