17,985 questions with SQL Server-related tags

Sort by: Updated
4 answers

how to solve the error "Microsoft.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - La chaîne de certificats a été"

Hi I try to connect my asp.net core api to a sql server database I encounter an error like: "Microsoft.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the login…

ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,189 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,759 questions
asked 2023-05-23T09:49:55.54+00:00
Marnelle M'BENGUET 20 Reputation points
answered 2024-05-05T19:54:35.22+00:00
Martinho Sebastião 0 Reputation points
2 answers

Are there enhancements in SQL SERVER 2019 transactional replication working as compared to SQL SERVER 2008 R2 transactional replication. Also, of all HA/DR solutions available in SQL SERVER 2019 which allows minimum data loss in case of disaster.

Are there enhancements in SQL SERVER 2019 transactional replication working as compared to SQL SERVER 2008 R2 transactional replication. Also, of all HA/DR solutions available in SQL SERVER 2019; which allows for minimum data loss in case of disaster.…

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,759 questions
asked 2024-04-28T17:44:17.5466667+00:00
DM 501 Reputation points
commented 2024-05-05T18:59:23.1066667+00:00
DM 501 Reputation points
2 answers

Data output error using specific scenario in SQL Join

Going though something very strange while running the SQL Query. External Table: dl.tableA has a varchar value "EmployeeSequenceNumber" in column EmployeeSequenceNumber , while doing the inner join with dim.tableB, the query is getting…

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,759 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,555 questions
asked 2024-05-05T14:26:32.57+00:00
NIKHIL KUMAR 81 Reputation points
answered 2024-05-05T17:54:17.8666667+00:00
Erland Sommarskog 101.4K Reputation points MVP
2 answers

Named Pipes Provider: Could not open a connection to SQL Server

Hi, Named Pipes Provider: Could not open a connection to SQL Server error (53) from public facing Server to Local SQL Server but Local to DMC Server possible Please any one can you advice to me Kind Regards R.Raja

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,759 questions
asked 2024-05-02T05:30:16.5+00:00
Raja Raju 0 Reputation points
commented 2024-05-05T16:14:33.6166667+00:00
Erland Sommarskog 101.4K Reputation points MVP
1 answer

How to Fix:Error: Microsoft ODBC Driver 18 for SQL Server : SSL Provider: [error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed:self signed certificate].

I followed the documentation: https://learn.microsoft.com/en-us/sql/linux/quickstart-sql-server-containers-azure?view=sql-server-ver16&tabs=kubectl to deploy SQL server on AKS. But While connecting to it, getting the below error: Sqlcmd: Error:…

Azure SQL Database
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
975 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,759 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,867 questions
asked 2023-06-27T20:19:16.9633333+00:00
Satyam 20 Reputation points
commented 2024-05-05T12:03:10.72+00:00
Jaap Titulaer 0 Reputation points
1 answer

Unable to connect to my SQL Server/Database. Listed resources on Microsoft do not address this issue.

Error codeSqlFailedToConnect DetailsCannot connect to SQL Database. Please contact SQL server team for further support. Server: 'blazor-wasm-app.database.windows.net', Database: 'BrandedFoodMacrosContent', User: [...BLANK...] Check the linked service…

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,759 questions
asked 2024-05-04T23:34:12.1833333+00:00
Albert Kirpach 0 Reputation points
commented 2024-05-05T11:13:35.14+00:00
Erland Sommarskog 101.4K Reputation points MVP
9 answers

SQL Server install error Wait on the Database Engine Recovery Handle Failed

SQL Server 2019 install error Wait on the Database Engine Recovery Handle Failed this error is coming and i have tried everything on the internet to solve this but it still isnt installing can anyone tell me how to remove this error

Azure SQL Database
Azure SQL Edge
Azure SQL Edge
An Azure service that provides a small-footprint, edge-optimized data engine with built-in artificial intelligence. Previously known as Azure SQL Database Edge.
45 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,759 questions
asked 2021-07-28T10:27:04.27+00:00
Priyanshu Singh 31 Reputation points
edited an answer 2024-05-05T10:31:12.0666667+00:00
Fasil Hayat 0 Reputation points
1 answer

How to fix this error in Microsoft SQL: SQL job is failing. OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: Query timeout expired...

Hello, Kindly advise how to solve below issue: we have one job that's failing is Microsoft SQL. This issue is affecting the Power BI reports as well. Below error is found: SQL job is failing. OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: Query…

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
10,649 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,759 questions
asked 2024-05-04T22:07:43.62+00:00
Aya 0 Reputation points
answered 2024-05-05T10:26:04.86+00:00
Erland Sommarskog 101.4K Reputation points MVP
1 answer

How to handle text file with delimiter as ~|~ in SSIS Package

I received text file from external vendor with appears to be Pipe Delimited but it has very unusual character before and after Pipe (|). I am using SSIS Package (VS 2019) to import the data into SQL Server database 2019. I am using SQL Agent Job to…

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,759 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,456 questions
asked 2024-05-04T00:46:30.9766667+00:00
Villa 166 Reputation points
edited an answer 2024-05-05T02:28:48.29+00:00
Yitzhak Khabinsky 25,026 Reputation points
2 answers

