283 questions
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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 53%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
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
283 questions
asked 2026-04-30T17:15:13.18+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 93%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
696 questions
asked 2026-04-29T22:12:54.1066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 67%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGV%3C/text%3E%3C/svg%3E)
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
14,735 questions
asked 2026-04-29T12:20:04.25+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 81%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPN%3C/text%3E%3C/svg%3E)
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
14,735 questions
asked 2026-04-29T03:53:13.83+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 43%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESH%3C/text%3E%3C/svg%3E)
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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
696 questions
asked 2026-03-27T22:37:37.0366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 3%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIK%3C/text%3E%3C/svg%3E)
Igor Korot
56
Reputation points
recommended 2026-04-30T05:27:45.73+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 39%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
696 questions
asked 2026-03-26T16:15:30.4366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(112.00000000000001, 2%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBA%3C/text%3E%3C/svg%3E)
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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 0%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ6%3C/text%3E%3C/svg%3E)
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
14,735 questions
asked 2026-02-28T15:53:48.6066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 55.00000000000001%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK3%3C/text%3E%3C/svg%3E)
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
14,735 questions
asked 2026-02-25T22:25:54.2266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 26%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
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
14,735 questions
asked 2026-02-25T21:18:47.5066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 78%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 64%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIT%3C/text%3E%3C/svg%3E)
Ikuo Takekawa/竹川 育夫
0
Reputation points
commented 2026-04-30T05:04:41.58+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 49%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
696 questions
asked 2026-04-24T11:40:43.4133333+00:00
yunus emre ISIK
261
Reputation points
commented 2026-04-30T04:47:16.9966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 35%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELN%3C/text%3E%3C/svg%3E)
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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
696 questions
asked 2026-04-20T17:33:12.6733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(131.20000000000002, 98%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
696 questions
asked 2026-04-17T07:24:16.13+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 93%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKR%3C/text%3E%3C/svg%3E)
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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 57.99999999999999%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
696 questions
asked 2026-01-13T12:48:10.6633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 57.99999999999999%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Alaa Al Halabi
0
Reputation points
commented 2026-04-29T14:49:37.47+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(176, 67%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
696 questions
asked 2026-04-24T17:19:09.7+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 31%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUP%3C/text%3E%3C/svg%3E)
Uday Paleti
0
Reputation points
commented 2026-04-29T13:06:36.3866667+00:00
Uday Paleti
0
Reputation points