21,424 questions with SQL Server-related tags

Sort by: Updated
3 answers One of the answers was accepted by the question author.

model_replicatedmaster.ldf move to another drive

Hi all, I'm curios about this 2 new DB (system). I'm moving all ".ldf" file to a single drive... but they are related (seems to me) to HA. I read this post …

SQL Server | Other
asked 2022-05-17T14:28:30.69+00:00
Alen Cappelletti 1,047 Reputation points
edited a comment 2026-02-27T22:34:05.8866667+00:00
Erland Sommarskog 132.7K Reputation points MVP Volunteer Moderator
0 answers

Login failed for user '{username}'. Reason: Failed to open the explicitly specified database ''.

I recently upgraded to SSMS 22. When I connect to our database and run a query, I randomly get the following message in our event log becuase we track failed login attempts. Login failed for user ''. Reason: Failed to open the explicitly specified…

SQL Server Database Engine
asked 2026-02-27T18:26:54.9533333+00:00
Mike Seyfert 0 Reputation points
commented 2026-02-27T19:19:03.0366667+00:00
Erland Sommarskog 132.7K Reputation points MVP Volunteer Moderator
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
Akash Bhat 0 Reputation points
commented 2026-02-27T19:08:20.0266667+00:00
Erland Sommarskog 132.7K Reputation points MVP Volunteer Moderator
1 answer

Issues with Windows SQL update that my hardware provider can't seem to figure out

Hello, I am a Mac user in my personal life (mostly) and when it comes to the set up of the computers for my veterinary clinic, it all mostly goes over my head. The host server was recently "repaired," and what that means is a memory refresh…

SQL Server | Other
asked 2026-02-26T21:28:44.3133333+00:00
IRVC Staff 0 Reputation points
commented 2026-02-27T10:43:31.8966667+00:00
Erland Sommarskog 132.7K Reputation points MVP Volunteer Moderator
1 answer

V3056646 Numaralı Open Value SQL Server Lisansımızı M365 Panelinde Görüntüleyemiyoruz

Merhaba, Ostim Teknik Üniversitesi olarak V3056646 numaralı Open Value Subscription kapsamında SQL Server lisansımız bulunmaktadır (Sözleşme başlangıcı: 14 Mart 2025). Ancak Global Admin yetkisine sahip hesabımızla Microsoft 365 Yönetim Merkezi'ne giriş…

SQL Server | Other
asked 2026-02-26T08:38:45.6666667+00:00
Ali Cavlak 0 Reputation points
answered 2026-02-27T03:44:03.9833333+00:00
Lakshmi Narayana Garikapati 920 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

SQL Migrate feature on SSMS v22

Hi all, i tried use Migrate SQL Server on SSMS v22, some field column selection at Assessment type was ok but only SQL Server feature party was not active, it grey out status when I select another Target Platform than SQL Server 2025 anyone know about…

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.
604 questions
asked 2026-02-27T02:40:52.16+00:00
Urbel 420 Reputation points
accepted 2026-02-27T02:42:43.46+00:00
Urbel 420 Reputation points
2 answers One of the answers was accepted by the question author.

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.
604 questions
asked 2026-02-25T03:10:38.7033333+00:00
Urbel 420 Reputation points
commented 2026-02-27T02:30:31.6033333+00:00
Urbel 420 Reputation points
1 answer

Cannot install SQL Server 2025 Express with WinGet

Running the following script code: winget install --id Microsoft.SQLServer.2025.Express -s winget Echos the following message: Microsoft (R) SQL Server Installer Copyright (c) 2025 Microsoft. All rights reserved. Operation finished with result:…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
3 questions
asked 2026-02-26T08:21:03.1133333+00:00
PtJade Ceramic 0 Reputation points
edited a comment 2026-02-26T20:47:24.4+00:00
Erland Sommarskog 132.7K Reputation points MVP Volunteer Moderator
1 answer

Urgent – Unable to Purchase SQL Server 2022 (Compatibility Issue with Vendor Software)

Hi, We urgently need SQL Server 2022 as our current ERP system is only compatible with that version. However, all Microsoft resellers we’ve contacted are only offering SQL Server 2025, and we’ve been told 2022 may no longer be available for new…

