21,172 questions with SQL Server-related tags

Sort by: Updated
1 answer

SQL Server 2025 Public Preview Maintenance Wizard plan runtime error

2 issues with Maintenance Plans - for some reason now I cant modify or create any new Maint Plans. Not available and greyed out. When creating any Maintenance wizard plans such as "Misc Cleanup" or DB "Integrity check" scans I am…

SQL Server Database Engine
asked 2025-07-01T20:39:25.7266667+00:00
Shervey, Jeff 1 Reputation point
commented 2025-12-13T17:20:51.4066667+00:00
Shervey, Jeff 1 Reputation point
1 answer

Ag listener fail to offline in 2 node always on without AD

Let me describe my env first: Two nodes always on without domain (with witness share file) Both node is sql server 2022 and windows server 2022 Both nodes are in the same subnet Set DNS server for these two nodes Didn’t register A record in DNS …

SQL Server Database Engine
asked 2025-12-13T12:33:30.07+00:00
Kelvin Yu 0 Reputation points
edited the question 2025-12-13T12:38:21.43+00:00
Kelvin Yu 0 Reputation points
3 answers

SSIS won't install for VS 2022

SSIS won't install for Visual Studio 2022 Enterprise. I keep getting an error message that the help says means it found another installer running. I completely uninstall VS, rebooted, installed enterprise edition, rebooted, and then brought up task…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,760 questions
asked 2024-08-02T19:30:31.07+00:00
Scott-3123 21 Reputation points
edited a comment 2025-12-12T19:29:51.36+00:00
Jairo 0 Reputation points
2 answers

i noticed the sqlhealth extende event is on by default , so can i reduce

hi, i noticed the sqlhealth extended event is on by default , and it logs many thing, Q1) can i reduce few thing so that file size and recording that is wirting from buffer to file can be reduced, thus i will save some resources. q2) and can i add few…

SQL Server Database Engine
asked 2025-12-12T12:06:09.9233333+00:00
Rajesh Kumar Yadav 20 Reputation points
answered 2025-12-12T19:06:53.2333333+00:00
Erland Sommarskog 128.9K Reputation points MVP Volunteer Moderator
2 answers

Link https://go.microsoft.com/fwlink/?linkid=2216019 changed installer?

Hi, For years whe have used a script to download and install SQL 2022 EXPRESS. The link we used to download the SQL 2022 installer is https://go.microsoft.com/fwlink/?linkid=2216019 But recently the link suddenly points to a SQL 2025 Express…

SQL Server | Other
asked 2025-12-12T12:56:07.7066667+00:00
Jens Schumacher 0 Reputation points
answered 2025-12-12T19:02:31.6666667+00:00
Erland Sommarskog 128.9K Reputation points MVP Volunteer Moderator
1 answer One of the answers was accepted by the question author.

Installing Self Hosted Integration Runtime on a On Premise Database without internet access to

The system on which the database is hosted is not having internet connection. We want to connect to that database from ADF to pull the data. Please provide us the steps to install and configure the node in self hosted integration runtime.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,995 questions
SQL Server | Other
asked 2024-01-12T09:57:22.9866667+00:00
Sundar Sriram Garimella 156 Reputation points
accepted 2025-12-12T16:52:38.14+00:00
Sundar Sriram Garimella 156 Reputation points
1 answer One of the answers was accepted by the question author.

Unreliable Microsoft.ACE.OLEDB.12.0. Excel import works sometimes

Hello I have a query that works all the time, 100 % success. I have a second one, with a different Excel file, that works the first 2 or 3 times I run it in a row. After that, the next run will run indefinitely and any other attempt at running any…

SQL Server Database Engine
asked 2025-08-19T15:45:03.6166667+00:00
VicVP 20 Reputation points
accepted 2025-12-12T15:25:01.75+00:00
VicVP 20 Reputation points
2 answers One of the answers was accepted by the question author.

Can I install SQL 2008R2 on server with TLS1.2 or higher enabled

Hello, I have a requirement to upgrade SQL 2000 databases. I am thinking to install SQL 2008R2 , restore SQL 2000 backup file on SQL 2008R2, upgrade database ( provided it goes through). If successful, i will upgrade it further to SQL 2016 or SQL 2019,…

SQL Server Database Engine
asked 2025-12-02T16:24:47.6533333+00:00
Mudit Gupta 121 Reputation points
commented 2025-12-12T15:08:52.09+00:00
Mudit Gupta 121 Reputation points
3 answers One of the answers was accepted by the question author.

In Memory OLTP Table's indexes not releasing memory for deleted records

We have a small (logical size about 6GB) OLTP database. In it we have several work tables that during processing get filled with about 100,000+ rows. Once the calculation is complete the records are no longer needed and the data is purged. However the…

SQL Server | Other
asked 2024-07-31T20:23:03.66+00:00
James Southward 25 Reputation points
answered 2025-12-12T13:57:32.6833333+00:00
James Cook 0 Reputation points
1 answer

SQL Server Agent not starting after installing KB5071544

My SQL Server Agent service does not start after a reboot of the server to complete installation of KB5071544. Event logg shows ID 7000, stating timeout occured. I tried increasing the tme out to 5 mins but no change. I am running SQL server 2019…

