Upgrading from SQL Server 2016 Express SP1 to SP3
Which option in SQL Server 2016 Express setup should be chosen to upgrade from SP1 to SP3? This is an in-place upgrade from SQL Server 2016 Express (SP1-GDR).
Error when setting destination in Copy Data activity (MS Fabric)
Hi all, In my Fabric workspace, I have a pipeline with a "Copy Data" activity. The source is a lakehouse. I am trying to set the destination to be SQL Server. I have put in the server name, username and password. I also checked the checkbox…
Connecting to Azure Sql Managed Instance
Hello, I am having connectivity issue after migrating on-prem Databases to Azure Sql Managed Instance. I tried two way and getting slightly different error message: Somehow I am confused as I am able to using SSMS and Azure data Studio via my local, I am…
"RESTORE detected an error on page (0:0) in database" error while restoring a database
I have a large database (750GB) that I am backuped on one server and attempted to restore on a different server, I receive the following error - "System.Data.SqlClient.SqlError: RESTORE detected an error on page (0:0) in database…
How to fix timeout error in connection using pyodbc in airflow
Hi, I am running an airflow DAG in docker, where I connect to sql server 2019 using a pyodbc connection function. My connection function is as: def get_db_connection(): return pyodbc.connect( 'DRIVER={ODBC Driver 17 for SQL Server};' …
How to load data from multiple txt files after removing first row into tables?
Hi All, I faced one scenario where i have 6 txt files of different regions. In every text document First Line is not required. How can I remove First line alone and load the data from all six source docs into SQL tables? Data From North…
In T-SQL debugging, "Step Into" behaves like "Step Over."
visual studio 2022 (17.11.5) Microsoft SQL Server 2022 (RTM) - 16.0.1000.6 (X64) Oct 8 2022 05:58:25 Copyright (C) 2022 Microsoft Corporation Developer Edition (64-bit) on Windows 10 Enterprise 10.0 <X64> (Build 22631: ) (Hypervisor)…
Migration_Azure
I have migrated the data from SQL server to Azure SQL Database. The size on the SQL dataset was around 250 mb but on migration when i checked the size it is around 500 mb. I would like to know the reason and how can i cross check that
We are setting up Entra Authentication for SQL Server. We want to protect against regional outages. How do we configure private DNS so that if a region goes down, SQL Authentication via Entra ID will not be impacted?
We are setting up Entra Authentication for SQL Server on premises via Azure Arc. We want to protect against regional outages. How do we configure private DNS so that if a region goes down, SQL Authentication via Entra ID will not be impacted?
ADO.NET connection failure to Azure Database from VS 2022 SSIS Package running against SQL Server 2022 using Microsoft SQLClient Data Provider
I have a SSIS package running on SQL Server 2022 in VS2022 that connects to a 3rd party Azure database as a source with ADO.NET using Microsoft Entra Password that has been running successfully for a few years. However, recently I needed to make…
Migrating existing packages - C# task is failing on a new server
Hi, We're migrating our SSIS server to a new server. Original server is Windows Server 16, SQL Server 2019. New server is Windows Server 2022 and OS is SQL Server 2022. We're getting the error on the packages that use C# script task: Code: 0x00000005 …
Error occurred during local report processing
Hi Experts, i am getting error while generating the report: I have used parameters like : and getting error as below screenshot The 'Value' expression for the query parameter '?' contains an error: Overload resolution failed because…
How to create DB for Reservation
I have a reservation - SQL Database Single/Elastic Pool General Purpose - Compute Gen5 Could you please share with me instructions on how to create DB suitable for my reservation As I understand if I create DB correctly it will link to the…
SQL Server 2019 installation failed with 2068052310 Exit code
SQL Server 2019 installation failed with below error. I have tried manually installing the msodbcsql.msi and re-tried the SQL server installation, but that also failed. The SQL2019-SSEI-Expr.exe was downloaded from microsoft.com
Possibity of upgrade and migration from SQL 2014 to SQL 2022
HI Team, I am having one system ( Procesor: Intel Xeon E-2224 3.4GHz, 8M c ache, 4C/4T, turbo (71W)) with installed 2014 SQL I would like to upgrade to 2022 Standard SQL is it possible and what is most easy way. Kind regards,
Possibity of upgrade and migration from SQL 2014 to SQL 2022
HI Team, I am having one system ( Procesor: Intel Xeon E-2224 3.4GHz, 8M c ache, 4C/4T, turbo (71W)) with installed 2014 SQL I would like to upgrade to 2022 Standard SQL is it possible and what is most easy way. Kind regards,
[Completed with warning]:The site database has a backlog of SQL change tracking data. For more information
We got this issue when we run prerequisites check in Configuration Manager (SCCM). [Completed with warning]:The site database has a backlog of SQL change tracking data. For more information see https://go.microsoft.com/fwlink/?linkid=2027576
[Microsoft][ODBC Driver 18 for SQL Server]SSL Provider. The certificate chain was issued by an authority that is not trusted. [Microsoft][ODBC Driver 18 for SQL Server]Client unable to establish connection.
Hello, researched and around still having issues on connecting into SQL Server. Error getting is: [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider. The certificate chain was issued by an authority that is not trusted. [Microsoft][ODBC Driver 18 for…
Critical Error for SharePoint_Config Database
Hi, I searched all forums for three days but can't find the answer. These topics won't work : Answer 1 Answer 2 Answer 3 The server returns this critical error: SQL database login for 'SharePoint_Config' on instance 'ServerSql' failed.…
SQL Recursive query to generate output
Hello Expert , I am trying to generate one output as: Two different Tables: Table1: Cat1, Vol,Rank Cat1, 1, 1 Cat1, 4, 2 Cat1, 6, 3 Table2: Rank, Vol_Threshold, Partition 1, 21, 1 2, 27, 2 3, 34, 3 Would like to generate output: if running first…