21,533 questions with SQL Server-related tags

Sort by: Updated
1 answer

Deux codes d'activation de Ms MSQL Svr runtime 2022 lot ESD ne fonctionnent plus

Bonjour, Nous avions commandé deux licences SQL serveur 2019 Std Runtime 2022 lot EDS OEI 5 clt avec les cartons et tous les numéros de série encore disponibles, mais les serveurs sur lesquels ces licences ont été activées sont depuis quelques jours…

SQL Server Database Engine
asked 2026-04-14T16:11:53.8566667+00:00
Nawal TAHIRI 0 Reputation points
commented 2026-04-15T09:01:49.0133333+00:00
Nawal TAHIRI 0 Reputation points
2 answers

SSRS 2016 (V13.0.6470.1) Error: Failure sending mail: An internal error occurred on the report server.

Receiving issue with SSRS e-mail subscriptions. Can send e-mails via the shared mailbox using PowerShell on same server successfully. Issue is only when trying to send via SSRS 2016. It started occurring 2 days ago and was working prior. Makes me think…

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,154 questions
asked 2026-04-13T21:38:01.45+00:00
Brian 1 Reputation point
answered 2026-04-15T07:26:06.8566667+00:00
Akhil Gajavelly 1,735 Reputation points Microsoft External Staff Moderator
2 answers

SQL Server Always on AG group failing to failover to secondary

We are experiencing SQL Server Availability Group failover issues. The same problem is occurring across multiple Availability Groups on the same server. We identified that the ODBC drivers were uninstalled and have since reinstalled the drivers and…

SQL Server Database Engine
asked 2026-04-14T10:43:25.8733333+00:00
Narasimha Gopavarapu 0 Reputation points
answered 2026-04-15T07:15:00.7333333+00:00
Akhil Gajavelly 1,735 Reputation points Microsoft External Staff Moderator
2 answers

SQL Server 2019 Master Data Services Excel Add-in issue on new server

Hi All, We are migrating our SQL Server 2019 Master Data Services (MDS) installation running on Windows Server 2019 to a new installation on Windows Server 2019. We have migrating only databases on new server With Edge it's ok but with MDS Excel…

SQL Server | Other
asked 2026-04-01T15:08:17.6666667+00:00
Reinero Joel 0 Reputation points
commented 2026-04-15T06:52:27.8066667+00:00
Lakshmi Narayana Garikapati 1,300 Reputation points Microsoft External Staff Moderator
1 answer

SSAS Issue on Cube refresh gives "Subscription identifier is invalid"

Hello, Could you please help us on issue below: When we process cubes by SSIS batch, we occasionally bump into the below error: "The Subscription identifier is invalid; it must be unique when subscribing and the identifier of a registered…

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,370 questions
asked 2026-04-09T13:45:38.3033333+00:00
MICHAEL DIJKMAN 0 Reputation points
commented 2026-04-15T06:30:06.66+00:00
Lakshmi Narayana Garikapati 1,300 Reputation points Microsoft External Staff Moderator
1 answer

SSRS server not available 503 error

Hi Team, I have configured SQL Server Reporting Services (SSRS) and integrated it with MS SQL Server. The setup was working fine for the past few months; however, currently, we are facing an issue while accessing the report server. Error Details: HTTP…

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,154 questions
asked 2026-04-08T14:20:02.13+00:00
Farheen Qureshi 0 Reputation points
commented 2026-04-15T06:29:11.2966667+00:00
Lakshmi Narayana Garikapati 1,300 Reputation points Microsoft External Staff Moderator
1 answer

Currently, I can not download SQL server last update in Mircosoft website

this link https://www.microsoft.com/download/details.aspx?id=108590 it show We're sorry, this download is no longer available. Perhaps one of the following links will help you find what you need.

SQL Server | Other
asked 2026-04-03T05:42:47.4166667+00:00
commented 2026-04-15T06:25:56.3+00:00
Lakshmi Narayana Garikapati 1,300 Reputation points Microsoft External Staff Moderator
1 answer

In my Data Flow OLE DB Source, can I write a SQL Query that is dependent on a SSIS Variable

For instance... If [User::InitialorMonthly] == 'Initial' SELECT (Everything) ELSE SELECT Based on [ModifyDate] being from the 15th of last month to now...[User::InitialorMonthly] == 'Monthly' I could CASE it out in my T-SQL but if I've already derived…

SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,783 questions
asked 2026-04-02T19:15:45.27+00:00
Bobby P 271 Reputation points
commented 2026-04-15T06:25:04.7966667+00:00
Lakshmi Narayana Garikapati 1,300 Reputation points Microsoft External Staff Moderator
2 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
asked 2026-01-30T13:50:19.4766667+00:00
udhayan d 181 Reputation points
commented 2026-04-15T05:39:49.7733333+00:00
Akhil Gajavelly 1,735 Reputation points Microsoft External Staff Moderator
1 answer

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
asked 2026-01-28T01:26:17.6066667+00:00
PEDRO DAVID RAMIREZ BECERRA 0 Reputation points
commented 2026-04-15T05:22:58.84+00:00
Akhil Gajavelly 1,735 Reputation points Microsoft External Staff Moderator
1 answer

