14,702 questions with SQL Server | Other tags

Sort by: Updated
1 answer

Please provide KB2000257

I would like to read the KB2000257 article. SQL Server Express 2022 is failing per the 3 local security policies error BUT the 3 policies are all set correctly! The failure is immediate and NO LOGS are produced yet.

SQL Server | Other
asked 2026-03-12T16:18:45.61+00:00
Phelan, Susan - FARMINGTON CT 0 Reputation points
commented 2026-03-12T22:15:11.41+00:00
Erland Sommarskog 133.2K Reputation points MVP Volunteer Moderator
2 answers

SQL Agent Job failing with Error 8152 (String or binary data would be truncated) during Replication/Distribution

Hi everyone, I am encountering a persistent failure in a SQL Server Agent Job that appears to be related to a Replication Distribution Agent. The Error: The job fails at Step 1 (Distribution Agent startup) or Step 3 (Detect nonlogged agent shutdown) with…

SQL Server | Other
asked 2026-03-12T19:52:40.2633333+00:00
Ramya 0 Reputation points
answered 2026-03-12T22:11:33.0133333+00:00
Erland Sommarskog 133.2K Reputation points MVP Volunteer Moderator
1 answer

When following SSIS Tutorial on microsoft learn I receive a data type error

I have following the Microsoft Learn SSIS tutorial and am currently on https://learn.microsoft.com/en-us/sql/integration-services/lesson-1-6-adding-and-configuring-the-lookup-transformations?view=sql-server-ver16 , trying to follow the below step: My…

SQL Server Integration Services
SQL Server Integration Services

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

2,778 questions
SQL Server | Other
asked 2024-07-31T10:19:36.55+00:00
Adam 0 Reputation points
commented 2026-03-12T14:07:44.4033333+00:00
Peter Schellhardt 0 Reputation points
1 answer
asked 2026-03-01T13:22:19.06+00:00
波 蔡陈 0 Reputation points
commented 2026-03-12T06:43:57.9033333+00:00
Akhil Gajavelly 1,570 Reputation points Microsoft External Staff Moderator
1 answer

How to fix SQL Server installation error and run successfully

I have repeatedly install Microsoft SQL 2025, though it show that the server is running but I have been unable to connect as I keep having error message; see below - TITLE: Error The client was unable to establish a connection because of an error during…

SQL Server | Other
asked 2026-03-10T23:13:31.24+00:00
Gregory Mwenketishi 0 Reputation points
commented 2026-03-11T21:41:40.93+00:00
Erland Sommarskog 133.2K Reputation points MVP Volunteer Moderator
4 answers One of the answers was accepted by the question author.

Can a SQLServer 2016 AG with one database be setup with two separate Managed Instance Links?

I’m planning a migration of a SQL Server 2016 Always On AG with a single 4TB database to Azure SQL Managed Instance. We already have one MI acting as a read‑replica for reporting and analytics. As part of the migration, I’m considering deploying a second…

SQL Server | Other
asked 2026-02-13T20:22:46.6633333+00:00
Abimbola Adeniran 106 Reputation points
accepted 2026-03-11T13:13:30.2233333+00:00
Abimbola Adeniran 106 Reputation points
2 answers

Import and Export Data option greyed out in SSMS 22 with SQL Server 2025 Developer

