21,348 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
1 answer

My SQL Server 2017 license is not showing up in my account after migrating to Microsoft365.com.

microsoft.comで購入したライセンスを microsoft365.comに引き継ぎたい 　・SQL-User CAL 　・SQL Server Standard 　・Windows Server Device CAL

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,368 questions
asked 2026-02-02T04:30:54.7+00:00
白井佳子 0 Reputation points
commented 2026-02-11T07:56:30.8133333+00:00
Akhil Gajavelly 1,155 Reputation points Microsoft External Staff Moderator
2 answers

Unable to acquire authorization token (ConnectionDlg.AadInteractiveAuthProvider) with "Azure Active Directoy - Universal with MFA" to Azure SQL server when SSMS is run as my privileged account

This works fine from another system, or if I log on to the laptop directly with my privileged account. I need to run SSMS as my privileged account, because that's the only account that has been authorized to connect to our Azure SQL servers &…

Microsoft Security | Microsoft Entra | Microsoft Entra ID
Microsoft Security | Microsoft Authenticator
SQL Server | Other
asked 2024-10-07T14:33:49.44+00:00
Dom-Su BoChum 60 Reputation points
commented 2026-02-11T07:47:59.13+00:00
Henk Ouwersloot 0 Reputation points
2 answers

how to use azure communications service for smtp

SQL Reporting Services sending subscription emails

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,139 questions
asked 2026-02-10T18:45:30.46+00:00
James Pierce 0 Reputation points
answered 2026-02-11T07:32:41.45+00:00
Akhil Gajavelly 1,155 Reputation points Microsoft External Staff Moderator
0 answers

How to delete an orphan user from On premise Powerbi report server Site Setting using Powershell Script

In the On-Premise Power BI Report Server setup one user has been migrated from Corp to AHM domain. But in the On-Premise Power BI Report Server Site settings his username can be seen as Content Manager. Since the powerbi is not able to verify the old…

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,139 questions
asked 2026-02-11T05:46:15.0733333+00:00
Sandeep Mawri 0 Reputation points
0 answers

Error While Installing SQL Server 2022 / 2025

Screenshot 2026-02-11 045935.png Dear Sir/Madam, I am facing an error every time I try to install SQL Server 2022 as well as SQL Server 2025 on my laptop. I have already formatted my system, but the issue still persists. The same error occurs during each…

SQL Server | Other
asked 2026-02-10T23:40:15.0733333+00:00
PRANAV SHRIVASTAVA 0 Reputation points
commented 2026-02-11T04:16:43.73+00:00
Abo Ahmed 0 Reputation points
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
asked 2026-01-30T18:06:58.63+00:00
Justin Doh 960 Reputation points
edited a comment 2026-02-11T00:51:15.9766667+00:00
Justin Doh 960 Reputation points
1 answer

how to fix maintinence plans wizard for SQL Server 2022 this is unavailable

how to fix maintinence plans wizard for SQL Server 2022 this is unavailable

SQL Server | Other
asked 2025-10-24T19:17:53.62+00:00
Martínez Peña Eusebio II 5 Reputation points
commented 2026-02-10T22:36:52.7466667+00:00
Erland Sommarskog 132.1K Reputation points MVP Volunteer Moderator
2 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
asked 2026-02-05T18:29:07.92+00:00
Ted 0 Reputation points
commented 2026-02-10T21:59:24.6266667+00:00
Ted 0 Reputation points
0 answers

Cannot connect to SQL Server

Let say i have server A and two sql server, SQL1 and SQL2. When Server A try connect to SQL1 then i got below error from SSMS, but if connect to SQL2 then the conneciton is working fine. Other servers beside Server A can connect to both SQL. A Anyone…

SQL Server Database Engine
asked 2026-02-10T01:37:21.5066667+00:00
Handian Sudianto 6,726 Reputation points
commented 2026-02-10T21:58:46.1533333+00:00
Erland Sommarskog 132.1K Reputation points MVP Volunteer Moderator
1 answer

How to fix missing languages on Full text indexes

Our SQL Server went down after a failed patch `and locked the server instance in ChangePending state, we rolled back the VM and got the DB back to being operational with the exception of the full text indexes... I have run the repair tool checked to see…

SQL Server | Other
asked 2026-02-06T11:54:35.0733333+00:00
Wade Buckthorp 0 Reputation points
commented 2026-02-10T21:33:03.1466667+00:00
Erland Sommarskog 132.1K Reputation points MVP Volunteer Moderator
2 answers

SQL Server 2019 process crashes on specific query

Hello, I have a strange issue where I can crash SQL Server 2019 (fully patched at the time of writing to 15.0.4455.2) by issuing rather simple query with the following prerequisites: there is a multi statement table value function there is a view that…

SQL Server Database Engine
asked 2026-01-31T13:47:39.7966667+00:00
Filip Matijević 0 Reputation points
edited a comment 2026-02-10T19:58:01.04+00:00
Alberto Morillo 35,416 Reputation points MVP Volunteer Moderator
2 answers

SSIS Data Flow has trouble when it has to return many fields

I have an SSIS project that calls stored procedures to create extract files via OLE DB Source & Flat File Destination. The stored procedure returns 150 fields and sometimes a few million records. This causes SSIS & Visual Studio 2019 to take a…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,773 questions
asked 2026-02-05T20:09:28.96+00:00
Bob-7209 66 Reputation points
edited an answer 2026-02-10T15:13:43.5433333+00:00
Yitzhak Khabinsky 27,096 Reputation points
1 answer

Microsoft ODBC Driver for SQL Server Version 17.10.000

Microsoft ODBC Driver for SQL Server Version 17.10.000 returns with error "Test failed" Anyone can assist me with this issue or any ideas, currently it is installed on Windows 11 VM.

SQL Server Database Engine
asked 2025-08-14T13:52:40.3733333+00:00
Armando D. Hernandez 5 Reputation points
commented 2026-02-10T07:27:14.2066667+00:00
Lakshmi Narayana Garikapati 750 Reputation points Microsoft External Staff Moderator
1 answer

SQL SERVER (MSSQLSERVER) ERROR 1067

Hola, Tengo un servidor con Windows server 2025 y se le instaló SQL server 2022, se le estaban realizando configuraciones de always on y licenciamiento pero se tuvo que reiniciar. En el momento en que encendió el servidor, el servicio de SQL estaba…

SQL Server Database Engine
asked 2026-02-05T19:14:02.0633333+00:00
jorge miguel callejas quiroga 0 Reputation points
commented 2026-02-10T07:21:31.58+00:00
Lakshmi Narayana Garikapati 750 Reputation points Microsoft External Staff Moderator
3 answers

Message=A severe error occurred on the current command. The results, if any, should be discarded.

Hi, There is an Failure in my Azure Datafacttory for a particular table with the below error message. Failure happened on 'Source' side.…

SQL Server | Other
asked 2026-02-03T06:06:13.4133333+00:00
Sudhakar Paraniselvan 0 Reputation points
commented 2026-02-10T07:20:19.14+00:00
Lakshmi Narayana Garikapati 750 Reputation points Microsoft External Staff Moderator
2 answers

Power BI Question

I have a table from a SQL server. When I want to see specific data via a visual based on a name I select, it self-filters certain things. My table is called WidgetHistory. The column I want to pull data from is CurrentStatusID. I need to see all widgets…

SQL Server | Other
asked 2026-02-02T16:31:32.9766667+00:00
DukeNukem 0 Reputation points
commented 2026-02-10T07:19:23.42+00:00
Lakshmi Narayana Garikapati 750 Reputation points Microsoft External Staff Moderator
1 answer

Unable to install SQL server (Setup.exe) Exit code:-2061893606

I am unable to install 2025 SQL server Express Edition. The OOps message pops up at the very end which says: Unable to install SQL server (Setup.exe) Exit code:-2061893606. Wait on the database engine recovery handle failed. Check the error log.

SQL Server | Other
asked 2026-02-02T14:59:06.57+00:00
NGUYEN VINH 0 Reputation points
commented 2026-02-10T07:17:47.7066667+00:00
Lakshmi Narayana Garikapati 750 Reputation points Microsoft External Staff Moderator
1 answer

Failover Cluster Shows Quarantined node but everything is working ok.

Hi All. We have 2x 2022 HyperV servers with a clustered SQL server running on each host. Yesterday i shut down all the vm's on Host 2 and patched it to latest firmware etc. When I brought the SQL servers back up, SQL Server 2 in the failover cluster was…

Windows for business | Windows Server | Storage high availability | Clustering and high availability
Windows for business | Windows Server | User experience | Other
SQL Server | Other
asked 2025-01-16T10:11:20.8266667+00:00
Jodiethedog 5 Reputation points
commented 2026-02-10T07:13:37.39+00:00
Lakshmi Narayana Garikapati 750 Reputation points Microsoft External Staff Moderator
1 answer

stuck in installation page, only showing pause and cancel button

stuck in installation page, only showing pause and cancel button kindly need help in this

SQL Server | Other
asked 2026-01-26T20:07:34.4333333+00:00
Khan H, Imran (Cognizant) 0 Reputation points
commented 2026-02-10T07:12:27.1066667+00:00
Lakshmi Narayana Garikapati 750 Reputation points Microsoft External Staff Moderator
2 answers

create table script for existing table

I want to create a create table script for existing table with indexes

SQL Server Database Engine
asked 2026-02-08T23:04:04.48+00:00
JOSHI, Vivek 0 Reputation points
commented 2026-02-09T22:58:31.9233333+00:00
JOSHI, Vivek 0 Reputation points