14,707 questions
2 answers
In place Upgrade from Sql 2014 to 2022
Hello, I am planning to perform Sql server 2014 to 2022 on Windows server 2022. I have done following before upgrade: Verified Sql server 2014 is at SP3 Done Assessment and nothing breaking change except depreciated datatype. We will be taking…
SQL Server | Other
![](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, 17%, 24%)' 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)
0 answers
SSRS Install Fails because Access Control List is not in Canonical Form
We are upgrading SQL server from 2016 to 2017, which means SSRS is now a separate installation. The OS is Windows Server 2019. We ran the 2017 version of SQLServerReportingServices.exe and the main installation log reports, "UnexpectedError: Burn…
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,145 questions
asked 2026-03-16T13:49:27.29+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(89.60000000000001, 81%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL2%3C/text%3E%3C/svg%3E)
Loc750-2546
1
Reputation point
answered 2026-03-16T13:49:42.5033333+00:00
Q&A Assist
1 answer
TLS requirement for SQL Server
Hi Expert, our organization has problem with connectivity intermittent between Client and DB Server and now there is Microsoft recommendation to check as below: Review any custom Cipher suite hardening or Group Policy cinfiguration Ensure TLS 1.2…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
666 questions
asked 2026-03-11T02:11:04.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(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
465
Reputation points
commented 2026-03-16T12:10:43.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(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
Database replication alerts using the SMTP relay Port 25
We tested the TCP connection from the SQL Server to relay.****.com on port 25, and the connection was successful. However, the alert emails are still remaining in an unsent state. Do we need to configure basic authentication while using port 25?
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
666 questions
asked 2026-03-16T09:17:08.5333333+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, 68%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDV%3C/text%3E%3C/svg%3E)
Devulacheruvu Venkatesh
0
Reputation points
answered 2026-03-16T09:17:23.8533333+00:00
Q&A Assist
2 answers
Sequel server licensing
My distributer is telling me that SQL Server Standard 2022 - 2 Core License Pack - 3 yearSQL Server Standard 2022 - 2 Core License Pack - 3 year billed annually is a perpetual license? I have query with this as it has a termed subscription time?…
SQL Server | SQL Server Transact-SQL
276 questions
asked 2026-03-02T03:07:55.3166667+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, 15%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEC%3C/text%3E%3C/svg%3E)
Esther Cleave
0
Reputation points
commented 2026-03-16T08:35:12.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(134.4, 49%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Akhil Gajavelly
1,570
Reputation points Microsoft External Staff
Moderator
1 answer
Errors in SQL MDS since installing latest patch
Since installing last nights patch we are getting errors loading MDS - the patch has updated Newtonsoft DLL to 13.1.1 but we cannot find how to change this in any of the config files etc. Could not load file or assembly 'Newtonsoft.Json,…
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,145 questions
asked 2025-09-11T14:51:20.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(0, 30%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAR%3C/text%3E%3C/svg%3E)
Andy Rawcliffe
0
Reputation points
commented 2026-03-16T08:07:22.43+00:00
Micael Carlsson
26
Reputation points
1 answer
Query on Epicor‑bundled Runtime SQL licenses do not include Software Assurance
Dear Support, If Our current Epicor‑bundled Runtime SQL licenses do not include Software Assurance, Whether our current licensing model allows us to run a passive SQL failover server without additional cost, or if a new license is mandatory even for…
SQL Server | Other
14,707 questions
asked 2026-03-16T05:11:50.6266667+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, 17%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMN%3C/text%3E%3C/svg%3E)
Muhammad Nizam Bin M Muhaimin
0
Reputation points
answered 2026-03-16T06:45:28.5066667+00:00
Akhil Gajavelly
1,570
Reputation points Microsoft External Staff
Moderator
2 answers
can i check an SQL report from a specific date in the past?
can i check an SQL report from a specific date in the past?
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,145 questions
asked 2026-03-15T16:15:30.8633333+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, 12%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELY%3C/text%3E%3C/svg%3E)
LONGMATEY, Yaw
0
Reputation points
answered 2026-03-16T06:37:10.4133333+00:00
Akhil Gajavelly
1,570
Reputation points Microsoft External Staff
Moderator
1 answer
I am facing issue while installing Sql Server 2025 Express to my laptop Asus TUF Gaming laptop
To:Microsoft SQL Server Support Dear Microsoft SQL Server Support Team, I am experiencing installation issues with SQL Server 2025 Express Edition on my ASUS TUF Gaming A15 laptop running Windows 10 Home Single Language. During setup, the installation…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
666 questions
asked 2026-03-15T14:24:39.82+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(131.20000000000002, 98%, 22%)' 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)
sanjay MN
0
Reputation points
answered 2026-03-15T15:33:08.4233333+00:00
Erland Sommarskog
133.2K
Reputation points MVP
Volunteer Moderator
2 answers
Guidence required in time bound index reorganization job
We are planning to configure an Index Reorganize job on the server with a specific operational constraint. The job must complete or stop before the customer’s business hours begin (05:00 AM server time). If the job is still running at 05:00 AM and needs…
SQL Server | Other
14,707 questions
asked 2026-03-15T13:34:58.7566667+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(278.4, 78%, 36%)' 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)
Raju Kothapally
10
Reputation points
answered 2026-03-15T13:59:16.7166667+00:00
Erland Sommarskog
133.2K
Reputation points MVP
Volunteer Moderator
3 answers
Copying a 32-Million Row Table From Production Server to Test Server
So we believe we're having tempdb issues with a very wide table that has 32-Million Rows on it. There is no Primary Clustered Index, No Indexes defined on it at all. We have tried an INSERT SELECT going across a Linked Server to our Test Server to copy…
SQL Server | SQL Server Transact-SQL
276 questions
asked 2026-03-13T19:43:14.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(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
edited a comment 2026-03-15T11:06:06.3666667+00:00
Erland Sommarskog
133.2K
Reputation points MVP
Volunteer Moderator
2 answers
I am unable to install MS SQL 2019/2022 express/evaluation/Developer on my system.
I downloaded free evaluation version from microsoft site and tried installing it multiple times, it just does not install Database engine. I did remove registry entries, cleaned all the folders, used microsoft troubleshooting app, all fails. I am on…
SQL Server | Other
14,707 questions
asked 2026-03-15T08:13:10.9166667+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(224.00000000000003, 66%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Sanjeev
0
Reputation points
answered 2026-03-15T10:57:06.9233333+00:00
Erland Sommarskog
133.2K
Reputation points MVP
Volunteer Moderator
2 answers
Upgrade sql 22 to 25 ends with error Azure extension for SQL Server Failed
I have just upgraded my sql 2022 to 2025, everything went OK except at the end, I got an error as follows Feature: Azure extension for SQL Server Status: Failed Reason for failure: An error…
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.
605 questions
asked 2026-03-14T12:47:40.2166667+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, 19%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESE%3C/text%3E%3C/svg%3E)
Salam ELIAS
257
Reputation points
commented 2026-03-15T10:20:47.6333333+00:00
Salam ELIAS
257
Reputation points
2 answers
Is sql copilot free or is a commercial option
When I clik on Copilot in SSMS it asks me for some input like endpoints, does this mean that it is not free? Thanks
SQL Server | Other
14,707 questions
asked 2026-03-14T12:49:39.1466667+00:00
Salam ELIAS
257
Reputation points
answered 2026-03-14T13:34:43.1066667+00:00
Erland Sommarskog
133.2K
Reputation points MVP
Volunteer Moderator
1 answer
How to reset Local Database
My computer is saying local data base must be reset
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
666 questions
asked 2026-03-13T14:59:56.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(211.20000000000002, 73%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
StorTropolis - Tiffany Springs
0
Reputation points
commented 2026-03-14T04:04:23.43+00:00
Viorel
126.8K
Reputation points
2 answers
Integration with SSO login on-premises (non-fabric and non-cloud) PowerBI Reporting Server
Hi, We need to understand the standard integration process of integration SSO login (with PowerBI Reporting Server) wherein the flow is following : FSSO login happens and a SAML token is generated by the service provider. Using above SAML token, we…
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,145 questions
asked 2026-03-02T09:59:16.6233333+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(35.2, 90%, 13%)' 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)
Samir Modi
0
Reputation points
commented 2026-03-13T15:30:08.8866667+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
error 26 trying to connect to my local server
Cannot connect to xxx.xxx.xxx.xxx\SQLEXPRESS. ADDITIONAL INFORMATION: 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…
SQL Server | Other
14,707 questions
asked 2026-03-06T18:06:48.76+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(278.4, 85%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECN%3C/text%3E%3C/svg%3E)
Chau Nguyen (CELA)
0
Reputation points Microsoft Employee
commented 2026-03-13T15:25:18.61+00:00
Lakshmi Narayana Garikapati
920
Reputation points Microsoft External Staff
Moderator
2 answers
How to identify different compressions
Hi, ALL, This - https://learn.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-partitions-transact-sql?view=sql-server-ver17 indicates that there is only 1 record for both XML and regular partition compression. My question would be -…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
666 questions
asked 2026-03-06T06:53:26.0633333+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(147.20000000000002, 3%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIK%3C/text%3E%3C/svg%3E)
Igor Korot
56
Reputation points
commented 2026-03-13T15:24:00.12+00:00
Lakshmi Narayana Garikapati
920
Reputation points Microsoft External Staff
Moderator
1 answer
SQL Server Object Explorer closes immediately in Visual Studio – Error 0x8007007B and SQL Server Express installation fails
Details: I am experiencing an issue with Visual Studio where I cannot create or manage databases. When I open Visual Studio and go to View → SQL Server Object Explorer, a popup window briefly appears and then immediately closes again. This keeps…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
666 questions
asked 2026-03-05T20:16:13.1566667+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, 6%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Søren Dyrbye
0
Reputation points
commented 2026-03-13T15:22:35.6833333+00:00
Lakshmi Narayana Garikapati
920
Reputation points Microsoft External Staff
Moderator
1 answer
One of the answers was accepted by the question author.
Best, Most Efficient DATETIME filtering
I have seen many discussions regarding doing filtering against a DATETIME Data Type. Some suggest to use a true DATTETIME format. WHERE <DATETIME_Column_Name> >= '2026-02-17 00:00:00.000' Others suggest to use just a quoted Date... WHERE…
SQL Server | SQL Server Transact-SQL
276 questions