21,670 questions with SQL Server-related tags

Sort by: Updated
2 answers

MSOLEDBSQL 19.4.1 — TrustServerCertificate=True does not bypass certificate validation (works in driver 18)

Environment: Windows Server 2022 client MSOLEDBSQL 19.4.1.0 (msoledbsql19.dll) SQL Server 2022, Force Encryption = Yes, default self-signed cert (CN=SSL_Self_Signed_Fallback, no SAN) Problem: The following connection string fails on driver 19 with…

SQL Server Database Engine
asked 2026-07-13T10:30:12.8133333+00:00
Abhishek Modi (amodi) 20 Reputation points
answered 2026-07-13T19:31:13.11+00:00
Deepesh Dhake 650 Reputation points
2 answers

Clarification on MSOLEDBSQL19 Behavior with TrustServerCertificate=True

Hello Team, We are currently using the MSOLEDBSQL19 driver on Windows systems and would like to better understand its connection behavior related to encryption and certificate validation. While testing SQL Server connectivity, we observed that a…

SQL Server Database Engine
asked 2026-07-13T09:22:07.6666667+00:00
Abhishek Modi (amodi) 20 Reputation points
answered 2026-07-13T16:38:19.7933333+00:00
Deepesh Dhake 650 Reputation points
1 answer

How can I request access for my team to access Preform Certs

My team had access previously to [http://ssrs2012/Reports_SSRS2012/report/Quality%20Control/Quality%20Control%20-%20NA/PreformCerts] and now they are not able to access it.

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,168 questions
asked 2026-07-13T15:46:58.41+00:00
Bugarin, Jimena Y 0 Reputation points
answered 2026-07-13T15:47:11.0066667+00:00

AI answer

1 answer

SQL Server 2025 CU6 Serious Defect

SQL Server 2025 CU6 lists Linked Servers as a "Known Issue" - the workarounds are terrible - this needs fixing urgent. To summarise, users will get "Access to the remote server is denied because no login-mapping exists." when trying…

SQL Server Database Engine
asked 2026-07-13T14:25:34.9966667+00:00
JP 0 Reputation points
answered 2026-07-13T15:01:52.2333333+00:00
Bruce (SqlWork.com) 84,501 Reputation points
3 answers

Install SQL Management Studio without Visual Studio Tools or Shell

Hi there, I am doing some pen test remediation and our SQL servers are flagging that Visual Studio tools such as Shell (isolated) and Tools for applications are vulnerable. So i've been trying to find a way to install SSMS without Visual Studio at all as…

Windows for business | Windows Server | User experience | Other
SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,765 questions
asked 2023-11-24T14:04:03.66+00:00
TheLoops 11 Reputation points
answered 2026-07-13T11:24:56.1533333+00:00
JM 10 Reputation points
2 answers

I need to create a remote connection to SQL Server (a login and password too).

I am getting errors installing FEMA's HAZUS Pro software which uses ESRI ArcGIS Pro as it's map engine. The failure is because the ArcGIS program will not connect to the SQL database. ESRI support says I have to configure SQL server to accept remote…

SQL Server Database Engine
asked 2026-07-10T22:29:19.01+00:00
Candace Snipes 0 Reputation points
edited an answer 2026-07-11T15:13:05.22+00:00
Bruce (SqlWork.com) 84,501 Reputation points
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-10T20:04:56.9933333+00:00
Weezelboy 1 Reputation point
2 answers

SQL Server Install Error

I have tried to install SQL Server on two separate laptops. I've tried both developer and express versions. I keep getting the following message box and can't get it to install. On Widows 11

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,765 questions
asked 2026-07-09T21:27:55.0866667+00:00
KEVIN SEGUIN 0 Reputation points
answered 2026-07-10T19:10:25.33+00:00
Deepesh Dhake 650 Reputation points
3 answers

how do you download and install SQL Server

how do you download and install SQL Server onto a new PC

SQL Server Database Engine
asked 2026-07-09T21:20:18.6866667+00:00
Joe English 0 Reputation points
edited an answer 2026-07-10T15:26:05.9333333+00:00
Bruce (SqlWork.com) 84,501 Reputation points
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.6K 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,765 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.6K 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,765 questions
asked 2026-07-07T17:22:22.5966667+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.6K 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,765 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,765 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.6K 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