SQL Server | Other
asked 2026-02-26T01:51:23.7333333+00:00
Michelle L 0 Reputation points
answered 2026-02-26T20:46:25.2666667+00:00
Erland Sommarskog 132.7K Reputation points MVP Volunteer Moderator
2 answers

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
Louis Davidson 21 Reputation points
answered 2026-02-26T20:04:49.13+00:00
Erland Sommarskog 132.7K Reputation points MVP Volunteer Moderator
1 answer

SSRS with Fabric as a source

Hi All, Is it possible to have a Fabric SQL database/ Fabric warehouse as a datasource for SSRS report? There is no proper documentation which I could see across. Fabric sources doesn't support SQL auth, So is it possible to access them via SSRS via…

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,142 questions
asked 2026-02-26T13:56:01.9033333+00:00
BharathKumarS-1759 65 Reputation points
answered 2026-02-26T14:42:00.8266667+00:00
Marcin Policht 79,825 Reputation points MVP Volunteer Moderator
1 answer

No SQL Instances or Shared Services on WSUS server

I have a server running WSUS, we realised that we hadn't been updating SQL and I got as installing KB5046063 to bring it up to 13.0.6450.1 and it will go no further. When installing any further updates I get an error "Error: There are no SQL Server…

SQL Server | Other
asked 2026-02-23T15:01:07.55+00:00
Paul Baldwin 0 Reputation points
commented 2026-02-26T13:32:59.27+00:00
Anjan Kumar Chippa (Quadrant Resource LLC) 0 Reputation points Microsoft External Staff Moderator
1 answer

Upgrade sql server integration services from sql 2016 to sql 2022

Hi We have a server using SQL 2016 , including integration services SSIS 2016. We use the catalog ( SSISB) to store the SSIS projects and packages, and have sql agent jobs with steps of type " SQl server integration services" that run pakcages…

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-23T11:57:04.91+00:00
Greg Booth 1,456 Reputation points
commented 2026-02-26T13:26:22.82+00:00
Anjan Kumar Chippa (Quadrant Resource LLC) 0 Reputation points Microsoft External Staff Moderator
2 answers

SSMS failed to install

Hi, Anyone who has knowledge on install the SSMS for me? I have attempted to fix this on technical support from Microsoft and consulted to them it wouldn't install at all. Any Idea how to fix this?

SQL Server | Other
asked 2025-11-05T10:12:36.1466667+00:00
sanjay kumar 0 Reputation points
commented 2026-02-26T13:25:06.2233333+00:00
Anjan Kumar Chippa (Quadrant Resource LLC) 0 Reputation points Microsoft External Staff Moderator
2 answers

How to fix error received while inserting into table through report builder into oracle database

I am trying to insert records through report builder into oracle database and it is showing dataset related 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,142 questions
asked 2026-02-17T17:02:14.06+00:00
Madani, Ramya Krishna 0 Reputation points
commented 2026-02-26T12:18:13.9466667+00:00
Madani, Ramya Krishna 0 Reputation points
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
asked 2026-02-21T13:32:24.1533333+00:00
Abdelrahman Hany 0 Reputation points
edited a comment 2026-02-26T11:21:02.5333333+00:00
Abdelrahman Hany 0 Reputation points
1 answer

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
asked 2026-02-25T22:10:45.2+00:00
Ammo Parmar 0 Reputation points
edited an answer 2026-02-26T07:22:19.6066667+00:00
RatheeshKNair 6 Reputation points
1 answer

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
asked 2026-02-25T22:25:54.2266667+00:00
Garrett Settles 0 Reputation points
answered 2026-02-26T06:30:12.77+00:00
Akhil Gajavelly 1,555 Reputation points Microsoft External Staff 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.
604 questions
asked 2026-02-25T06:50:22.2766667+00:00
Urbel 420 Reputation points
answered 2026-02-25T22:11:38.1566667+00:00
Erland Sommarskog 132.7K 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
asked 2026-02-25T07:07:51.5366667+00:00
vivek singh 20 Reputation points
answered 2026-02-25T22:06:23.6266667+00:00
Erland Sommarskog 132.7K Reputation points MVP Volunteer Moderator