14,736 questions
3 answers
One of the answers was accepted by the question author.
Breaking Changes - SQLOLEDB to MSOLEDBSQL/MSOLEDBSQL19 (SQL OLE DB Provider to SQL OLE DB Driver)
Hello. Very much behind the times, one of our clients needs to migrate their applications from using SQLOLEDB to MSOLEDBSQL or better MSOLEDBSQL19 (i.e. the original OLE DB Provider for SQL Server to the latest OLE DB Driver 19 for SQL Server). …
SQL Server | Other
asked 2022-11-08T10:56:14.397+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, 23%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECC%3C/text%3E%3C/svg%3E)
Clive Crocker
66
Reputation points
commented 2026-05-09T22:20:54.13+00:00
Andrew Jakobs
25
Reputation points
2 answers
How do I add Import/Export to SSMS 22?
I've downloaded and added SMSS 22 to my computer but still need the Import/Export features. How do I add them easily?
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,791 questions
asked 2026-05-08T12:40:17.15+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, 84%, 26%)' 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)
Jerry Schmeer Jr
0
Reputation points
answered 2026-05-08T14:18:04.0566667+00:00
Erland Sommarskog
133.9K
Reputation points MVP
Volunteer Moderator
3 answers
One of the answers was accepted by the question author.
How to add PDF Ifilter for SQL 2025?
Hi everyone, I am recently facing an issue regard Full-Text indexing in SQL Server 2025. I have installed SQL 2025 with Full-text indexing. Then i install Adobe IFilter. Unlike SQL 2022, i am not able to find any output for pdf when i run the below…
SQL Server | Other
14,736 questions
asked 2026-03-25T08:02:31.93+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, 65%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Suresh Sukumaran
20
Reputation points
answered 2026-05-08T13:29:20.7533333+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(179.20000000000002, 63%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKW%3C/text%3E%3C/svg%3E)
Krespan, William (OMB)
0
Reputation points
2 answers
The long running select statement blocked the insert/update statement
The long running select statement blocked the insert/update statement execution Scenario: We have the multi-thread batch insertion logic to insert data to MSSQL database. When the insertion logic was executed, some users execute a long running select…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
703 questions
asked 2026-05-08T06:42:51.8466667+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(16, 62%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
Sam Chung
0
Reputation points
answered 2026-05-08T12:25:13.02+00:00
Erland Sommarskog
133.9K
Reputation points MVP
Volunteer Moderator
2 answers
Facing issue in loading Report which contains Main and Sub report using Report builder in SSRS
we are working on SSRS Reporting using Report builder. we have a report which has a sub report in it which works well in Production Environment. The same report (RDL file) doesn't load anymore in QA Environment. after waiting 25-30 min, it shows error…
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,157 questions
asked 2026-05-08T07:20:52.6766667+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(166.4, 1%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Madani, Ramya Krishna
0
Reputation points
answered 2026-05-08T12:12:17.6233333+00:00
Erland Sommarskog
133.9K
Reputation points MVP
Volunteer Moderator
3 answers
To Implement HA strategy require licensing Cost
HI Team, We are planning to implement SQL Server 2025 Enterprise Edition with Always On HA and would like to understand the complete licensing cost, including per-core pricing details. Could you please assist with this? Thanks Sadiq
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
703 questions
asked 2026-05-05T10:06:08.2233333+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(249.60000000000002, 84%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Sadiq Ali
0
Reputation points
commented 2026-05-08T12:10:43.25+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(137.6, 10%, 23%)' 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)
Anjan Kumar Chippa (Quadrant Resource LLC)
0
Reputation points Microsoft External Staff
Moderator
1 answer
The SQL server 2019 installation failed in Windows Server 2025.
The SQL server 2019 installation failed in Windows Server 2025. From the logs, we understood that, installation fails because Microsoft Visual Studio Tools for Applications (VSTA) 2017 - a dependency of the Integration Services (SSIS) feature - crashes…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,791 questions
asked 2026-04-22T07:15:56.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(249.60000000000002, 19%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Siji, Merlin
0
Reputation points
commented 2026-05-08T12:05:29.7966667+00:00
Erland Sommarskog
133.9K
Reputation points MVP
Volunteer Moderator
1 answer
sql 2022 EXPRESS SDCO Error
Hello. i am having issue with installing SQL express 2022. basically i have a program that i am installing, but in the pre-req for that program i have to install sql 2022. while installing i get setup bootstrap error and in logfiles i see…
SQL Server | Other
14,736 questions
asked 2026-04-27T17:11:44.5566667+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(182.40000000000003, 80%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
aa
0
Reputation points
commented 2026-05-08T11:48:13.1866667+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
1,310
Reputation points Microsoft External Staff
Moderator
2 answers
Alternative to UNION
I have a UNION Query that is combining information from a History Table and the current Master Table. We are talking about a few million rows here. The problem is the amount of [tempdb] space it is allocating and using for the UNION. So we thought if we…
SQL Server | SQL Server Transact-SQL
283 questions
asked 2026-04-22T20:14:11.0866667+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(310.4, 79%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBP%3C/text%3E%3C/svg%3E)
Bobby P
271
Reputation points
commented 2026-05-08T11:47:34.1633333+00:00
Lakshmi Narayana Garikapati
1,310
Reputation points Microsoft External Staff
Moderator
1 answer
Always on Group databases randomly changed to Not Synchronized
Hi Expert, Our organization has SQL Server 2022 Enterprise edition (version RTM-CU16 KB5048033) with enable Always On Availability Group feature was installed on Windows Server 2022 Server (65 bit) used for contain Sharepoint application databases It…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
703 questions
asked 2026-05-08T09:29:31.63+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, 96%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EU%3C/text%3E%3C/svg%3E)
Urbel
585
Reputation points
answered 2026-05-08T09:29:57.4466667+00:00
Q&A Assist
4 answers
SSMA for Db2 cannot connect to Db2 running on AIX.
SSMA for Db2 cannot connect to Db2 running on AIX. connection string is: Provider=DB2OLEDB;Password=[password];Persist Security Info=True;User ID=[UserId];Initial Catalog=[DB Name];Data Source=[DB Name];Authentication=Server_Encrypt_Pwd;Network…
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.
606 questions
asked 2025-11-20T02:22:21.9466667+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(268.8, 64%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIT%3C/text%3E%3C/svg%3E)
Ikuo Takekawa/竹川 育夫
0
Reputation points
commented 2026-05-08T08:46:37.57+00:00
Ikuo Takekawa/竹川 育夫
0
Reputation points
2 answers
I am unable to connect on the SQL server
I've already contacted Windows support and they are only have limited resources and only found out the root cause of the issue. They said that the SSMS has an error means that the client tried to establish an encrypted connection, but the SSL cetificate…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
703 questions
asked 2026-03-24T07:30:12.73+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(198.4, 45%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESN%3C/text%3E%3C/svg%3E)
Sakthi N
0
Reputation points
commented 2026-05-08T05:45:09.4733333+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, 40%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESJ%3C/text%3E%3C/svg%3E)
Somil Jain
235
Reputation points
2 answers
Microsoft Partner Information
Dear Team, There is a Procurement of SQL Server 2025 Licenses is under process in our Organization. My question is regrading the Ressler partner of Microsoft that How much time the following Organizations are Microsoft reseller Partners?. Pakistan…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
703 questions
asked 2026-02-23T09:48:54.5466667+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, 89%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Ahmed Ali - Assistant Director (IT)
1
Reputation point
recommended 2026-05-08T05:30:02.14+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, 39%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
Azure ID Required
Why is an Azure ID required for Installing MS SQL Express
SQL Server | Other
14,736 questions
asked 2026-02-22T05:47:55.27+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(281.6, 72%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Marissa Muthulingum
0
Reputation points
recommended 2026-05-08T05:29:38.6166667+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
1 answer
Broken upgrade from SQL Server 2017 to 2022
Hello, SQL Upgrade was started at 2026-02-08 17:52:04. End time was logged as 2026-02-08 17:52:15 with final result "Pending". But in the Detail.txt file I see that last log entry is about 18:10. How can I recognize what is the reason of the…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
703 questions
asked 2026-02-17T15:19:23.0733333+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(144, 27%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EML%3C/text%3E%3C/svg%3E)
Michał Lis
0
Reputation points
recommended 2026-05-08T05:29:20.8666667+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
3 answers
"'MSOLEDBSQL19' provider is not registered", but it is, and runs fine for weeks
We have a web application that runs with a connection string of Provider=MSOLEDBSQL19;uid=:U;pwd=:P;server=theserver;initial catalog=thedatabase;MultipleActiveResultSets=True;Use Encryption for Data=Optional;MARS Connection=True; The application will…
SQL Server | Other
14,736 questions
asked 2026-02-17T13:44:33.5+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(252.8, 23%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDW%3C/text%3E%3C/svg%3E)
David Weigel
0
Reputation points
recommended 2026-05-08T05:28:35.6333333+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
4 answers
MSDASQL ODBC queries to Linked Servers hang with no response after a couple weeks.
Hi all, Our current setup is a linked server to NetSuite ODBC using MSDASQL 17 as the provider. Everything works and runs fine and fast for about 2 weeks. Then the error will occur. There will be no error message or anything, but the query just…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
703 questions
asked 2026-02-05T18:29:07.92+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, 40%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
Ted
0
Reputation points
recommended 2026-05-08T05:28:20.28+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
SQL Server 2025 Standard Key not working for Power BI Report Server
I am attempting to convert my evaluation edition of Power BI Report Server to a fully activated. I have read in both of the articles linked below that the exact same key used to activate SQL Server 2025 Standard (17.x) is what you should use to activate…
SQL Server | Other
14,736 questions
asked 2026-01-30T15:38:53.39+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(16, 2%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
Kyle Minard
0
Reputation points
recommended 2026-05-08T05:10:29.58+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
3 answers
SQL server generating different query_id for same query_text_id after mirroring failover
I am facing a strange problem with one of my SQL Server 2017 Clusters. I faced a query regression in the past and forced a known good plan for that query_id in query store. When the planned database failover happens every month for OS patching from HostA…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
703 questions
asked 2026-01-30T13:50:19.4766667+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(134.4, 13%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUD%3C/text%3E%3C/svg%3E)
udhayan d
181
Reputation points
recommended 2026-05-08T05:09:57.1533333+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
SQL Server 2022 Express installation fails on Windows 11 using web installer
Hello, I’m trying to install SQL Server 2022 Express on a Windows 11 laptop, but the installation fails when using the web installer. Environment: Windows 11 (64-bit) Laptop (not a server) SQL Server 2022 Express (Web installer) SQL Server Management…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
703 questions
asked 2026-01-28T01:26:17.6066667+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(291.2, 28.000000000000004%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPD%3C/text%3E%3C/svg%3E)
PEDRO DAVID RAMIREZ BECERRA
0
Reputation points
recommended 2026-05-08T05:09:27.82+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator