SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,860 questions
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…
asked 2023-03-28T13:45:32.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(310.4, 13%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
JC Sanders
5
Reputation points
edited an answer 2024-05-18T09:01:56.57+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(163.2, 85%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAJ%3C/text%3E%3C/svg%3E)
Alok Jha
0
Reputation points
4 answers
One of the answers was accepted by the question author.
Not able install sql server 2022 in window 11.
Error installing SQL Server Database Engine Services Instance Features The system cannot find the path specified Error code:…
asked 2024-03-03T17:37:10.53+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, 81%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDP%3C/text%3E%3C/svg%3E)
dinabondhu pramanik
25
Reputation points
answered 2024-05-18T08:57:03.8733333+00:00
Alok Jha
0
Reputation points
5 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
36
Reputation points
answered 2024-05-18T08:36:47.0033333+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(249.60000000000002, 34%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAJ%3C/text%3E%3C/svg%3E)
Alok Jha
0
Reputation points
4 answers
SSIS Error: The AcquireConnection method call to the connection manager Source failed with error code 0xC0014009.
Hello, We have a Job in MS SQL Server Management Studio. This job runs several Visual Studio SSIS packages. When we launch the job it fails at step one. Step one is to retrieve data from a AS400 DB and place it in some ODS tables within our…
asked 2021-06-17T10:50:35.957+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(51.2, 80%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERI%3C/text%3E%3C/svg%3E)
Romeo Isfan
11
Reputation points
answered 2024-05-17T16:29:25.6866667+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(16, 53%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELC%3C/text%3E%3C/svg%3E)
Larry Carrethers
0
Reputation points
6 answers
SQL SERVER 2022 - certificate error when creating a job for integration services
In a test environment with SQL Server 2022 Developer Edition, I am trying to create a job to run an SSIS package. These same packages have been successfully tested in SQL 2019. When trying to create the job, configuring it as follows: General / Owner :…
asked 2024-04-10T03:35:21.82+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, 98%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Marcio Matos
30
Reputation points
answered 2024-05-17T16:24:25.9966667+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(19.2, 78%, 11%)' 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)
Carl BRUBAKER
0
Reputation points
0 answers
Modelos tabulares no liberan memoria
Buenos dias, paso a consultar por un problema. Tengo varios modelos tabulares, y cada vez que proceso alguna partición, la memoria de mi servidor llega a 85/90%. Una vez terminado el procesamiento, la memoria queda en esos niveles, por lo que si quiero…
asked 2024-05-17T11:56:15.51+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(256, 52%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERL%3C/text%3E%3C/svg%3E)
Roberto Lavisse
0
Reputation points
asked 2024-05-17T11:56:15.51+00:00
Roberto Lavisse
0
Reputation points
1 answer
客户端与服务端sql server交互问题
问题背景： 一款系统产品的部署测试，SQL Server版本SQLServer2016SP2-FullSlipstream-x64-CHS（一开始为2017有问题，后降到2016仍有问题），服务器系统Windows Server…
asked 2024-05-17T06:18:32.2966667+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(284.8, 94%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGG%3C/text%3E%3C/svg%3E)
GUGU GU
0
Reputation points
edited an answer 2024-05-17T09:58:14.6466667+00:00
MikeyQiao-MSFT
650
Reputation points Microsoft Vendor
2 answers
SQL Server 2022 express download problem unable to install SQL Server. Exit code(Decimal): -2061893606
I'm trying to download SQL Server 2022 Express, but it's giving the following error. I checked the log and click the SystemConfigurationCheck_Report I received the warning shown in the image above. Is the download error caused by this? I had already…
asked 2024-05-09T12:23:12.46+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(259.20000000000005, 4%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Mehmed Aras
0
Reputation points
commented 2024-05-17T09:08:32.44+00:00
LucyChenMSFT-4874
1,280
Reputation points
2 answers
One of the answers was accepted by the question author.
Create a SQL Server JOB using SSMS 20.X for a .dtsx package from the ssisdb server
I installed SSMS 20.X and understood the problems connecting to the instance: I am successfully connected. Now I would like to schedule a JOB with an integration services step (which I have done hundreds of times in the past)... but with SSMS versions…
asked 2024-05-16T12:42:16.2333333+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(268.8, 60%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAC%3C/text%3E%3C/svg%3E)
Alen Cappelletti
951
Reputation points
accepted 2024-05-17T09:04:54.55+00:00
Alen Cappelletti
951
Reputation points
1 answer
How to fix issue in prepapred statement on jdbc driver 12.6.1 jre11
Recently we have upgrade the SQL JDBC driver from version 4 to version 12.6.2 jre11 as we upgraded to 2022 SQL server. After changing the driver we are facing issue in prepared statement. The same code with 12.6.2 jre8 and java8 returning results . But…
asked 2024-05-10T13:49:21.6766667+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(236.8, 16%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDM%3C/text%3E%3C/svg%3E)
Dhamodharan M
0
Reputation points
commented 2024-05-17T07:50:19.5+00:00
MikeyQiao-MSFT
650
Reputation points Microsoft Vendor
4 answers
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…
asked 2024-04-29T21:26:46.1566667+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(281.6, 72%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
Linda
1
Reputation point
answered 2024-05-17T07:20:47.92+00:00
ZoeHui-MSFT
33,386
Reputation points
4 answers
One of the answers was accepted by the question author.
set order by based on asc series
Hello This is my sql table with data /****** Object: Table [dbo].[temp_days_order_pending] Script Date: 05/15/2024 23:12:34 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE…
0 answers
mssql server terminated abruptly
Details to log to Microsoft our production mssql data node 01 did a failover to node 02 due to the trigger pt below. Require MSFT advice on why does the DLL below trigger the failover, and how can we prevent this from happening again ? Tech Stack OS :…
asked 2024-05-16T09:19:10.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(144, 48%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETW%3C/text%3E%3C/svg%3E)
Tan, Wilson WY
0
Reputation points
commented 2024-05-17T02:20:44.96+00:00
MikeyQiao-MSFT
650
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Azure SQL Server Database serverless or Elastic pool
I'm just getting started with Azure SQL Database and have some questions about pricing. I currently have about 7 databases in use with a free student subscription plan for a development environment. Most of the databases are only used occasionally when…
asked 2024-01-24T05:27:17.96+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(169.60000000000002, 73%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVQ%3C/text%3E%3C/svg%3E)
Viet Quoc
25
Reputation points
commented 2024-05-17T01:02:49.5966667+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(230.39999999999998, 25%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELM%3C/text%3E%3C/svg%3E)
Lindsay Mathieson
30
Reputation points
3 answers
One of the answers was accepted by the question author.
Could it be possible to restore the SQL Server 2005 database into the SQL Server 2019
I am using SQL Server 2005 from the year 2010. Now I am wishing to install SQL Server 2019 in the same machine. Is there any problem if I restore the previous version in new version ?
asked 2021-07-23T07:55:39.29+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(22.400000000000002, 12%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPK%3C/text%3E%3C/svg%3E)
Prasanta Kumar Biswas
21
Reputation points
commented 2024-05-16T21:32:12.1+00:00
Erland Sommarskog
102.2K
Reputation points
1 answer
SQL 2016 Linked Server Problems
I am trying to setup a linked server connection to another DB running a non-MSSQL DB. On the local server the account I am using has Sysadmin right on the remote server the local DB account has what they call Admin rights as well. We have tried using…
asked 2024-05-15T20:35:42.68+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(236.8, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER4%3C/text%3E%3C/svg%3E)
rr-4098
1,256
Reputation points
answered 2024-05-16T21:29:17.98+00:00
Erland Sommarskog
102.2K
Reputation points
1 answer
How do I fix Error when install SQL server standalone installation :SQL Server Setup failure. SQL Server Setup has encountered the following error: Exception has been thrown by the target of an invocation.
TITLE: SQL Server Setup failure. SQL Server Setup has encountered the following error: Exception has been thrown by the target of an invocation.. For help, click:…
asked 2024-01-01T07:39:10.5133333+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(169.60000000000002, 59%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
chinedu mbaodoh
0
Reputation points
commented 2024-05-16T21:21:53.05+00:00
Erland Sommarskog
102.2K
Reputation points
1 answer
One of the answers was accepted by the question author.
Performance Monitoring tools used for 4 hrs
Using Performance Monitoring tool to check on the performance of the database server. I cannot extend the duration to more than 1000 secs. What are the other options for performance monitoring so that I can get the data for 4 hrs
![](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(51.2, 55.00000000000001%, 14%)' 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)
1 answer
Migrating On-prem Sql DB to Azure Managed Sql Instance
Hello, I have created recently Azure Managed Instance and looking some expert guidance as I need to restore on-prem Database first for testing but my database is in simple recovery mode as it's non-prod DB. Do I need to change recovery model to FULL then…
asked 2024-05-14T22:06:14.8033333+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, 17%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
pdsqsql
391
Reputation points
commented 2024-05-16T15:25:05.8+00:00
Alberto Morillo
32,986
Reputation points MVP
1 answer
Auditing SSRS Administrator role events
We have multiple users assigned to Administrator role of our SSRS product. So, how shall we audit what those individuals have done with the power of Administrator role, such as changing folder/report securities, deleting/adding folders/reports etc..?
asked 2023-01-17T12:10:35.6433333+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(214.4, 30%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Ayca Akcay
26
Reputation points
commented 2024-05-16T14:57:12.9933333+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(188.79999999999998, 99%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EF%3C/text%3E%3C/svg%3E)
FodorT
0
Reputation points