536 questions
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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 31%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
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
536 questions
asked 2025-12-02T16:24:47.6533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 34%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMG%3C/text%3E%3C/svg%3E)
Mudit Gupta
101
Reputation points
commented 2025-12-12T15:08:52.09+00:00
Mudit Gupta
101
Reputation points
1 answer
I have deleted a SQL server that needs to be recovered
I have deleted a SQL Server because of redeployment. Before doing the redeployment I have exported the databases to BACPAC files in a storage account, but now it turns out there's no data in these bacpac files.
SQL Server | Other
14,621 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 1%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
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
14,621 questions
asked 2024-07-31T20:23:03.66+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(112.00000000000001, 94%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
James Southward
20
Reputation points
answered 2025-12-12T13:57:32.6833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(38.4, 57.00000000000001%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
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
14,621 questions
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.7K
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
536 questions
asked 2025-08-13T13:50:03.2533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(169.60000000000002, 31%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Alex Kipritsis
1
Reputation point
commented 2025-12-12T13:27:56.99+00:00
Alex Kipritsis
1
Reputation point
1 answer
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
14,621 questions
asked 2025-12-12T12:56:07.7066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 84%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Jens Schumacher
0
Reputation points
answered 2025-12-12T12:56:15.3066667+00:00
Q&A Assist
1 answer
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
536 questions
asked 2025-12-12T12:06:09.9233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 42%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Rajesh Kumar Yadav
20
Reputation points
commented 2025-12-12T12:44:50.3233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 35%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELN%3C/text%3E%3C/svg%3E)
Lakshmi Narayana Garikapati
650
Reputation points Microsoft External Staff
Moderator
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
536 questions
asked 2025-12-08T13:21:50.4033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 75%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESH%3C/text%3E%3C/svg%3E)
Sree Harshita Maddala
0
Reputation points
edited an answer 2025-12-12T11:52:44.1266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 66%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 40%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERN%3C/text%3E%3C/svg%3E)
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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(188.79999999999998, 93%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EER%3C/text%3E%3C/svg%3E)
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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 75%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
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
536 questions
asked 2025-12-03T10:51:55.7+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 85%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERD%3C/text%3E%3C/svg%3E)
Rodrigo de Oliveira Gomes - PrestServ
0
Reputation points
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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 59%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPB%3C/text%3E%3C/svg%3E)
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
536 questions
asked 2025-12-04T05:16:29.8166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 23%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPN%3C/text%3E%3C/svg%3E)
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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 77%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
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
536 questions
asked 2025-12-07T11:39:56.8733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 17%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZP%3C/text%3E%3C/svg%3E)
Zapadiya, Prahlad
0
Reputation points
commented 2025-12-12T10:45:53.7+00:00
Shruti Dhruv
405
Reputation points Microsoft External Staff
Moderator
3 answers
Internal error: An unexpected error occurred (file 'mdmodelmd.cpp', line 2669, function 'MDModelMD::DecodeRelAttr').
Hello, When I execute the following MDX query, I get this error: Internal error: An unexpected error occurred (file 'mdmodelmd.cpp', line 2669, function 'MDModelMD::DecodeRelAttr'). What does this error mean and how can I avoid this? The…
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,365 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 74%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(124.80000000000001, 23%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
1 answer
Error execute a SSIS Packed with SQL Agent
Hello, we have a very strange problem when executing an SSIS package with the SQL Agent. The package has the following tasks for an Excel file: 1. Check file in the source path. 2. Copy file to the destination path. 3. Open file in the destination…
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 2025-07-31T11:15:48.86+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 15%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW%3C/text%3E%3C/svg%3E)
Wolfgang
0
Reputation points
commented 2025-12-12T08:19:56.43+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 79%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDY%3C/text%3E%3C/svg%3E)
Dinesh Yadlapalli
0
Reputation points Microsoft External Staff
Moderator
5 answers
SSIS Package Execution Error - The requested OLE DB provider Microsoft.ACE.OLEDB.16.0 is not registered
Hello Community, I have been getting this error message every time I run my saved SSIS package. And even though I have looked up this error message across the web, the solutions have not seemed to work. To provide the background information with the…
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 2025-06-24T18:20:55.04+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 15%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Ryan
16
Reputation points
commented 2025-12-12T08:16:07.9+00:00
Dinesh Yadlapalli
0
Reputation points Microsoft External Staff
Moderator