14,681 questions
0 answers
SQL Server 2016 patch Error while patching to version v6475.1
I am trying to patch SQL Server 2016 on Windows, but while patching, I get the below error: "" SQL Server Setup failure SQL Server Setup has encountered the following error: Index (zero based) must be greater than or equal to zero and less…
SQL Server | Other
asked 2026-02-25T21:23:22.18+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, 70%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
Akash Bhat
0
Reputation points
commented 2026-02-25T22:55:48.3633333+00:00
Erland Sommarskog
132.6K
Reputation points MVP
Volunteer Moderator
0 answers
How deploy copilot using Vscode when running PowerBI backend?
I'm hosting a 2022 SQL Server Adminstrator on an Office instance of m365, but the boot screen doesn't allow for adminstrator privelege access for the powerbi backend. How to fix?
SQL Server | Other
14,681 questions
asked 2026-02-25T22:25:54.2266667+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(153.6, 26%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
Garrett Settles
0
Reputation points
edited the question 2026-02-25T22:41:27.9333333+00:00
Gérard Oomens
118.8K
Reputation points
Volunteer Moderator
0 answers
Can't connect to SQL Server to complete Learning Labs
DataSource.Error: Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is…
SQL Server | Other
14,681 questions
asked 2026-02-25T22:10:45.2+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(160, 78%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Ammo Parmar
0
Reputation points
commented 2026-02-25T22:24:47.4666667+00:00
Erland Sommarskog
132.6K
Reputation points MVP
Volunteer Moderator
2 answers
Failed Silently when SSMS v22 layout offline installation
Hi expert.. I apply as MS Documentation at https://learn.microsoft.com/en-us/ssms/install/create-offline but it still failed silently, at above document it related to created Certificate but it still didnt worked.. any experience of this issue? thanks…
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.
603 questions
asked 2026-02-25T03:10:38.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(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
400
Reputation points
edited an answer 2026-02-25T22:13:41.01+00:00
Erland Sommarskog
132.6K
Reputation points MVP
Volunteer Moderator
2 answers
Assessment for SSISDB and SSIS Catalogue
Hi all, I'm using tools Migrate SQL server to migration assessment at SSMS v22, but SSISDB database did not appear in Database selection something's wrong at my SSMS ? thanks for all reply regards, Urbel
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.
603 questions
asked 2026-02-25T06:50:22.2766667+00:00
Urbel
400
Reputation points
answered 2026-02-25T22:11:38.1566667+00:00
Erland Sommarskog
132.6K
Reputation points MVP
Volunteer Moderator
2 answers
One of the answers was accepted by the question author.
Critical: SQL Server 2019 CU32 Crash – c0000005 Access Violation (sqldk.dll) – Production Impact
Dear Microsoft Support Team,We are experiencing repeated unexpected shutdowns of our production SQL Server instance and would like to raise a critical support ticket for investigation.Environment Details: Product: Microsoft SQL Server 2019 Enterprise…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
646 questions
asked 2026-02-25T07:07:51.5366667+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(83.2, 26%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
vivek singh
20
Reputation points
answered 2026-02-25T22:06:23.6266667+00:00
Erland Sommarskog
132.6K
Reputation points MVP
Volunteer Moderator
1 answer
Enabling RCSI and ADR on SSISDB and ReportServer
We're considering enabling two database-level settings on SSISDB and ReportServer: READ_COMMITTED_SNAPSHOT (is_read_committed_snapshot_on = 1) — reduces blocking by using row versioning instead of shared locks ACCELERATED_DATABASE_RECOVERY…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,778 questions
asked 2026-02-24T22:16:48.07+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, 11%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELD%3C/text%3E%3C/svg%3E)
Louis Davidson
21
Reputation points
commented 2026-02-25T21:57:55.56+00:00
Erland Sommarskog
132.6K
Reputation points MVP
Volunteer Moderator
0 answers
SQL Server Developer Edition Installer can't identify an installed software it needs.
Hi! I'm having a problem installing Microsoft SQL Server Developer Edition. It says that a certain software is not installed, although it is indeed installed. Any idea how can I solve this issue? The following lines are copied from Details.txt…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
646 questions
asked 2026-02-21T13:32:24.1533333+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(121.6, 86%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAH%3C/text%3E%3C/svg%3E)
Abdelrahman Hany
0
Reputation points
commented 2026-02-25T21:53:10.9966667+00:00
Erland Sommarskog
132.6K
Reputation points MVP
Volunteer Moderator
1 answer
cannot open or create sql agent alerts
When I try opening an existing alert in SSMS (SQL Agent - Alerts) or create a new alert, I receive the following error: The Show details button contains the following: =================================== Cannot show requested…
SQL Server | Other
14,681 questions
asked 2026-02-24T22:02:13.37+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(140.8, 88%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
Charles Burschtin
0
Reputation points
commented 2026-02-25T21:39:47.3233333+00:00
Erland Sommarskog
132.6K
Reputation points MVP
Volunteer Moderator
1 answer
SSIS Package Development in Windows on ARM (MacOS running Parallel)
Hi, Based on https://learn.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver17&tabs=vs2026#visual-studio-for-arm64 Although was not able to find SSIS Extension within Visual Studio (2026) but was able to complete…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,778 questions
asked 2026-02-18T01:32:46.5933333+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(220.8, 15%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETT%3C/text%3E%3C/svg%3E)
Tommy Teoh
0
Reputation points
edited a comment 2026-02-25T06:43:26.3866667+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
920
Reputation points Microsoft External Staff
Moderator
2 answers
One of the answers was accepted by the question author.
STIntersection() hangs forever
Hello, when I execute this STIntersection() query for two valid polygons (in this case CurvePolygons), it will run forever and will cause (very) high CPU usage! The problem exists at least from SQL2016 to SQL2025 (with latest updates installed). See…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
646 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(294.40000000000003, 96%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
how to resolve degraded sql performance since upgrading from sql 2016 to sql 2022
We have a sql instance ( on premise) that was running sql 2016. Query store was not enabled. We have a large workload that runs overnight, hundreds of stored procedures. We have upgraded to sql 2022, but had an approximately 10% increase of the duration…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
646 questions
asked 2026-02-15T23:44:37.3066667+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, 73%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGB%3C/text%3E%3C/svg%3E)
Greg Booth
1,456
Reputation points
commented 2026-02-24T23:13:56.88+00:00
Greg Booth
1,456
Reputation points
1 answer
Migrating Large Size scale Database
Hi all, what is alternative method to migrating side by side large size Database thanks for all reply regards, Urbel
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.
603 questions
asked 2026-02-24T02:50:57.9666667+00:00
Urbel
400
Reputation points
commented 2026-02-24T22:25:21.02+00:00
Erland Sommarskog
132.6K
Reputation points MVP
Volunteer Moderator
2 answers
How does one go about buying a SQL license?
I know this sounds like it should be simple, but it's not. The marketplace goes nowhere, call MS, they don't call back. I assume I need to find a licensed partner, but that is also no response. Can anybody point me to somebody that I can give money to…
SQL Server | Other
14,681 questions
asked 2026-02-24T15:24:35.8666667+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(96, 81%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
Jim
386
Reputation points
answered 2026-02-24T22:14:19.5233333+00:00
Erland Sommarskog
132.6K
Reputation points MVP
Volunteer Moderator
2 answers
One of the answers was accepted by the question author.
How to create initial full backup followed by transaction logs daily?
This is related to work. I have been sending out a full-back up of a database in BAK file format (using SQL Server 2022) for a client, but now the client is asking for an initial full backup followed by transaction logs daily. How do I go about doing it…
SQL Server | SQL Server Transact-SQL
270 questions
asked 2026-01-30T18:06:58.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(12.8, 39%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJD%3C/text%3E%3C/svg%3E)
Justin Doh
980
Reputation points
commented 2026-02-24T22:05:46.54+00:00
Erland Sommarskog
132.6K
Reputation points MVP
Volunteer Moderator
2 answers
SQL Server 2025 Standard License
I have downloaded SQL server 2025 Standard iso from volume licensing portal and when trying to install it gives predefined license key in the setup but we also have key available in licensing portal which is different than the one embedded in the setup…
SQL Server | Other
14,681 questions
asked 2026-02-14T15:56:35.87+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(102.4, 47%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Shivank Gupta
0
Reputation points
commented 2026-02-24T21:52:56.39+00:00
Erland Sommarskog
132.6K
Reputation points MVP
Volunteer Moderator
1 answer
Facing issue with SQL Server CDC
Hi Team, I am working on Change Data Capture feature in SQL Server (on premises). In the Database in which Change Data capture feature is enabled, I am having a table MQ which gets filled with a CT table, having a SQL function which selects data from…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
646 questions
asked 2025-09-13T17:06:49.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(275.2, 61%, 36%)' 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)
Salil Singh
60
Reputation points
recommended 2026-02-24T18:38:43.6933333+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
1 answer
How can I recover my purchased Microsoft SQL 2019 license?
Good morning, I purchased a Microsoft SQL Server license on August 20, 2021. Authorization number: [Moderator note: personal info removed] License number: [Moderator note: personal info removed] I need to reinstall the server using the license with its…
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.
603 questions
asked 2025-10-20T12:51:48.9533333+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(156.8, 99%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMC%3C/text%3E%3C/svg%3E)
Marco Caroli
0
Reputation points
recommended 2026-02-24T18:38:12.9733333+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
Getting an error installing SQL Server 2022 in my computer
I'm getting error when installing SQL server 2022. I'm attaching the summary and details log here.Detail.txt
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
646 questions
asked 2025-10-21T08:02:58.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(64, 10%, 16%)' 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)
Anthony
0
Reputation points
recommended 2026-02-24T18:37:41.4533333+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
1 answer
Issues with SSRS Configuration Manager reports
Hi, we have been struggling with this for a while now (we needed to change Configuration Manager SSRS service account password and then this started): 'Microsoft.ReportingServices.ReportProcessing.ReportProcessingException' was thrown.…
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,141 questions
asked 2026-01-24T14:25:14.3066667+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(150.4, 33%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBZ%3C/text%3E%3C/svg%3E)
Bojan Zivkovic
616
Reputation points
recommended 2026-02-24T18:37:12.2766667+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator