Do ODBC Linked Servers (MariaDB) support XA Transactions?
My setup involves 3 servers, 2 MariaDB servers -- one under my control, the other not -- and an MSSQL server. I have the two MariaDB servers linked via the Spider Engine and I have my internal MariaDB server set up as a linked server in Sql Server with…
SQL SSIS on Separate Server
Hi, I'd like to confirm if we need a another SQL license for the server where SSIS will be installed aside from the primary SQL Server? Thank you, Jovsp
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…
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…
SSIS task through SQL Agent showing OLEDB 16.0 not registered after install
Hi all, we're currently having issues trying to have a job run on a schedule via SQL Agent using the OLEDB 16.0 64-bit connector using an excel file. The job runs fine locally in Visual Studio, where I have the 64-bit OLEDB 16.0 installed. However when…
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…
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…
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.…
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:…
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
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…
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…
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…
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…
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?
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?
Unable to add a index hint to a simple query
I have a table with milions of records CREATE TABLE documents ( id bigint primary key, external_system nvarchar(50), external_docid nvarchar(50)) and non clustered filtered unique index CREATE UNIQUE INDEX documents_ix19 ON…
How to fix, Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication.
We have setup the domain controller. Two machines (Windows Server 2019 Standard, 10.0.17763) are added to the same domain(Mac1 and Mac2). From Mac1, we are trying to connect remotely to SQL Server 2019 installed on Mac2. We are using Mix mode…
How to verify if a backup "*.bak" is encrypted?
Is there a way to verify if the sql server backup file is encrypted or not? I have a script to turn off encryption before backup; however, I like to verify the backup file *.bak is in fact NOT encrypted before I send out to vendor.
Problem with FINDSTRING in SSIS Expression
Best regards. I have a problem when I am trying to use the FINDSTRING function in SSIS of Visual Studio 2022. It gives me the following error, even when I try to use the reference examples from the Microsoft page…