SQL Server | Other
asked 2025-12-11T19:18:14.1566667+00:00
Abraham Libu Varghese 0 Reputation points
commented 2025-12-12T13:53:48.9733333+00:00
Erland Sommarskog 128.9K Reputation points MVP Volunteer Moderator
3 answers

SQL Server 2022 vs 2019 Query Performance gap

I am facing a performance issue with an SQL query. The query is generated dynamically via the webapp, I am testing with a static version to make things simpler. The SQL query includes temp tables and columns which get their values recalculated with…

SQL Server Database Engine
asked 2025-08-13T13:50:03.2533333+00:00
Alex Kipritsis 1 Reputation point
commented 2025-12-12T13:27:56.99+00:00
Alex Kipritsis 1 Reputation point
2 answers

Trouble configuring SQL Server Always On

I have created an AD setup. Joined two sql vms(primary and secondary) into that AD. I have then installed failover clustering on both the sql nodes, and created a cluster. Then I have enabled SQL Server Always On Availability Groups. Next, while…

SQL Server Database Engine
asked 2025-12-08T13:21:50.4033333+00:00
Sree Harshita Maddala 0 Reputation points
edited an answer 2025-12-12T11:52:44.1266667+00:00
Shruti Dhruv 405 Reputation points Microsoft External Staff Moderator
2 answers

Why is run now not showing for SSRS subscriptions

I don't have the option to run now on my subscriptions.

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,121 questions
asked 2025-12-08T18:43:32.6466667+00:00
Rhonda Norrid 0 Reputation points
commented 2025-12-12T11:51:01.2333333+00:00
Lakshmi Narayana Garikapati 650 Reputation points Microsoft External Staff Moderator
2 answers

where can I download report builder for mac or linux (arm 64)

I am looking for installation binary or the like. Even an APT or Cask command.

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,121 questions
asked 2025-12-11T17:04:32.9733333+00:00
Eric Rosenblum 0 Reputation points
answered 2025-12-12T11:49:48.0966667+00:00
Shruti Dhruv 405 Reputation points Microsoft External Staff Moderator
2 answers

Issue with SSRS Reports Portal after migration from 2016 to 2022

We have recently migrated from SSRS 2016 to SSRS 2022. The installation of SSRS 2022 has been done. ReportServer is working fine but Reports portal is throwing error "Exception: System.Web.HttpException (0x80004005): Unable to validate data."…

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,121 questions
asked 2025-12-09T21:36:46.1466667+00:00
MANDAL Suryani 0 Reputation points
answered 2025-12-12T11:43:26.5733333+00:00
Shruti Dhruv 405 Reputation points Microsoft External Staff Moderator
1 answer

begin stack dump error no sql server 2012

Tenho um micro com Windows Server 2008 R2 enterprise com o SQL Server 2012. Este vem apresentando falha. No Event Viewer aparece esta mensagem: The SQL Server (MSSQLSERVER) service terminated unexpectedly. It has done this 8 time(s). No log do SQL, no…

SQL Server Database Engine
asked 2025-12-03T10:51:55.7+00:00
commented 2025-12-12T11:10:27+00:00
Shruti Dhruv 405 Reputation points Microsoft External Staff Moderator
1 answer

Catalog max connection pool size: 100

Seeing this message repeated every 10 seconds in the RSHostingService_yyyy_mm_dd_hh_mm_ss.log file. Can anyone advise: a) Why this is being reported so frequently? b) Does it indicate the limit is being hit? c) If b is true, how can I increase…

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,121 questions
asked 2025-12-04T13:43:34.7033333+00:00
Peter Bishop 231 Reputation points
edited a comment 2025-12-12T11:05:42.6566667+00:00
Shruti Dhruv 405 Reputation points Microsoft External Staff Moderator
4 answers

SQL Configuration step issue in Ubuntu Instance

While configuring SQL Server for the first time on Ubuntu_22.04-x86_64-SQL_2022_Standard-2025.08.28, I encountered an error that occurs frequently. I need to retry the setup 2–3 times before it works properly. Any Solution to fix this part? ++ bash -c…

SQL Server Database Engine
asked 2025-12-04T05:16:29.8166667+00:00
Pratik Narottam Panchal 0 Reputation points
commented 2025-12-12T10:50:38.8866667+00:00
Shruti Dhruv 405 Reputation points Microsoft External Staff Moderator
2 answers

Is there a changelog/release notes for MS Report Builder?

Is there a changelog/release notes for MS Report Builder? Note: This is not Power BI Report Builder. I couldn't find a separate forum for MS Report Builder, but knew that the product was associated with SSRS. FYI, the download link for the product I…

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,121 questions
asked 2025-12-05T20:53:51.71+00:00
NK 1 Reputation point
commented 2025-12-12T10:48:01.2166667+00:00
Shruti Dhruv 405 Reputation points Microsoft External Staff Moderator
2 answers

Wait on the Database Engine recovery handle failed

Overall summary: Final result: Failed: see details below Exit code (Decimal): -2061893606 Start time: 2025-12-07 16:55:50 End time: 2025-12-07 16:59:41 Requested action: …

SQL Server Database Engine
asked 2025-12-07T11:39:56.8733333+00:00
Zapadiya, Prahlad 0 Reputation points
commented 2025-12-12T10:45:53.7+00:00
Shruti Dhruv 405 Reputation points Microsoft External Staff Moderator