18,089 questions with SQL Server-related tags

Sort by: Updated
0 answers

MySQL5.7 Installation

Hi Community, I installed MySQL whenever I'm opening MySQL workbench I'm getting error and I'm not able to resolve that error. Please set registry, key, when I'm going to check register .Net file I'm not seeing that, I'm attaching that Screen shot also. …

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
724 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,852 questions
SQL Server Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
4 questions
asked 2024-05-19T19:35:13.33+00:00
Zeyaul Hoda 0 Reputation points
1 answer

“wait on the database engine recovery handle failed . check the sql server error log for potential causes ” message appearing when the installation of SQL Server 2014 is almost complete

“wait on the database engine recovery handle failed . check the sql server error log for potential causes ” message appearing when the installation of SQ L Server 2014 is almost complete

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,852 questions
asked 2024-05-19T19:01:44.0666667+00:00
Ammar Al-Selwi 0 Reputation points
answered 2024-05-19T19:18:22.5933333+00:00
Erland Sommarskog 102.2K Reputation points MVP
3 answers One of the answers was accepted by the question author.

Download link for Microsoft.ACE.OLEDB.12.0

We need the Microsoft.ACE.OLEDB.12.0 32 bit install, can someone please provide a link. We need the functionality to import excel files in via SSMS so the 32 bit driver is required

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,852 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
asked 2024-04-19T14:09:09.57+00:00
Thomas Davies 20 Reputation points
answered 2024-05-19T19:14:18.5933333+00:00
James Longstreet 21 Reputation points
1 answer

AKS deployed application to access on-prem server

Hi, I want to connect to on-prem sql server from a .net application which is deployed in AKS. We already have Azure relay/hybrid connection setup for the same, but that requires azure app service. I am looking for options to connect from AKS deployed…

ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,226 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,852 questions
Azure Kubernetes Service (AKS)
Azure Kubernetes Service (AKS)
An Azure service that provides serverless Kubernetes, an integrated continuous integration and continuous delivery experience, and enterprise-grade security and governance.
1,883 questions
asked 2024-05-16T12:53:21.2833333+00:00
Santhi Dhanuskodi 145 Reputation points
commented 2024-05-19T17:28:56.1166667+00:00
kobulloc-MSFT 23,811 Reputation points Microsoft Employee
2 answers One of the answers was accepted by the question author.

SQL Server - Question marks inserted with Hebrew collation

SQL Server 2019, Developer edition, Windows 10. The client is SSMS 18. When database is created with Hebrew collation, for example, Hebrew_CI_AI, there is no problem, Hebrew strings are inserted and being read as they are. When database is created…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,852 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,559 questions
asked 2021-06-22T16:29:10.737+00:00
Natalie Sh 26 Reputation points
commented 2024-05-19T08:01:18.8333333+00:00
Erland Sommarskog 102.2K Reputation points MVP
0 answers

Microsoft programmability model that

libraries to access data on Microsoft 365 services.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,852 questions
JavaScript API
JavaScript API
An Office service that supports add-ins to interact with objects in Office client applications.
895 questions
asked 2024-05-15T13:55:10.93+00:00
Divy This 0 Reputation points
commented 2024-05-18T16:56:01.7766667+00:00
Vahid Ghafarpour 18,450 Reputation points
1 answer

Creating Dataset in VS2020 using SQL query rather than visual designer

I'm creating .rdlc reports using the extension in Visual Studio 2022, but when creating Datasets, I'm only able to do using the graphical designer and cannot create or edit Datasets by writing my own SQL. What am I missing?

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,674 questions
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.
2,818 questions
asked 2024-05-08T11:12:55.34+00:00
Thomas Benson 0 Reputation points
commented 2024-05-18T15:32:12.21+00:00
Thomas Benson 0 Reputation points
2 answers

How to troubleshoot “SQL Server is terminating because of fatal exception C0000005 . Error code 17311

We have a legacy version SQL Server MSSQL 2008 , where we are getting an error “SQL Server is terminating because of fatal exception C0000005 " SQL Service gets stopped frequently on every Sunday. Unable to find solution for the above error , can I…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,852 questions
asked 2024-05-16T12:45:55.47+00:00
Seelan, Sathiya 40 Reputation points
answered 2024-05-18T15:31:05.21+00:00
Erland Sommarskog 102.2K Reputation points MVP
2 answers

while installing sql server developer , shows up error decompressing media server ?

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,852 questions
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.
2,818 questions
asked 2024-05-16T18:33:09.84+00:00
sherif samy 0 Reputation points
commented 2024-05-18T15:16:37.6066667+00:00
Erland Sommarskog 102.2K Reputation points MVP
1 answer

SSIS - Flat File Destination Fixed Width Columns Appear to be Ragged

I am trying to create a flat file export, the spec is fixed width column, no headers or delimiters. There are 16 columns, the total width of all the columns combined is 624 characters. i have attempted two methodologies, both yield the same result where…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,852 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
asked 2024-05-16T22:31:35.1166667+00:00
Ken Wenze 0 Reputation points
commented 2024-05-18T15:12:13.03+00:00
Erland Sommarskog 102.2K Reputation points MVP
0 answers

