SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,223 questions
6 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…
asked 2022-11-23T00:01:59.227+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 54%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
Nelson Nwachia
56
Reputation points
commented 2024-12-27T03:30:44.9066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 38%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
Kunal Singh
0
Reputation points
0 answers
MSSQL 2022 - SSISDB ETL returning "...failed with the following error: "An error occurred in the Microsoft .NET Framework while trying to load assembly id 65536. "
Full error from the Integration Catalog in question: SQL Load Queue List into Object:Error: Executing the query "EXEC [My PROC name]" failed with the following error: "An error occurred in the Microsoft .NET Framework while trying to…
asked 2024-12-26T16:44:24.62+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 57.99999999999999%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFB%3C/text%3E%3C/svg%3E)
Fred Bartley
0
Reputation points
commented 2024-12-27T03:17:45.1633333+00:00
ZoeHui-MSFT
38,956
Reputation points
0 answers
SQL Server Enterprise 2019 not core 21 up to
Currently, I am using Windows Server 2016 and SQL Server Enterprise 2019, but the SQL system only utilizes 20 cores, even though I have allocated 60 cores to the server. I have tried the following commands: EXEC sp_configure 'affinity mask', 0; EXEC…
asked 2024-12-26T04:30:18.3066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 61%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
Nguyen ngoc giang
0
Reputation points
commented 2024-12-26T09:29:49.33+00:00
Erland Sommarskog
114.6K
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
Unable to Send Emails from SQL Server
There is an issue with sending emails from SQL Server, accompanied by the following error message: The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2024-12-03T11:05:46). Exception Message:…
asked 2024-12-23T08:38:01.5766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 8%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Avinash
20
Reputation points
commented 2024-12-23T11:44:18.4133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 60%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
Naveen Kumar M
75
Reputation points
2 answers
One of the answers was accepted by the question author.
How to share my SHIR (Self Host Integration Runtime) service with different azure services
I have created a SHIR service for my Azure Synapse Analytics service where I used to perform data operation from Azure Synapse to my On prem SQL Server using my SHIR service. However I wanted to use the data of my on prem SQL with Azure data factory…
asked 2024-12-17T07:34:57.5166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 81%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Sayeed Ahmed
20
Reputation points
accepted 2024-12-19T13:24:09.3+00:00
Sayeed Ahmed
20
Reputation points
2 answers
One of the answers was accepted by the question author.
SQL Server 2022 installation error- Cannot find the path specified
I am trying to install MS SQL SERVER 2022 in my Windows 11 hp laptop. Getting this error Unable to install SQL Server (setup.exe). Exit code (Decimal): -2147467259Error description: The system cannot find the path specified i tried express installation…
asked 2024-12-02T08:28:57.62+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 84%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Ashutosh Kumar Yadav
20
Reputation points
commented 2024-12-18T22:11:30.5533333+00:00
Erland Sommarskog
114.6K
Reputation points MVP
6 answers
SQL Server Excel Import - The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
I'm trying to do a simple Excel import into a local SQL Server instance installed on my machine (to do some analysis), I'm attempting to use the wizard through SSMS. This worked a few days ago and I imported a couple of thousand tabs into tables in SQL…
asked 2021-11-19T14:32:00.537+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 41%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAF%3C/text%3E%3C/svg%3E)
Alex Fletcher
61
Reputation points
commented 2024-12-18T20:37:05.5866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(316.8, 43%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECL%3C/text%3E%3C/svg%3E)
Cassandra Lopez
0
Reputation points
1 answer
Trying to connect to the Fabric Lakehouse from the SSIS Package. However it is failing when executing the package
I have Fabric Lakehouse as a Source , I am able to connect to the Fabric Lakehouse via Authentication as "ActiveDirectoryPassword" from SSMS without any issue. I am creating the SSIS package and created the ADO.NET connection Manager and…
asked 2024-12-12T22:39:50.1766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 30%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVT%3C/text%3E%3C/svg%3E)
Vineeta Trivedi
0
Reputation points
commented 2024-12-16T01:42:10.08+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 65%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
Chandra Boorla
5,835
Reputation points Microsoft Vendor
1 answer
SSIS Incremental Extract and Load for Multiple Tables in one Job / Pipeline
Greetings, We have one Source System DB (SQL) which had 120 Tables. I want to Extract all Tables (120) from Source Database and then Load them in Target Database (which is also SQL). Key Requirements: I want to run this as Job, one time daily …
asked 2024-12-12T12:02:51.8133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 40%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDK%3C/text%3E%3C/svg%3E)
Dinesh Kumar Sharma
20
Reputation points
answered 2024-12-13T05:22:18.33+00:00
ZoeHui-MSFT
38,956
Reputation points
2 answers
User access failure SQL integration
Hi, im having this issue. How can I grant myself the proper access to pass this stage? I tried everything but it still running into same issue. A screenshot of the issue I'm having is below. How can I resolve this
asked 2024-12-11T20:09:16.33+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 63%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZ3%3C/text%3E%3C/svg%3E)
ZM-3283
40
Reputation points
answered 2024-12-12T07:33:31.6733333+00:00
Olaf Helper
45,371
Reputation points
1 answer
How to Force SSIS in Visual Studio 2022 to use ODBC Version 2.5 Connection
Hi, I have to migrate SQL Server SSIS packages from a legacy machine onto a new one. The legacy machine used - as the IDE - Visual Studio 2017. These packages copied data from an existing 3rd-party system using their ODBC driver as the source…
asked 2024-12-09T14:17:31.2866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 88%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMC%3C/text%3E%3C/svg%3E)
Mr. C
0
Reputation points
commented 2024-12-11T21:43:57.3633333+00:00
Erland Sommarskog
114.6K
Reputation points MVP
2 answers
One of the answers was accepted by the question author.
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…
asked 2024-11-12T13:59:46.06+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 86%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETT%3C/text%3E%3C/svg%3E)
Teresa Thomas
21
Reputation points
accepted 2024-12-10T13:16:16.3666667+00:00
Teresa Thomas
21
Reputation points
1 answer
SSIS package no running in 64 bit mode.
I have an ssis project that is running perfectly on SQL Server 2019 using x32 bits and i need to run it on x64. I have installed the OLEDB drivers, sql server on x64 both 2019 and 2022 and when i tried to execute it shows this error locally. Also im …
asked 2024-12-08T04:17:32.77+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 91%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA8%3C/text%3E%3C/svg%3E)
Alex-8104
0
Reputation points
commented 2024-12-10T05:22:06.9433333+00:00
ZoeHui-MSFT
38,956
Reputation points
2 answers
One of the answers was accepted by the question author.
Parsing a comma delimited file that has comma embedded within double quotes
Hello: I am working with a Integration Project in MS VS 2019. I have a comma-delimited flat file. One of the fields is double-quoted and may have a comma inside it. When the file gets parsed, it gets thrown of by the embedded comma, For example, one of…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,313 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,619 questions
asked 2020-11-25T17:15:54.137+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 0%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVV%3C/text%3E%3C/svg%3E)
Venkat Venkataramanan
76
Reputation points
commented 2024-12-09T07:50:18.6966667+00:00
Fauxjacket
0
Reputation points
2 answers
Login failed for user domain/machinename$ on SharePoint subscription servers
We have Application and web server in which we have installed Sharepoint server subscription edition. Both the servers shows below SQL error under server logs. ‘Microsoft Monitoring Agent’ which is a health service and tries to connect with SQL system…
asked 2024-12-03T17:44:27.6466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 49%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Snehal Sutar
0
Reputation points
commented 2024-12-04T21:48:55.44+00:00
Erland Sommarskog
114.6K
Reputation points MVP
0 answers
While connecting PowerBi Dataset from SSIS through SSAS processing Task
While connecting PowerBi Dataset from SSIS through SSAS processing Task , I could not make test connection successful. However, I could the tables of PBI dataset and while processing it is throwing the error like below "[Analysis Services…
asked 2024-12-02T08:26:30.1966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 95%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPC%3C/text%3E%3C/svg%3E)
Prabu, Chandran
41
Reputation points
commented 2024-12-03T07:26:35.6733333+00:00
ZoeHui-MSFT
38,956
Reputation points
1 answer
How to Force SSIS to Extract data from read-only excel
Hi Everyone, I have an SSIS package that loads data from Excel into SQL Server database, currently the package keeps failing with this error: It is already open exclusively by another user or you need permission to view and write its data. None of these…
asked 2024-12-02T17:37:36.3733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 82%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
tobz
161
Reputation points
answered 2024-12-03T05:27:06.25+00:00
ZoeHui-MSFT
38,956
Reputation points
2 answers
One of the answers was accepted by the question author.
SSIS requirement at deployment server with Excel files as data source?
Hello, I have a SSIS that was created from Visual Studio 2019. It loads the data from an Excel file to a table in a SQL database. The development computer has Windows 10, M365, and Microsoft Access Database Engine 2016 (both 32 and 64 bits). It runs…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 5%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
2 answers
SSIS package that supposed to export data from SQL to Excel stopped working after upgrading to SQL2022
Hello. We have multiple SSIS packages that import data from Excel into SQL and export results back to Excel. All those SSIS packages were designed in VS 2012, connecting to SQL 2012 and Excel 2013, and we can run it successfully as a part of SQL job or…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 10%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
5 answers
Cannot install SSIS, no Visual Instance Studio found
I have Visual Studio 2022, Visual Studio 2017, SSMS 19 installed on my machine, but when I go to install SSIS no instance of VS is found.
asked 2023-07-26T22:35:33.9+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 6%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
Krista Moore
35
Reputation points
commented 2024-12-02T19:24:42.1533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 50%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBJ%3C/text%3E%3C/svg%3E)
Bukstein, Jay (He/Him/His) (MNIT)
0
Reputation points