Microsoft ACE.OLEDB.12.0 is not registered while import excel file

Microsoft ACE.OLEDB.12.0 is not registered -

SQL Server Database Engine
asked 2026-01-27T08:59:23.8633333+00:00
Noseda, Enzo 0 Reputation points
commented 2026-04-15T05:13:49.3833333+00:00
Akhil Gajavelly 1,735 Reputation points Microsoft External Staff Moderator
1 answer

SQL error -An expression of non-boolean type specified in a context where a condition is expected

Thanks in advance for any help folks can offer. I've been pulling my hair our all day yesterday trying to figure out how to fix this. I received the error below after I added 3 new lines (line 60, 61 and 62). The original code without these 3 new lines…

SQL Server | SQL Server Transact-SQL
asked 2026-01-26T18:29:09.99+00:00
DW 0 Reputation points
commented 2026-04-15T05:00:24.9933333+00:00
Akhil Gajavelly 1,735 Reputation points Microsoft External Staff Moderator
1 answer

Can not install SQL server

I tried to install QL server on my new laptop and seems it's not working at all. Herewith the summary: Summary_TUFA1420250817_20260114_071102.txt I installed using SQL2019-SSEI-Expr, even I tried uninstalled all and tried using SQL2022-SSEI-Expr but…

SQL Server Database Engine
asked 2026-01-26T15:01:06.8466667+00:00
Santos 0 Reputation points
commented 2026-04-15T04:55:03.7866667+00:00
Akhil Gajavelly 1,735 Reputation points Microsoft External Staff Moderator
2 answers

Build errors when adding SQL Server 2025 (v17) support

Hi Team, I am updating a project to add support for SQL Server 2025 (V17.x), but I am encountering the following build errors: error CS0234: The type or namespace name 'Smo' does not exist in the namespace 'Microsoft.SqlServer.Management' (are you…

SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,783 questions
asked 2026-01-12T07:43:28.86+00:00
Abhishek Modi (amodi) 20 Reputation points
commented 2026-04-15T04:27:15.7333333+00:00
Akhil Gajavelly 1,735 Reputation points Microsoft External Staff Moderator
2 answers

The SQL Server Management studio no longer shows running SSIS packages

Hi everyone, I run a bunch of SSIS packages in a SQL Server Agent job. The packages are deployed as files in the file system. They are executed as SQL Server Agent Service Account. I used to be able to see them under Running Packages. Today, they weren't…

SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,783 questions
asked 2025-12-19T21:51:23.88+00:00
Igor Gelin 0 Reputation points
commented 2026-04-15T04:21:28.56+00:00
Akhil Gajavelly 1,735 Reputation points Microsoft External Staff Moderator
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
asked 2025-12-12T12:56:07.7066667+00:00
Jens Schumacher 0 Reputation points
commented 2026-04-15T04:16:56.08+00:00
Akhil Gajavelly 1,735 Reputation points Microsoft External Staff Moderator
1 answer

Need Archived Installer for SSMA 10.3

Hi, I’m running SQL Server 2022 Express on Windows 10 (64‑bit) and using SSMA for Access. With SSMA 10.4, I keep getting the error “Bad parameters for connection” when connecting via Windows Authentication. I understand this is a known regression in…

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 2025-11-29T19:05:58.6566667+00:00
Mario Jaile 41 Reputation points
commented 2026-04-15T04:10:44+00:00
Akhil Gajavelly 1,735 Reputation points Microsoft External Staff Moderator
1 answer

microsoftt access problem

when i run my laptop always a notification is aheaded tha odbc microsoft log in failed but i dont want this how i can solve this problem

SQL Server Database Engine
asked 2025-11-27T04:53:57.7933333+00:00
Darshan Chandra Roy 0 Reputation points
commented 2026-04-15T04:08:40.2666667+00:00
Akhil Gajavelly 1,735 Reputation points Microsoft External Staff Moderator
1 answer

Restore procedure on a database when replication is enabled

Hi, I have a database in production for an application. Sometimes sometimes requires restores. Replication is enabled on the server as there is an ELT tool replicating the data to a data warehouse. There are 2 databases which are the Publishers but there…

SQL Server Database Engine
asked 2026-04-14T04:46:13.4833333+00:00
Mohammed Misselmany 0 Reputation points
answered 2026-04-14T22:02:08.2366667+00:00
Marcin Policht 85,750 Reputation points MVP Volunteer Moderator
2 answers

xa_recover buffer corruption with gtrid/bqual != 64 [ODBC Driver 18 for SQL Server]

I have noticed whenever I have a XID with gtrid and/or bqual length != 64, that xa_recover only returns sizeBuffer = 140 (1 XID) even though i have prepared 2 XA Transactions. If I have gtrid/bqual length both 64 I get sizeBuffer = 280 (2 XIDs) and can…

SQL Server Database Engine
asked 2025-10-09T09:26:45.0266667+00:00
AdventureT 20 Reputation points
recommended 2026-04-14T11:16:31.45+00:00
Erland Sommarskog 133.7K Reputation points MVP Volunteer Moderator