Hello, I am using SQL Server 2025 (RTM) – 17.0.1000.7 (Enterprise Developer Edition, 64-bit) on Windows 10 Pro. I installed: Database Engine Services (Default instance: MSSQLSERVER) Integration Services (added later via “Add features to existing…

SQL Server | Other
asked 2026-02-22T20:30:09.4333333+00:00
Sabyasachi Paul 0 Reputation points
edited a comment 2026-03-11T08:34:52.79+00:00
Akhil Gajavelly 1,570 Reputation points Microsoft External Staff Moderator
2 answers

Azure ID Required

Why is an Azure ID required for Installing MS SQL Express

SQL Server | Other
asked 2026-02-22T05:47:55.27+00:00
Marissa Muthulingum 0 Reputation points
commented 2026-03-11T08:27:10.2533333+00:00
Akhil Gajavelly 1,570 Reputation points Microsoft External Staff Moderator
1 answer

server 2025 upgrade cause large files to fail during port forward

when files are port forward after the sever 2025 upgrade they fail Moved from Microsoft 365 and Office | Other

SQL Server | Other
asked 2026-02-18T06:19:39.7766667+00:00
Marcel Van Der Merwe 0 Reputation points
commented 2026-03-11T05:14:11.52+00:00
Akhil Gajavelly 1,570 Reputation points Microsoft External Staff Moderator
1 answer

"'MSOLEDBSQL19' provider is not registered", but it is, and runs fine for weeks

We have a web application that runs with a connection string of Provider=MSOLEDBSQL19;uid=:U;pwd=:P;server=theserver;initial catalog=thedatabase;MultipleActiveResultSets=True;Use Encryption for Data=Optional;MARS Connection=True; The application will…

SQL Server | Other
asked 2026-02-17T13:44:33.5+00:00
David Weigel 0 Reputation points
commented 2026-03-11T04:42:31.38+00:00
Akhil Gajavelly 1,570 Reputation points Microsoft External Staff Moderator
1 answer

SQL Server 2025 express not abiding by command line installation parameters like previous versions

Problem report: Using the RTM installation of SQL Server 2025 Express with the following command line installation options results in unexpected behavior /QS /IACCEPTSQLSERVERLICENSETERMS /SUPPRESSPRIVACYSTATEMENTNOTICE /ACTION="install"…

SQL Server | Other
asked 2026-03-10T19:36:27.5166667+00:00
Dave Williamson 1 Reputation point
recommended 2026-03-10T21:39:13.32+00:00
Erland Sommarskog 133.2K Reputation points MVP Volunteer Moderator
1 answer

Migrate SQL Workloads to Azure SQL Database applied skills lab bug

Today I tried for the second time to take the Migrate SQL Workloads to Azure SQL Database applied skills lab (https://learn.microsoft.com/en-us/credentials/applied-skills/migrate-sql-workloads-azure-sql-database), but I couldn't do it again due to an…

Azure SQL Database
SQL Server | Other
asked 2024-01-30T02:16:05.7366667+00:00
Andre Rodrigues 0 Reputation points Microsoft Employee
answered 2026-03-10T16:18:17.1133333+00:00
Rob Atkinson 0 Reputation points
2 answers

MSSQL services Getting stopped in the AWS server. we have checked a logs getting - SQLException64 Error

MSSQL services stopped 2 times in a month, We checked the logs and got -SQLException64 error. This is windows server in AWS. Error message : Date 3/3/2026 6:04:39 PM Log Windows NT (Application) Source Windows Error…

SQL Server | Other
asked 2026-03-05T08:41:38.9266667+00:00
Kinjal Gurav 0 Reputation points
commented 2026-03-10T09:18:00.2233333+00:00
Lakshmi Narayana Garikapati 920 Reputation points Microsoft External Staff Moderator
2 answers

Support status of older Cumulative Updates

Are older Cumulative Updates to SQL Server supported at the same level as the latest CU? I understand that the latest CU may have a fix for an issue in an older CU, but what about the case of a bug or security incident in the older CU that has not been…

SQL Server | Other
asked 2026-03-04T17:22:52.8166667+00:00
Scott Zeller 0 Reputation points
commented 2026-03-10T09:13:27.1833333+00:00
Lakshmi Narayana Garikapati 920 Reputation points Microsoft External Staff Moderator
2 answers

OLEDB Error

When I try to import my excel (xlsx) It gives me an error stating: TITLE: SQL Server Import and Export Wizard The operation could not be completed. ADDITIONAL INFORMATION: The 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local…

SQL Server | Other
asked 2026-02-28T09:16:11.73+00:00
Riya Vyas 0 Reputation points
commented 2026-03-10T09:08:49.75+00:00
Lakshmi Narayana Garikapati 920 Reputation points Microsoft External Staff Moderator
1 answer

Issues with Windows SQL update that my hardware provider can't seem to figure out

Hello, I am a Mac user in my personal life (mostly) and when it comes to the set up of the computers for my veterinary clinic, it all mostly goes over my head. The host server was recently "repaired," and what that means is a memory refresh…

SQL Server | Other
asked 2026-02-26T21:28:44.3133333+00:00
IRVC Staff 0 Reputation points
commented 2026-03-10T09:06:59.78+00:00
Lakshmi Narayana Garikapati 920 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

Benefits and disadvantages of WITH (NOLOCK)

Benefits and disadvantages of WITH (NOLOCK). Also is there other commands that can serve different use cases.

Developer technologies | Transact-SQL
Developer technologies | Transact-SQL

A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.

4,715 questions
SQL Server | Other
asked 2024-05-30T15:12:46.18+00:00
Jonathan Brotto 420 Reputation points
answered 2026-03-09T07:11:23.8066667+00:00
Muhammad Ayoub 0 Reputation points
1 answer

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
commented 2026-03-09T06:02:06.4533333+00:00
Akhil Gajavelly 1,570 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
answered 2026-03-09T05:09:13.6166667+00:00
Akhil Gajavelly 1,570 Reputation points Microsoft External Staff Moderator
1 answer

cannot open or create sql agent alerts

When I try opening an existing alert in SSMS (SQL Agent - Alerts) or create a new alert, I receive the following error: The Show details button contains the following: =================================== Cannot show requested…

SQL Server | Other
asked 2026-02-24T22:02:13.37+00:00
Charles Burschtin 0 Reputation points
commented 2026-03-09T05:02:23.1966667+00:00
Akhil Gajavelly 1,570 Reputation points Microsoft External Staff Moderator