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 | Other
How to remediate hadoop-common-2.6.0.2.2.0.0-2041.jar vulnerabilities in SQL Server path/Program Files/Microsoft SQL Server/130/DTS/Extensions/Common/Jars/hadoop-common-2.6.0.2.2.0.0-2041.jar
How to remediate hadoop-common-2.6.0.2.2.0.0-2041.jar vulnerabilities in SQL Server path/Program Files/Microsoft SQL Server/130/DTS/Extensions/Common/Jars/hadoop-common-2.6.0.2.2.0.0-2041.jar
SQL Server Database Engine
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
ask about sql server
now my sql data is 100gb + use in microsoft navision use 5 year database setting is basic and auto glow unlimited can you tell me to make small database how to do thank you
SQL Server Analysis Services
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
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
importing excel using Import or export
my imput and export data doesn't have the excel imput
SQL Server Integration Services
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
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
KB5058713 fails install
KB5058713 fails install regardless of reboots, disabling SQL services, or Safe boot. O/S: Win10 Pro 22H2 x64 Tried: Run WUpdate Troubleshooter - fails to launch due to error 0x80070003 Reboot & Update - install fails Clean boot & Update -…
SQL Server Database Engine
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

Best practice with sp_syspolicy_events_reader and ##MS_PolicyEventProcessingLogin##
The SQL Server logs on our primary replica (Microsoft SQL Server 2022 with Always On) has been filling up with this repeated message: The activated proc '[dbo].[sp_syspolicy_events_reader]' running on queue 'SQLAG1_msdb.dbo.syspolicy_event_queue'…
SQL Server Database Engine

Getting error message as "Unable to find any Microsoft OLE DB providers on the machine."
I can't enable one of my product add-in due to below error message - Unable to find any Microsoft OLE DB providers on the machine. Please install "Microsoft Analysis Services OLE DB Provider for Microsoft SQL Server 2008" or later. …
SQL Server Analysis Services

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
How do fix Microsoft SQL server installation issue.
I’m facing an issue with SQL Server Agent and SQL Server services. Initially, both services were not starting. After multiple troubleshooting attempts, I managed to start them successfully. However, I am still unable to log in to the database using SSMS…
SQL Server Database Engine

Data Synchronization - Syncing Two Databases in SQL Server
I'm needing to take one database and have it on two separate sql servers (in two different physical locations) and have it stay in sync. Is there a way that I can do this? I've looked into SQL Server Replication ie:…
SQL Server Database Engine
How to fix ODBC test result failed
When we test our ODBC configuration it fails. This use to work fine, but suddenly it stopped. Here is the error message. "Microsoft ODBC Driver for SQL Server Version 17.10.0006 Running connectivity tests... Attempting connection [Microsoft][ODBC…
SQL Server Database Engine

SQL server express not installing
Hi, I have tried to install this multiple times however this error keeps showing up. I have uninstalled it and then tried to reinstall and it hasn't worked. Is there anything else I can try?
SQL Server Database Engine
What is the best approach to perform inplace upgrade first . is it OS or SQL ?
Current OS ( 2016)and SQL (2016) versions are going to obsolete and user wants to do inplace upgrade both OS and SQL to version 2022 . What is the best approach to perform inplace upgrade first . is it OS or SQL ? Could you please provide me the step by…
SQL Server Migration Assistant

High Memory Usage in SSISDB Related to MEMORYCLERK_SQLBUFFERPOOL
We are using SQL Server 2019. On this server, several content databases (used for reporting purposes) and an active SSISDB are running. The entire system is hosted on a single server where SQL Server 2019 is installed. Occasionally, memory usage on the…
SQL Server Integration Services
