21,564 questions with SQL Server-related tags

Sort by: Updated
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

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-30T06:47:08.9666667+00:00
Michelle 0 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
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-29T15:34:52.3+00:00
Erland Sommarskog 133.9K Reputation points MVP Volunteer 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
1 answer

Issues with SSIS packages after upgrading SQLServer from 2019 to 2022.

These packages have been running successfully for years, but failed after upgrading SQLserver to 2022. Further detail: the package contains a Script task (VB) that creates and populates files on the file system (either excel or PDF). We have two…

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-28T18:10:56.7+00:00
Ben Pflanzer 0 Reputation points
commented 2026-04-29T12:13:29.7+00:00
Erland Sommarskog 133.9K Reputation points MVP Volunteer Moderator
1 answer

SSIS Package Fails with System.Data.SQLite Could Not Load Error (E_POINTER)

I have deployed an SSIS project using an .ispac file into SSISDB. The project contains Cdata Odoo components and Kingswaysoft toolkit. When I try to execute the package (both from SSISDB and from Visual Studio), it fails with the following…

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-29T06:12:42.41+00:00
Ishika Raiyani 20 Reputation points
commented 2026-04-29T10:04:13.5333333+00:00
Ishika Raiyani 20 Reputation points
1 answer

SQL Agent job fails to run Restart-Service but works interactively

I have a SQL Agent job that runs a CmdExec step using a proxy account. The text of this step is: powershell.exe -ExecutionPolicy Bypass -File D:\Scripts\RestartService.ps1 The content of this script is: Restart-Service -DisplayName "Some…

SQL Server Database Engine
asked 2026-04-28T10:24:00.1766667+00:00
Peter Bishop 256 Reputation points
commented 2026-04-29T09:06:51.69+00:00
Erland Sommarskog 133.9K Reputation points MVP Volunteer Moderator