21,567 questions with SQL Server-related tags

Sort by: Updated
1 answer

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-04-30T19:51:11.52+00:00
Erland Sommarskog 133.9K Reputation points MVP Volunteer Moderator
2 answers

Table constraint design to avoid a cycle

In the minimal reproducible example below, table C is invalid as it results in a cycle. I understand I can simplify C by removing the constraints, however the number of triggers required after goes up significantly if I want to preserve the cascading…

SQL Server | SQL Server Transact-SQL
asked 2026-04-30T17:15:13.18+00:00
ritmo2k 871 Reputation points
commented 2026-04-30T19:47:03.9166667+00:00
Erland Sommarskog 133.9K Reputation points MVP Volunteer Moderator
2 answers

Tell me most used SQL server administration tools and some examples

I need to cover the most commonly used tools for administering SQL Server, such as SSMS, Azure Data Studio, sqlcmd, etc., along with practical examples of how each tool is used. Could anyone provide an overview of the most popular SQL Server admin tools…

SQL Server Database Engine
asked 2026-04-29T22:12:54.1066667+00:00
Gurdeep Vaidya 0 Reputation points
edited the question 2026-04-30T18:37:51.9033333+00:00
Erland Sommarskog 133.9K Reputation points MVP Volunteer Moderator
0 answers

Sudden "Data source access error" with On-Premises Gateway and SSAS Tabular 2016

Hi everyone, We are experiencing a critical issue with a Power BI Report (Premium Capacity) connected to an on-premises SSAS Tabular instance (v13.0.6300.2) via On-premises data gateway (v3000.314.5). Everything has been working perfectly for years, but…

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,372 questions
asked 2026-04-30T15:51:47.4633333+00:00
Davide Mari 0 Reputation points
answered 2026-04-30T15:52:27.43+00:00
Q&A Assist
0 answers

SQL Snapshot Replication Fails with BCP EOF / NULL Errors (Works in Transactional Replication)

Issue: We have Snapshot Replication on a production server that was working fine but recently started failing with the below error: Agent message code 20037. The process could not bulk copy into table "XXX". Message: End of file…

SQL Server | Other
asked 2026-04-29T12:20:04.25+00:00
Parag Nimbhore 0 Reputation points
commented 2026-04-30T13:55:55.76+00:00
Erland Sommarskog 133.9K Reputation points MVP Volunteer Moderator
2 answers One of the answers was accepted by the question author.

Linkage issue to express 2017

Hi, To Sql express 2017, I got the issue like A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not…

SQL Server | Other
asked 2026-04-29T03:53:13.83+00:00
Scott Huang 3,426 Reputation points
edited a comment 2026-04-30T06:54:52.98+00:00
Scott Huang 3,426 Reputation points
1 answer

What is the proper syntax

Hi, According to the documentation at https://learn.microsoft.com/en-us/sql/t-sql/statements/create-table-transact-sql?view=sql-server-ver17, I can use the following syntax: ALTER TABLE [draft].[dbo].[temp2] ADD PRIMARY KEY(id) WITH( FILLFACTOR = 20 |…

SQL Server Database Engine
asked 2026-03-27T22:37:37.0366667+00:00
Igor Korot 56 Reputation points
recommended 2026-04-30T05:27:45.73+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
2 answers

Not able to install Microsoft SQL Express

I have attempted installation multiple times, but it keeps failing. Steps I have already tried: Cleaned up old SQL Server components and services Verified prerequisites (.NET Framework 4.8, Visual C++ Redistributables, Windows updates) Ran installer…

SQL Server Database Engine
asked 2026-03-26T16:15:30.4366667+00:00
Bobbala Anusha 0 Reputation points
recommended 2026-04-30T05:27:24.1+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
2 answers

how to use azure communications service for smtp

SQL Reporting Services sending subscription emails

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,156 questions
asked 2026-02-10T18:45:30.46+00:00
JamesPierce-6019 0 Reputation points
recommended 2026-04-30T05:27:04.9766667+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
3 answers

Get Data With Power BI - unable to get data from SQL Server

in taking course via learn.microsoft.com - get data with power bi, I receive (for 2 days now) msg - Unable to Connect. "Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server…

SQL Server | Other
asked 2026-02-28T15:53:48.6066667+00:00
KF-3028 0 Reputation points
recommended 2026-04-30T05:26:36.43+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
2 answers

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.

4 questions
asked 2026-02-26T08:21:03.1133333+00:00
PtJade Ceramic 0 Reputation points
recommended 2026-04-30T05:26:07.6+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
2 answers

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
recommended 2026-04-30T05:25:40.5666667+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
2 answers

