21,663 questions with SQL Server-related tags

Sort by: Updated
1 answer

SQL Server 2025 — BACKUP/RESTORE TO URL fails with OS error 13 on all Azure Blob SAS credentials

On SQL Server 2025 (17.0.4055.5, RTM-CU6), every BACKUP TO URL and RESTORE FROM URL against Azure Blob Storage fails with Msg 3201 ... Operating system error 13 (The data is invalid.), while the identical SAS token and blob succeed from a SQL Server 2017…

SQL Server Database Engine
asked 2026-07-07T21:17:01.86+00:00
Weezelboy 1 Reputation point
commented 2026-07-08T20:28:31.05+00:00
Erland Sommarskog 135.5K Reputation points MVP Volunteer Moderator
2 answers

BULK INSERT cannot access UNC path, error code 5 (Access is denied) using gMSA unless locally triggered

Running a stored procedure to bulk insert from a UNC path works locally via SSMS and via SQL agent job but if run remotely I receive Operating system error code 5 (access is denied). Please help as this workaround is not suitable for our…

SQL Server | SQL Server Transact-SQL
asked 2026-04-28T02:03:11.9766667+00:00
Michelle 0 Reputation points
commented 2026-07-08T15:51:19.9433333+00:00
Lavoie, Mathieu 0 Reputation points
0 answers

Vulnerability detected: SMB2/BruteForceAttempt.UN!SP.35605 Description: SMB Bruteforce Attempt Detected

Dear Team, Please check the server, as we have detected a potential unauthorized attack. The following AMSI detection was observed: AMSI: \Device\HarddiskVolume4\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Binn\sqlservr.exe Kindly…

SQL Server Database Engine
asked 2026-07-08T13:08:43.56+00:00
Vishnu Kant Maurya 0 Reputation points
commented 2026-07-08T14:48:46.77+00:00
Erland Sommarskog 135.5K Reputation points MVP Volunteer Moderator
1 answer

GitHub Copilot in SSMS throws below error in Latest Version 22.7.2

GitHub Copilot in SSMS throws below error in Latest Version 22.7.2: An exception was encountered while constructing the content of this frame. This information is also logged in…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,764 questions
asked 2026-07-08T03:58:29.0766667+00:00
Ren, Sandy [IT, SH] 0 Reputation points
answered 2026-07-08T08:58:29.81+00:00
Erland Sommarskog 135.5K Reputation points MVP Volunteer Moderator
0 answers

How to add table permission in Power platform entity

How to add table permission in Power platform entity

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,764 questions
asked 2026-07-07T17:22:22.5966667+00:00
Mohit Sharma (HCL Technologies Corporate Ser) 0 Reputation points Microsoft External Staff
edited an answer 2026-07-07T17:38:29.73+00:00
Mohit Sharma (HCL Technologies Corporate Ser) 0 Reputation points Microsoft External Staff
1 answer

ODBC Driver Issue with ARM64: Native Heap corruption.

Hello Microsoft Team, We are facing an issue when using ODBC Driver on ARM64 Linux(Graviton on AWS infra). There is a native memory corruption happening due to mssqlodbc driver v18 causing the application to stall/crash. Below are the details around…

SQL Server Database Engine
asked 2026-07-07T12:37:49.61+00:00
Yash Jain 5 Reputation points
answered 2026-07-07T13:49:02.54+00:00
Erland Sommarskog 135.5K Reputation points MVP Volunteer Moderator
3 answers One of the answers was accepted by the question author.

SQL Server Doesn't Start Automatically

Good morning. After starting my computer, the SQL Server instance doesn't start automatically. I have to start it manually by restarting the service. This happens in both startup modes: automatic and automatic (delayed start). SQL Version: Microsoft…

SQL Server Database Engine
asked 2026-07-04T10:18:18.5666667+00:00
Waldemar Czarnecki 80 Reputation points
accepted 2026-07-07T11:00:04.5366667+00:00
Waldemar Czarnecki 80 Reputation points
3 answers One of the answers was accepted by the question author.

2.5TB Distribution DB. Distribution Cleanup Agent not running from 1.5 years

Distribution cleanup agent was not running from 1.5 years. Started running it gradually by giving max_distretention hours equivalent to 1.5 years and reducing it by 15 hours in next run. Ex: 1st run: EXEC dbo.sp_MSdistribution_cleanup…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,764 questions
asked 2026-07-04T08:59:24.4933333+00:00
Sowjanya Gopal 100 Reputation points
commented 2026-07-07T08:54:43.96+00:00
Sowjanya Gopal 100 Reputation points
4 answers One of the answers was accepted by the question author.

Bulk deletes in Transaction Replication causing latency

 Hi. I have around 10 publications on a database from Prod Server A to Reporting Server B. Created multiple publications so that any issue with one publication will not impact other publications. There is a single huge article in one publication. Due to…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,764 questions
asked 2026-07-01T17:16:50.05+00:00
Sowjanya Gopal 100 Reputation points
accepted 2026-07-07T08:51:30.7933333+00:00
Sowjanya Gopal 100 Reputation points
4 answers

Issue to access

Hi, Can you help to this? TITLE: Error 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 Database Engine
asked 2026-07-06T01:55:38.21+00:00
Jonathan 300 Reputation points
edited a comment 2026-07-06T10:19:09.1766667+00:00
Jonathan 300 Reputation points
1 answer

Error 8624, Severity 16: Internal Query Processor Error: The query processor could not produce a query plan.

Hi, Environrment : SQL Server 2022, build 16.0.4252.3 (CU24 + GDR, May 2026) We are experiencing an intermittent issue on Microsoft SQL Server 2022 Enterprise Edition running in an Always On Availability Group environment.A specific stored procedure…