How to resolve this error "External component has thrown an exception" in MS SQL server while loading excel file ?

How to resolve this error "External component has thrown an exception" in MS SQL server while loading excel file ?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,852 questions
asked 2024-05-17T04:56:21.8033333+00:00
Hemant S 0 Reputation points
commented 2024-05-18T15:06:49.2766667+00:00
Erland Sommarskog 102.2K Reputation points MVP
2 answers

unable to connect another data base in same server which is azure sql - through ssms

Issue description: Msg 40515, Level 15, State 1, Line 66 Reference to database and/or server name in 'sriniazpracticedbserver.database.windows.net.TARGET.dbo.data_trg' is not supported in this version of SQL Server. Completion time:…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,852 questions
asked 2024-05-17T05:49:15.5066667+00:00
Srinivas Mantri 0 Reputation points
answered 2024-05-18T14:46:59.58+00:00
Erland Sommarskog 102.2K Reputation points MVP
0 answers

Reclaiming free space from TempDB in azure sql managed instance

the TempDB on my azure sql managed has grown to 350 GB but 99% of that space shows as unused. i tried to shrink the database and individual files but the server is not freeing up the space. the space is still reserved for tempdb. Microsoft docs is…

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,852 questions
asked 2024-05-17T12:34:07.53+00:00
HusainIbrahem-6130 0 Reputation points
commented 2024-05-18T14:34:06.3733333+00:00
Erland Sommarskog 102.2K Reputation points MVP
4 answers

Security update for SQL Server 2019 CU25

Hi, I would like to clear up some confusion regarding security updates for SQL Server 2019. If Security update for SQL Server 2019 CU 25 KB5036335 is pushed out by our System Engineers team to a server, does that mean it includes the Cumulative Update…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,852 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,240 questions
asked 2024-05-14T17:31:21.2833333+00:00
David D. Lengar 0 Reputation points
commented 2024-05-18T14:09:39.63+00:00
Erland Sommarskog 102.2K Reputation points MVP
2 answers One of the answers was accepted by the question author.

Execution Plan Parallel Deadlock Issue Persisting in SQL Server 2022

Hi Msft team! I hope this message finds you well. I am writing to report a persistent issue with execution plan parallel deadlocks that still exists in SQL Server 2022. Despite updates and patches, this bug appears to remain unresolved, and I have been…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,852 questions
asked 2024-05-10T15:07:55.6733333+00:00
Steven Lam 20 Reputation points
commented 2024-05-18T13:03:02.69+00:00
Steven Lam 20 Reputation points
3 answers

How do I fix MSSQL Server 2022 Database Engine Services failing to install?

I have been struggling with this for far too long now. I've reinstalled it twice now with 9 repair tries. Still no luck. I need some help because my classes require it to be installed. Overall summary: Final result: Failed: see details…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,852 questions
asked 2023-03-28T13:45:32.1966667+00:00
JC Sanders 5 Reputation points
edited an answer 2024-05-18T09:01:56.57+00:00
Alok Jha 0 Reputation points
4 answers One of the answers was accepted by the question author.

Not able install sql server 2022 in window 11.

Error installing SQL Server Database Engine Services Instance Features The system cannot find the path specified Error code:…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,852 questions
asked 2024-03-03T17:37:10.53+00:00
dinabondhu pramanik 25 Reputation points
answered 2024-05-18T08:57:03.8733333+00:00
Alok Jha 0 Reputation points
5 answers

Error Fix (Database engine service failed in sql server 2022 and 2019)

Hello i am having troubles installing sql server 2022. my error is sql database engine fails to starts steps taken to install the sql on my laptop, was that i changed the account name of database engine service ( i did this because i have tried…

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,852 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
asked 2022-11-23T00:01:59.227+00:00
Nelson Nwachia 36 Reputation points
answered 2024-05-18T08:36:47.0033333+00:00
Alok Jha 0 Reputation points
3 answers

Transactional Replication on a SQL Managed instance as a subscriber with pull subscription

We are doing a transactional Replication to a SQL Managed instance (subscriber) with pull subscription from On-Prem(Publisher/Distributor) We are seeing uninitialized subscription on the replication monitor. How can we troubleshoot this

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,852 questions
asked 2024-05-16T12:03:46.98+00:00
Nitya V 40 Reputation points
commented 2024-05-17T19:15:05.82+00:00
Zahid Butt 556 Reputation points
1 answer

SQL Server Maintenance Plan: Cleanup Task

Hello! Some time ago I noticed that my two maintenance plans were working incorrectly: the cleanup tasks that must have been deleting files older then 2 weeks had not been really deleting anything and my oldest files were ~29.02.2024. The reason was that…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,852 questions
asked 2024-05-17T09:41:25.65+00:00
Hram Admin 0 Reputation points
answered 2024-05-17T18:01:54.44+00:00
Olaf Helper 41,006 Reputation points