14,525 questions with SQL Server | Other tags

Sort by: Updated
6 answers

SQL Server Excel Import - The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

I'm trying to do a simple Excel import into a local SQL Server instance installed on my machine (to do some analysis), I'm attempting to use the wizard through SSMS. This worked a few days ago and I imported a couple of thousand tabs into tables in SQL…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,716 questions
SQL Server | Other
asked 2021-11-19T14:32:00.537+00:00
Alex Fletcher 66 Reputation points
commented 2025-08-12T06:59:36.88+00:00
Mary Hernandez 0 Reputation points
1 answer

Unable to Create Connection in Power Automate Using On-Prem Gateway - Invalid SQL Credentials Error

Hi Microsoft Support Team, I am encountering an issue of SQL connection in Power Automate. I created a connection to on-prem SQL server using on-prem gateway. Upon creation, it has no issue, it is saved successfully. However, when I ran the workflow, the…

SQL Server | Other
asked 2025-08-11T02:24:42.01+00:00
Alma Chang 0 Reputation points
answered 2025-08-12T03:45:07+00:00
Dakota Williams 0 Reputation points
0 answers

My 2022 SQL Server will not install

I have tried nearly everything that I can think of to make it work, but it refuses to install. The attached files are from an attempt at using the Developer option to download. Screenshot 2025-08-07 210604.png Screenshot 2025-08-07 212904.png

SQL Server | Other
asked 2025-08-08T01:33:08.49+00:00
Elijah Adepeju 0 Reputation points
commented 2025-08-11T22:47:53.8733333+00:00
Elijah Adepeju 0 Reputation points
1 answer

SQL Cluster Failures After KB5062572 Update on Windows Server 2022

Previous version: KB5060526 (OS Build 20348.3807). After applying KB5062572 (OS Build 20348.3932) to our Windows Server 2022 environment, we experienced SQL cluster failures, including node failover issues, disk/storage errors, and database…

SQL Server | Other
asked 2025-08-06T14:53:43.6566667+00:00
Salvino Sepulveda Jr 0 Reputation points
answered 2025-08-11T18:18:31.4033333+00:00
Valdeir Brito 1 Reputation point
0 answers

How do I know what SQL version I have?

I am completing a Cyber questionnair for procurment with a client who is looking to use our SaaS product. A question is "What SQL" version do we use. How do i find out?

SQL Server | Other
asked 2025-08-10T22:47:22.82+00:00
Angie Montgomery 0 Reputation points
commented 2025-08-11T16:52:51.2433333+00:00
Yitzhak Khabinsky 26,676 Reputation points
1 answer

How can I connect to my SQL server from my VM using a .NET application.

I have a .NET application on my azure virtual machine that will not connect to my azure SQL database. I can otherwise connect to the db on my vm using SSMS. My .NET application will connect from my local laptop. I am using ENTRA ID authentication.

Developer technologies | ASP.NET | ASP.NET Core
Developer technologies | .NET | Other
SQL Server | Other
asked 2025-02-07T23:50:29.9033333+00:00
Nicholas Pallotta 0 Reputation points
commented 2025-08-11T11:03:18.3833333+00:00
Raymond Huynh (WICLOUD CORPORATION) 620 Reputation points Microsoft External Staff
0 answers

How is this function suppose to work - clarification needed

Hi, ALL, In https://learn.microsoft.com/en-us/sql/odbc/reference/syntax/sqlstatistics-function?view=sql-server-ver17#comments at the end of this section. there is a following sentence. [quote] If the row in the result set corresponds to a table, the…

SQL Server | Other
asked 2025-08-08T14:02:02.7533333+00:00
Igor Korot 56 Reputation points
commented 2025-08-09T08:33:18.16+00:00
Erland Sommarskog 124.2K Reputation points MVP Volunteer Moderator
2 answers

Microsoft.EntityFrameworkCore.DbUpdateConcurrencyException: The database operation was expected to affect 1 row(s), but actually affected 0 row(s); data may have been modified or deleted since entities were loaded.

I am using DDD architecture and the following code changes the aggregate Root (basically adds a comment which is an Entity to the aggregate Root). public sealed class AddCommentToPostCommandHandlers : ICommandHandler<AddCommentToPostCommand,…

Developer technologies | .NET | Entity Framework Core
SQL Server | Other
asked 2024-11-24T08:29:09.3733333+00:00
Arman Espiar 1 Reputation point
commented 2025-08-07T12:31:41.1733333+00:00
Đào Quân 0 Reputation points
1 answer

Received a COA but not product key or software.

A SQL Server 2019 IOT Standard edition was purchased but all that was received is a COA card. The COA has no product key information on it and no software came with the purchase. I need a product key.

SQL Server | Other
asked 2025-08-05T21:25:34.7766667+00:00
Jones, Donald 0 Reputation points
answered 2025-08-05T21:48:06.7+00:00
Bruce (SqlWork.com) 79,101 Reputation points Volunteer Moderator
1 answer

SSRS CSV export issue