Unable to connect to SQL Server for Learning Labs

It has happened in several labs (Get data in Power BI and Prepare data for analysis in Power BI). I've tried clearing cookies/cache but still just get error messages. DataSource.Error: Microsoft SQL: A network-related or instance-specific error occurred…

SQL Server | Other
asked 2026-02-25T21:18:47.5066667+00:00
Ammo Parmar 0 Reputation points
recommended 2026-04-30T05:25:22.79+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
3 answers

SSMA for Db2 cannot connect to Db2 running on AIX.

SSMA for Db2 cannot connect to Db2 running on AIX. connection string is: Provider=DB2OLEDB;Password=[password];Persist Security Info=True;User ID=[UserId];Initial Catalog=[DB Name];Data Source=[DB Name];Authentication=Server_Encrypt_Pwd;Network…

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-20T02:22:21.9466667+00:00
Ikuo Takekawa/竹川 育夫 0 Reputation points
commented 2026-04-30T05:04:41.58+00:00
Akhil Gajavelly 1,820 Reputation points Microsoft External Staff Moderator
1 answer

transactional replication between non-domain servers

Hi all, I have two sql server database servers. These are on the same network but there is no domain server. Can I configure these servers for transactional replication ? I know this is possible but how? Any document do you have to do this? Any…

SQL Server Database Engine
asked 2026-04-24T11:40:43.4133333+00:00
yunus emre ISIK 261 Reputation points
commented 2026-04-30T04:47:16.9966667+00:00
Lakshmi Narayana Garikapati 1,310 Reputation points Microsoft External Staff Moderator
2 answers

Sql server 2025 installation error

Hello Microsoft Support Team, I am reaching out regarding an installation issue with Microsoft SQL Server 2025 (Express Edition) on my ASUS TUF Gaming A15 laptop running Windows 10 Home Single Language (Build 26200). During installation, the server fails…

SQL Server Database Engine
asked 2026-04-20T17:33:12.6733333+00:00
sanjay MN 0 Reputation points
commented 2026-04-30T04:43:14.7666667+00:00
Lakshmi Narayana Garikapati 1,310 Reputation points Microsoft External Staff Moderator
1 answer

SQL Server Login Failures (Error 18456) due to Reporting Services attempting to access non-existent ReportServer database

We are experiencing repeated SQL Server login failures (Event ID 18456) on one of our servers. Details: SQL Server Version: SQL Server 2016 Error Message: "Login failed for user 'REA\IND-WBN-DEV$'. Reason: Failed to open the explicitly specified…

SQL Server Database Engine
asked 2026-04-17T07:24:16.13+00:00
Kamarur Rama 0 Reputation points
commented 2026-04-30T04:41:19.7566667+00:00
Lakshmi Narayana Garikapati 1,310 Reputation points Microsoft External Staff Moderator
1 answer

SSIS 2019/2022 - Teradata 20.00 - Microsoft Teradata Connector - Source and Destination not showing in SSIS Toolbox after installation

I have to upgrade to Teradata 20.00 and cannot get the Teradata Source and Destination Tools to show up in SSIS 2022 with VS2022. I have tried with the packages targeting 2019 and 2022. The installation of the connector itself claims to have been…

SQL Server Integration Services
SQL Server Integration Services

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

2,789 questions
asked 2026-04-29T15:20:20.2533333+00:00
Susann 0 Reputation points
answered 2026-04-29T15:21:00.58+00:00
Q&A Assist
2 answers

vs_SSMS installation - Destination URLs

Dear all, I'm installing vs_SSMS (SQL Server Management Studio) on a client's server. I requested them to open internet connection to be able to install SSMS as i know that the installation once it runs, will download the required files. The client's IT…

SQL Server Database Engine
asked 2026-01-13T12:48:10.6633333+00:00
Alaa Al Halabi 0 Reputation points
commented 2026-04-29T14:49:37.47+00:00
Newman, Scott 0 Reputation points
1 answer

SQL Server Audit / Extended Events – Role‑based (sysadmin) filtering limitations

Hello Microsoft Team, We are implementing security monitoring for sysadmin account usage on an on‑premises SQL Server instance and would like to know what EX events or Audit to achieve our goal? We tried Audit and XE events but those are capturing all…

SQL Server Database Engine
asked 2026-04-24T17:19:09.7+00:00
Uday Paleti 0 Reputation points
commented 2026-04-29T13:06:36.3866667+00:00
Uday Paleti 0 Reputation points