21,677 questions with SQL Server-related tags

Sort by: Updated
2 answers

SQL server 2025 Enterprise Developer edition connection

I installed a new SQL server 2025 Enterprise developer edition for our development environment. this is our first 2025 instance. I can connect to the server and database using a SSMS installed locally on the server, but cannot connect to it use my laptop…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,769 questions
asked 2026-07-15T23:15:15.88+00:00
AnneW 86 Reputation points
answered 2026-07-16T08:12:23.5566667+00:00
Erland Sommarskog 135.6K Reputation points MVP Volunteer Moderator
1 answer

Clarification Required: SQL Server 2014 ESU Coverage for LocalDB Security Vulnerabilities

We are working with a customer that has identified vulnerability findings against SQL Server 2014 LocalDB components and is evaluating the purchase of SQL Server 2014 Extended Security Updates (ESU) through Azure. Before proceeding, the customer is…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,769 questions
asked 2026-07-16T07:34:00.25+00:00
Lucy Sharman 0 Reputation points
answered 2026-07-16T08:05:20.3+00:00
Erland Sommarskog 135.6K Reputation points MVP Volunteer Moderator
2 answers

Allow creating a new index scoped to a single partition (per-partition index creation)

Currently, when a table is partitioned in SQL Server, any new index created is automatically built across all partitions of the table — there's no way to create an index that applies to only a specific partition. This forces a full-table index build even…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,769 questions
asked 2026-07-15T13:13:36.3933333+00:00
Shimon Ferdinaro 0 Reputation points
answered 2026-07-15T21:51:34.06+00:00
Erland Sommarskog 135.6K Reputation points MVP Volunteer Moderator
1 answer

How to solve SQR error not installing successfully

I am struggling installing SQL server 2025. Am getting error messages before completion

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,769 questions
asked 2026-07-15T15:45:04.46+00:00
KINGSLEY Wanka CHINGWALU 0 Reputation points
commented 2026-07-15T21:46:14.9766667+00:00
Erland Sommarskog 135.6K Reputation points MVP Volunteer Moderator
3 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
commented 2026-07-15T21:35:28.3033333+00:00
Erland Sommarskog 135.6K Reputation points MVP Volunteer Moderator
2 answers One of the answers was accepted by the question author.

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 20 Reputation points
commented 2026-07-15T15:23:35.9133333+00:00
Candace Snipes 20 Reputation points
0 answers

Visual Studio 2022 Enterprise - SSDT - Nessus Vulnerabilities

Hello support team, We want to install SSDT vsix for Visual Studio Enterprise 2022. Our vulnerability assessment solution Nessus is highlighting SSDT component as critical vulnerabilities concerning following files which are packaged with SSDT. Is there…

SQL Server Integration Services
SQL Server Integration Services

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

2,801 questions
asked 2026-07-15T13:33:57.0233333+00:00
GallW 0 Reputation points
edited the question 2026-07-15T14:11:56.8366667+00:00
GallW 0 Reputation points
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
commented 2026-07-15T12:31:20.7833333+00:00
Abhishek Modi (amodi) 20 Reputation points
1 answer

Replication Monitor fails with "requires actual server name" when Distributor is on Always On AG registered via Listener Name — SQL Server 2022

Environment: SQL Server 2022 RTM-CU22 (KB5068450) - 16.0.4225.2 (X64) SSMS 19.x and 20.7.0 (tested both — same behavior on each) Publisher: PUBLISHER_HOST (standalone, default instance) Publisher Database: PUBLISHER_DB Distributor: Hosted on Always…

SQL Server Database Engine
asked 2026-07-14T01:09:46.5633333+00:00
Don Ferguson 0 Reputation points
recommended 2026-07-14T21:33:40.04+00:00
Erland Sommarskog 135.6K Reputation points MVP Volunteer Moderator
0 answers

How to see reason code of stock adjustments

How do I generate a report where I can see adjustments to the Item Ledger Entries and the reason code used to adjust the items?

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,169 questions
asked 2026-07-14T14:09:01.0433333+00:00
Daren Ali 0 Reputation points
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
commented 2026-07-13T21:21:01.1366667+00:00
Erland Sommarskog 135.6K Reputation points MVP Volunteer Moderator
2 answers

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,169 questions
asked 2026-07-13T15:46:58.41+00:00
Bugarin, Jimena Y 0 Reputation points
answered 2026-07-13T21:16:01.3366667+00:00
Erland Sommarskog 135.6K Reputation points MVP Volunteer Moderator
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,769 questions
asked 2023-11-24T14:04:03.66+00:00
TheLoops 11 Reputation points
commented 2026-07-13T21:12:50.3266667+00:00
Erland Sommarskog 135.6K Reputation points MVP Volunteer Moderator
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,769 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 655 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,671 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,769 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,769 questions
asked 2026-07-07T17:22:22.5966667+00:00
Mohit Sharma (HCL Technologies Corporate Ser) 0 Reputation points Microsoft External Staff