Connect to Linked Server Database using Azure Data Factory
Hi! I have a database that is a linked server of another. I can connect and copy data of the main database in ADF. But is it possible to also copy data from the linked server database? If yes, how would I do this?
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…
Enterprise Report Server not showing Data Driven Subscriptions
We have updgraded from Standard to Enterprise reporting services. We were expecting to have the option to create data-driven subscriptions but the option is not available. All the articles found during our web search say 'Data-driven subscriptions' will…
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
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 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…
Scripting out 'Create Merge Replication' does not include 'processing_order'
We use Merge Replication and have defined a specific 'processing_order' for the Articles in the Publication. The Articles include tables, functions and stored procedures. When we want to setup or refresh a test environment, we will script out the…
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
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 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…
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:…
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…
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
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…
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…