I have a SSRS report with dynamic column and also Column display order is getting handle through parameter "ColumnOrder". Once I generate the report it works fine and based on column order it display columns on report. Once I export it to CSV…

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,072 questions
SQL Server | Other
asked 2023-08-25T13:16:20.0366667+00:00
Arvind Singh Gusain 5 Reputation points
commented 2025-08-05T13:29:53.6333333+00:00
San Panico 0 Reputation points
1 answer One of the answers was accepted by the question author.

Microsoft OLE DB Driver error

getting this error please help me how i can fix it error: Feature failure reason: An error occurred for a dependency of the feature causing the setup process for the feature to fail. Error details: § Error installing Microsoft OLE DB Driver for SQL…

SQL Server | Other
asked 2025-08-04T20:11:47.9233333+00:00
DEVENDRA MAURYA 20 Reputation points
commented 2025-08-05T08:15:03.8733333+00:00
DEVENDRA MAURYA 20 Reputation points
7 answers

How to download Sql Server Configuration Manager

Hello, BRAND NEW to SQL Server. I was following along with a tutorial and downloaded the SSMS, however, doesn't seem like i have the configuration manager installed properly. I tried entering the credentials first prompted once SSMS was done…

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,072 questions
SQL Server | Other
asked 2022-09-25T07:02:10.793+00:00
Zach Hadjah 26 Reputation points
commented 2025-08-04T19:27:19.6766667+00:00
Valtimwoke 0 Reputation points
0 answers

how to fix decimal code in sql

how to fix decimal error in sql 2022 its error code is 606

SQL Server | Other
asked 2025-08-02T18:32:26.75+00:00
Akula Rahul 0 Reputation points
commented 2025-08-03T16:48:00.5+00:00
Erland Sommarskog 124.2K Reputation points MVP Volunteer Moderator
9 answers

SQL Server 2022 Developer Edition - Installation of the SSIS Integration Services

Hello to all, I have been trying to do the one Integration Services installation on my SQL Server 2022 Developer Edition environment. Unfortunately I always get errors during the installation, these are mainly related to the installation of Microsoft OLE…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,716 questions
SQL Server | Other
asked 2023-02-20T09:37:55.24+00:00
Alessandro Di Pasquale 15 Reputation points
answered 2025-08-02T17:20:38.5033333+00:00
Omnia Prime 0 Reputation points
2 answers

Exit code (Decimal): -2068052377Error description: Invalid command line argument. Consult Windows Installer SDK. Please help me...

After multiple efforts with Installing SQL Express I was at first stuck during installation at point CPU_64 Issue which after multiple online searches and deep cleaning I was able to remove all issues and all partial installed SQL components from…

Windows for business | Windows Client for IT Pros | User experience | Other
SQL Server | Other
asked 2023-03-23T08:16:16.06+00:00
DIMELA NEFELI 15 Reputation points
commented 2025-08-02T08:32:45.4833333+00:00
Arunima Tiwari 0 Reputation points
6 answers

which is best for performance filtering on where or filtering on join ?

I work on sql server 2019 i don't know which is best for performance filtering on where condition or filtering on join with another meaning which is best first query select A.* from A inner join B on A.ID=B.ID INNER JOIN C ON C.ID=B.ID …

Developer technologies | Transact-SQL
SQL Server | Other
asked 2022-07-28T07:09:10.783+00:00
ahmed salah 3,216 Reputation points
commented 2025-08-01T15:42:38.47+00:00
Erland Sommarskog 124.2K Reputation points MVP Volunteer Moderator
1 answer

upgrade license microsfot sequel standard from express data base

I need to upgrade my license for microsoft sequel standard 2022. we had microsoft database express.

SQL Server | Other
asked 2025-07-31T16:39:28.4333333+00:00
Chris Bailey 0 Reputation points
answered 2025-07-31T21:48:29.4566667+00:00
Erland Sommarskog 124.2K Reputation points MVP Volunteer Moderator
1 answer

How do i retrieve lost data from the month before?

I am in Sharepoint and I created a new month by copying July but lost all my data on July while adding August. How can I retrieve this data?

SQL Server | Other
asked 2025-07-31T10:52:14.3633333+00:00
Stargle, Sherry 0 Reputation points
commented 2025-07-31T12:24:08.52+00:00
Jose Benjamin Solis Nolasco 4,986 Reputation points
5 answers

backup running forever.

hello Folks, There was an incident happened on weekend. One of our DB backup took 24+ hours to run. usually it runs within 3-4 hours. sp_whoisactive showed me this session was waiting for ASYNC_IO. I checked Avg disk sec/write and read. Both were…

SQL Server | Other
asked 2022-08-29T18:21:57.05+00:00
Heisenberg 266 Reputation points
commented 2025-07-31T09:29:12.2866667+00:00
Erland Sommarskog 124.2K Reputation points MVP Volunteer Moderator
1 answer

how much does it cost to upgrade to windows server 2025

how much will it cost me to upgrade to windows 2025 from 2016? And will i have to upgrade my SQL as well?

SQL Server | Other
asked 2025-07-30T15:51:45.9166667+00:00
Mark Fikes 0 Reputation points
answered 2025-07-30T20:48:55.1+00:00
Erland Sommarskog 124.2K Reputation points MVP Volunteer Moderator