SQL Server Database Engine
asked 2026-07-05T10:07:13.09+00:00
Mohanraj Selvarasu 20 Reputation points
edited a comment 2026-07-06T09:41:11.4566667+00:00
Erland Sommarskog 135.5K Reputation points MVP Volunteer Moderator
2 answers One of the answers was accepted by the question author.

How can I import a SSIS package to our SSDT?

Although a SSIS package is running on our SQLServer2017, we lost that source file. Which is a dtsx file. Then we plan to migrate everything from SQLServer2017 to 2022, we need to see the design and change some information of this package. How can I…

SQL Server Integration Services
SQL Server Integration Services

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

2,800 questions
asked 2026-07-05T09:50:19.8366667+00:00
けたとんしゃん 25 Reputation points
commented 2026-07-05T23:40:23.8666667+00:00
けたとんしゃん 25 Reputation points
1 answer

Migrate Azure resources from one tenant to another tenant

Hi Team, I am looking for some guidance to know the best approach to migration Azure VM and other resources from one tenant to another tenant (we can consider a situation where company has been acquired or getting separated), what are the possible…

Azure Migrate
Azure Migrate

A central hub of Azure cloud migration services and tools to discover, assess, and migrate workloads to the cloud.

1,110 questions
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.

607 questions
Windows for business | Windows Server | Devices and deployment | Set up, install, or upgrade
asked 2023-10-20T11:50:56.3766667+00:00
Gautam Gulati 50 Reputation points
commented 2026-07-05T08:25:13.88+00:00
NITIN GUPTA 1 Reputation point
1 answer

For backup stability and reliable recovery for running 2400 + DB , the memory issue needs to be addressed

Hi, For backup stability and reliable recovery for running 2400 + DB , the memory issue needs to be addressed. Can increasing physical memory in SQL Server help control or reduce SQL Server's memory footprint? Tomasz C.

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,764 questions
asked 2026-06-29T11:37:10.9+00:00
Ciolek, Tomasz 0 Reputation points
answered 2026-07-05T04:34:25.1466667+00:00
Deepesh Dhake 645 Reputation points
2 answers One of the answers was accepted by the question author.

If we purchase SQL Server 2025 Enterprise Edition, can we see the SQL Server 2022 installation media and key in the Microsoft 365 Admin Center?

Hi support team, We are going to use SQL Server 2022 Enterprise Edition. Before purchasing, may I know If we purchase SQL Server 2025 Enterprise Edition, can we see the SQL Server 2022 installation media and key in the Microsoft 365 Admin Center? It…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,764 questions
asked 2026-07-03T18:21:15.0833333+00:00
Runze Guo 20 Reputation points
commented 2026-07-05T00:47:03.1666667+00:00
Bruce (SqlWork.com) 84,496 Reputation points
1 answer

how to copy usermappings from one to another

how to copy user mappings from one to another for sql server database 2017 EE

SQL Server Database Engine
asked 2025-09-15T06:35:19.7766667+00:00
drmrdba 0 Reputation points
commented 2026-07-04T04:01:46.3733333+00:00
mawisec 0 Reputation points
3 answers

Prices for Sql server

Hi Everyone We're currently gathering pricing information for SQL Server as we're planning to purchase a license. If anyone has the latest pricing for the SQL Server Standard and Enterprise editions, could you please share it? Thanks! Thanks Jhols

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,764 questions
asked 2026-07-03T06:21:45.2633333+00:00
NeoJhols Slow 0 Reputation points
answered 2026-07-03T15:39:41.6333333+00:00
Bruce (SqlWork.com) 84,496 Reputation points
1 answer One of the answers was accepted by the question author.

Przy nadawaniu użytkownikowi 'sa' roli serveradmin otrzymuję komunikat błędu

Dzień dobry. Przy nadawaniu użytkownikowi 'sa' roli serveradmin otrzymuję komunikat błędu: TYTUŁ: Microsoft SQL Server Management Studio Operacja Dodaj członka nie powiodła się dla elementu ServerRole „serveradmin”. (Microsoft.SqlServer.Smo) Aby uzyskać…

SQL Server | SQL Server Transact-SQL
asked 2026-07-03T12:48:58.86+00:00
Waldemar Czarnecki 80 Reputation points
edited a comment 2026-07-03T14:44:05.39+00:00
Erland Sommarskog 135.5K Reputation points MVP Volunteer Moderator
2 answers One of the answers was accepted by the question author.

Official Download Link for MS SSMS v20.2.1

Hello Everyone, I am trying to upgrade my existing MS SSMS from v18.12.1 to v20.2.1 in one of my environments. I am looking for the installer, but I could not find one from the Microsoft Official website. This page of 20.2.1 takes me to the download of…

SQL Server Database Engine
asked 2026-01-01T11:35:25.28+00:00
Arkapriya Gupta 20 Reputation points
commented 2026-07-03T09:45:52.73+00:00
Erland Sommarskog 135.5K Reputation points MVP Volunteer Moderator
1 answer

Using Local account for setting HA SQL Always ON

Hi expert, I use NT Service\MSSQL$MySQL account to running SQL Service then i've got error on SQL err log; "..Database mirroring login attempt by user [Domain\Node1$] failed with error; Handshake failed with login [Domain\Node1$] does have no…

SQL Server Database Engine
asked 2026-07-03T06:53:01.38+00:00
Urbel 665 Reputation points
answered 2026-07-03T09:23:42.9433333+00:00
Erland Sommarskog 135.5K Reputation points MVP Volunteer Moderator