MSSQL\Log\Polybase\dump folder keeps growing

A while ago I noticed that my C drive was almost full. So I moved a bunch of files (90 GB) to another drive. 3 weeks later my C drive was full again, while there were almost no files left taking up space on my SSD. After selecting all folders on my C…

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,759 questions
asked 2021-06-14T07:03:33.38+00:00
pieterjandeclippel@msn.com 1 Reputation point
commented 2024-05-04T20:00:38.7466667+00:00
Erland Sommarskog 101.4K Reputation points MVP
5 answers

Windows 11 SQL Server install error Wait on the Database Engine Recovery Handle Failed

In Windows 11 Machine, unable to install SQL server 2019. I tried multiple versions. but got the following error message. I tried multiple times and restart the machine. nothing worked out. Please somebody help with this. Edition Windows 11…

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,759 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,555 questions
asked 2022-12-27T14:14:32.197+00:00
S Dineshkumar 1 Reputation point
answered 2024-05-04T17:42:37.73+00:00
Alok Jha 0 Reputation points
2 answers

Power BI Reporting Server on Standard DB Engine

Is it possible for the .pbix files to work correctly when the Power BI reporting server (PBIRS) is installed on a Standard DB Engine? According to the below link, it looks contradictory as while it states that Standard edition is possible, it also…

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,807 questions
asked 2024-05-01T18:27:45.1366667+00:00
Jessy 0 Reputation points
answered 2024-05-04T16:15:53.1933333+00:00
Jessy 0 Reputation points
0 answers

unable to connect to our reports from ssrs

We are unable to connect to our Microsoft 2019 reporting server reports after installing certificate. I have try connect with with these option: http://ip/reports http://servername/reports I was also altered rsrepotsser.config file to get things…

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,807 questions
asked 2024-05-04T14:37:38.8466667+00:00
Gregg Pfeifer 0 Reputation points
1 answer

SQL connection to server error

After i installed Microsoft SQL server i face this problem while trying to connect ADDITIONAL INFORMATION: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not…

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,759 questions
asked 2024-05-03T11:36:23.5666667+00:00
Mohamed El Sayed Mohamed 20 Reputation points
commented 2024-05-04T07:33:38.97+00:00
Erland Sommarskog 101.4K Reputation points MVP
4 answers

How to resolve install failures for SQL Server 2022 Developer edition

I have been trying to install SQL Server 2022 Developer edition without success. After more than 10 attempts I am at a complete loss as to what to do next. I have attached the log of my last attempt and hopefully someone can shed some light on my issues…

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,759 questions
asked 2024-02-18T10:26:52.4233333+00:00
Robert Higgins 5 Reputation points
answered 2024-05-04T05:53:33.0833333+00:00
Alok Jha 0 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,759 questions
asked 2023-03-28T13:45:32.1966667+00:00
JC Sanders 5 Reputation points
answered 2024-05-04T05:46:58.98+00:00
Alok Jha 0 Reputation points
0 answers

Error creating SQL user accounts from external provider with Azure Arc

When trying to create user accounts that use Azure login in Azure Arc, we receive the error shown in the user's image. How can we resolve this issue?

Azure Arc
Azure Arc
A Microsoft cloud service that enables deployment of Azure services across hybrid and multicloud environments.
326 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,759 questions
asked 2024-05-03T12:16:54.9066667+00:00
AJ Copeland 0 Reputation points
commented 2024-05-03T21:36:15.92+00:00
Erland Sommarskog 101.4K Reputation points MVP
0 answers

How do I transfer an on-premises license from one corporate user to another?

I need to transfer an on-premise license, but I'm having trouble finding materials explaining the step-by-step process, as well as which instrument should be used for the transfer. Can You help me?

Windows
Windows
A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.
4,770 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,759 questions
asked 2024-05-03T12:29:56.53+00:00
Takeo Contao Abe TERNIUM BR 0 Reputation points
commented 2024-05-03T21:35:32.0933333+00:00
Erland Sommarskog 101.4K Reputation points MVP
0 answers

Is there any way to connect Hadoop to SSMS other than ODBC Driver.

We have jobs in SSMS. We are experiencing ODBC Error constantly when the job fails. but we could see other job which are running with same ODBC Driver its succeeding. To avoid this issue, we want to know is there any other way that we can connect Hadoop…

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,759 questions
asked 2024-05-03T13:12:37.4933333+00:00
commented 2024-05-03T21:33:54.8833333+00:00
Erland Sommarskog 101.4K Reputation points MVP
3 answers

how troubleshoot SqlDumpExceptionHandler: Process 113 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process

We use Cumulative Update 21 for SQL Server 2019, Always on with 1 Primary plus 2 secondary replicas. Recently we noticed our SQL Server had some dumps, like below. Can anyone pls help advise how troubleshoot it? Thanks SqlDumpExceptionHandler: Process…

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,759 questions
asked 2024-05-02T02:52:39.4733333+00:00
Ted Yin 0 Reputation points
commented 2024-05-03T21:23:43.5233333+00:00
Erland Sommarskog 101.4K Reputation points MVP