20,384 questions with SQL Server-related tags

Sort by: Updated
1 answer

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
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,042 questions
asked 2025-05-02T21:27:00.1733333+00:00
Sleight, Jeannette 0 Reputation points
answered 2025-05-02T22:10:23.88+00:00
Sleight, Jeannette 0 Reputation points
5 answers One of the answers was accepted by the question author.

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
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,339 questions
asked 2024-09-03T04:30:09.63+00:00
Bilal H. Bhatt 136 Reputation points
commented 2025-05-02T21:54:39.98+00:00
Gary Melhaff - US 6 Reputation points
1 answer

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 questions
asked 2024-08-14T00:24:25.8666667+00:00
Haijin Li 21 Reputation points
commented 2025-05-02T18:54:34.21+00:00
Punit R 0 Reputation points
0 answers

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
asked 2025-05-02T17:11:52.83+00:00
Blaze 0 Reputation points
1 answer

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
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,339 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,339 questions
asked 2023-08-09T11:11:35.6666667+00:00
Jim Dale 15 Reputation points
commented 2025-05-02T16:09:13.2066667+00:00
Céline Rodríguez 16 Reputation points
1 answer

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
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,339 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,339 questions
asked 2023-08-09T11:11:35.6666667+00:00
Jim Dale 15 Reputation points
commented 2025-05-02T16:09:13.2066667+00:00
Céline Rodríguez 16 Reputation points
1 answer

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
asked 2025-05-02T08:55:59.86+00:00
Talent Mabuto 0 Reputation points
answered 2025-05-02T10:01:10.67+00:00
Alban Berisha 80 Reputation points
2 answers One of the answers was accepted by the question author.

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 questions
asked 2023-04-10T14:18:55.13+00:00
Chirag Sachdeva 281 Reputation points
commented 2025-05-02T07:35:20.0533333+00:00
YaragoppaSunil-3326 0 Reputation points
1 answer

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
asked 2025-04-25T03:14:41.97+00:00
Peter_1985 2,731 Reputation points
edited a comment 2025-05-02T06:48:40.9333333+00:00
Peter_1985 2,731 Reputation points
1 answer

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
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,042 questions
asked 2025-04-29T12:38:40.2833333+00:00
Gordon, Cliff (he/him/his) 0 Reputation points
commented 2025-05-02T05:52:30.48+00:00
Olaf Helper 46,631 Reputation points
1 answer

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
asked 2025-04-24T18:18:03.1466667+00:00
Asharaf Pattarathil 0 Reputation points
commented 2025-05-02T05:48:02.1333333+00:00
Olaf Helper 46,631 Reputation points
1 answer

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 Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
177 questions
asked 2025-05-01T10:49:51.06+00:00
SVA 116 Reputation points
answered 2025-05-02T05:44:35.3033333+00:00
Olaf Helper 46,631 Reputation points
1 answer

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
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
177 questions
asked 2025-05-01T12:56:03.21+00:00
Chun, David 0 Reputation points
answered 2025-05-02T05:42:54.2466667+00:00
Olaf Helper 46,631 Reputation points
1 answer

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
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
564 questions
asked 2025-05-01T23:21:26.8166667+00:00
Melchor Buenaflor Admin 0 Reputation points
answered 2025-05-02T05:39:43.66+00:00
Olaf Helper 46,631 Reputation points
0 answers

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
asked 2025-05-01T09:43:27.76+00:00
Maneesh Murali 0 Reputation points
edited the question 2025-05-01T10:15:07.23+00:00
simo-k 7,810 Reputation points
0 answers

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
asked 2025-05-01T08:11:05.06+00:00
Finlay 0 Reputation points
edited the question 2025-05-01T08:12:24.6433333+00:00
Finlay 0 Reputation points
0 answers

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
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,042 questions
asked 2025-04-30T21:12:59.78+00:00
Ryan Brothers 0 Reputation points
1 answer

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 Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,681 questions
asked 2025-04-29T23:21:53.8833333+00:00
Kristie A 0 Reputation points
answered 2025-04-30T20:20:29.22+00:00
Michael Taylor 58,696 Reputation points
1 answer

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
asked 2025-04-29T16:04:17.6766667+00:00
Tim Coleman 0 Reputation points
commented 2025-04-30T15:17:33.2433333+00:00
Tim Coleman 0 Reputation points
3 answers One of the answers was accepted by the question author.

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

SQL Server Database Engine
asked 2025-04-27T10:36:04.7566667+00:00
Anandhswarupp 165 Reputation points
accepted 2025-04-30T11:02:15.8366667+00:00
Anandhswarupp 165 Reputation points