SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,373 questions
2 answers
Error connecting to SQL Server in SCCM
I want to use SQL queries for SCCM, but I encounter an error when connecting to the server in SQL Server Management Studio. The message says, "A connection was successfully established with the server, but then an error occurred during the login…
asked 2025-01-26T07:31:59.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(179.20000000000002, 31%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGA%3C/text%3E%3C/svg%3E)
golden alick
140
Reputation points
answered 2025-01-27T01:59:08.59+00:00
AllenLiu-MSFT
47,626
Reputation points Microsoft Vendor
1 answer
What is MARS commection
Hi, ALL, I thought that MARS connection is for the following scenario: SELECT field1 FROM table1 WHERE SELECT field2 FROM table2 WHERE table2.field1 = table1.field1_value As you can see there are 2 open statements for which MARS is a solution, Apparently…
asked 2025-01-26T22:47:42.9533333+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(147.20000000000002, 3%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIK%3C/text%3E%3C/svg%3E)
Igor Korot
46
Reputation points
commented 2025-01-27T01:09:17.9133333+00:00
Igor Korot
46
Reputation points
0 answers
"Unable to install SQL Server (setup.exe) Exit Code (Decimal): -2061893607" - Error
Please help me, I need assistance as soon as possible. I uninstalled my previous SQL Server version and now I want to install SQL Server 2022, but I'm getting an error.
asked 2025-01-26T16:20:08.6033333+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(243.2, 0%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMD%3C/text%3E%3C/svg%3E)
Mihael Dedić | Student
0
Reputation points
commented 2025-01-27T01:09:10.67+00:00
LiHongMSFT-4306
30,286
Reputation points
1 answer
One of the answers was accepted by the question author.
Error during installation of SQL Server 2022 Express - Exit code (Decimal) - Wait on the Database Engine recovery handle failed
Hi, I tried to install SQL Server 2022 Express a couple of times and I keep getting the error: Exit code (Decimal): -2061893606 Error description: Wait on the Database Engine recovery handle failed I know it's a generic error and I tried to check the…
![](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(217.60000000000002, 92%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
5 answers
SqlDataReader error “Invalid attempt to read when no data is present”
My environment used is Visual Studio 2022 v17.12.4. Language is C# and connecting to SQL Server Express v16.0.1135.2. This is a Windows form using .Net Framework 4.8.1. I am getting the error message “Invalid attempt to read when no data is present”…
.NET
.NET
Microsoft Technologies based on the .NET software framework.
4,066 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,373 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
11,236 questions
![](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, 43%, 32%)' 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)
1 answer
How to Register SPN for MSA/gMSA in SQL Server on Azure VMs
A server farm consisting of about 20 Azure SQL VMs is undergoing a security hardening exercise. The goal is to transition from built-in and individual domain accounts to Managed Service Accounts (MSA) and Group Managed Service Accounts (gMSA) to…
asked 2025-01-26T20:36:06.2033333+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(73.60000000000001, 55.00000000000001%, 17%)' 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)
Abimbola Adeniran
66
Reputation points
answered 2025-01-26T20:55:18.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(291.2, 38%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
Marcin Policht
32,585
Reputation points MVP
2 answers
Get information about event
Hi, ALL, The docs at https://learn.microsoft.com/en-us/sql/t-sql/statements/create-event-notification-transact-sql?view=sql-server-ver16#examples sample D shows how check for the event However, I took a look at the sys.event_notification table and there…
asked 2025-01-25T18:30:16.2233333+00:00
Igor Korot
46
Reputation points
commented 2025-01-26T13:49:16.4433333+00:00
Erland Sommarskog
116K
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
CREATE NOTIFICATION IF NOT EXIIST
Hi, ALL, Is there a way to do thttps://learn.microsoft.com/en-us/sql/t-sql/statements/create-event-notification-transact-sql?view=sql-server-ver16 if one do not exist? Thank you,
asked 2025-01-25T03:34:34.7833333+00:00
Igor Korot
46
Reputation points
accepted 2025-01-26T02:27:19.2266667+00:00
Igor Korot
46
Reputation points
0 answers
SQL Server fatal error 4014
Hi, I got error: MSSQLSERVER 4014 A fatal error occurred while reading the input stream from the network. The session will be terminated (input error: 10054, output error: 0). I applied the recommendations according to this…
asked 2025-01-24T13:00:55.5933333+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(304, 60%, 39%)' 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)
Андрей Михалевский
3,401
Reputation points
commented 2025-01-26T02:10:41.2366667+00:00
LiHongMSFT-4306
30,286
Reputation points
1 answer
i am unable to indtall sql server on my laptop, i am attaching a photo of what comes up as a problem
device specifications ryzen 5 ; 8 gb ram
asked 2025-01-24T12:14:26.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(35.2, 26%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
Desh Shubham
0
Reputation points
edited a comment 2025-01-26T01:55:06.6233333+00:00
LiHongMSFT-4306
30,286
Reputation points
1 answer
Can't connect to SQL Server anymore.. Please help.
I used SQL last year for sometime just fine, then recently this month tried getting back to it & suddenly it doesn't work. I might have deleted some files by accident so I uninstalled everything SQL related & installed again. Still not connecting…
asked 2025-01-23T22:54:45.59+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, 21%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKE%3C/text%3E%3C/svg%3E)
Karim El Kadri
0
Reputation points
answered 2025-01-26T01:15:42.4666667+00:00
LiHongMSFT-4306
30,286
Reputation points
2 answers
Invalid object name 'STRING_SPLIT' in SQL Server 2019
Hi Support, Our SQL server version is 2019 and check the compatibility level is 150, but it still have error "Invalid object name 'STRING_SPLIT' ". We also tried the case sensitive according to this link, both of them have the same error. …
asked 2022-04-04T02:26:23.81+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, 43%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
Chong
871
Reputation points
commented 2025-01-25T21:28:12.8033333+00:00
Erland Sommarskog
116K
Reputation points MVP
10 answers
One of the answers was accepted by the question author.
Microsoft SQL Server Studio - Dark Mode
Is there any official method to use Microsoft SQL Server Management Studio Studio with Dark Mode?
Azure SQL Database
Azure SQL Database
An Azure relational database service.
5,943 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,378 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,373 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,682 questions
asked 2023-12-19T13:11:52.4966667+00:00
Kıvanç ÖZDEMİR
135
Reputation points
answered 2025-01-25T19:04:25.2733333+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(0, 70%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
Joshua Moonstar
0
Reputation points
2 answers
One of the answers was accepted by the question author.
I get an error when I connect to the local installed SQLserver and try to load data into PowerBi.
This is the error I get. Details: "Loading assembly file 'System.EnterpriseServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' failed for data source type 'SQL'" I installed the latest version os SQL and…
asked 2025-01-22T15:25:46.0966667+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, 52%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUS%3C/text%3E%3C/svg%3E)
Uco Suierveld
20
Reputation points
commented 2025-01-25T16:06:55.9+00:00
Uco Suierveld
20
Reputation points
2 answers
Unable to install SQL Server 2019.
Detail.txt Screenshot 2025-01-23 163220.jpgI have tried multiple times and I recieve the same message every time. I have attached a screenshot of the error and the text file it gave me
asked 2025-01-23T22:38:25.6033333+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(105.60000000000001, 56.00000000000001%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDW%3C/text%3E%3C/svg%3E)
Denver Wills
0
Reputation points
answered 2025-01-24T18:39:59.5233333+00:00
Erland Sommarskog
116K
Reputation points MVP
1 answer
Understanding Transaction Log Truncation in SQL Server 2022
In an Azure SQL Server 2022 environment with multiple databases configured with FULL recovery mode, hourly log backups are taken, and full backups occur nightly. According to the documentation, the expectation is that the log space usage should decrease…
asked 2025-01-21T08:37:26.9166667+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(96, 76%, 19%)' 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 Limongello
0
Reputation points
commented 2025-01-24T18:10:15.7266667+00:00
Erland Sommarskog
116K
Reputation points MVP
1 answer
Error at recreating new Excel table in SSIS after deletion
Greetings, I was trying to make a SSIS package in order to recreate an Excel file which contains some result of a SQL query I'm executing. My architecture is like this: In "Borrar tabla Excel" I delete the existing Excel table via a DROP…
asked 2025-01-23T15:38:26.5066667+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, 60%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFS%3C/text%3E%3C/svg%3E)
Frank Sebastián Franco Hernández
20
Reputation points
commented 2025-01-24T13:36:18.0733333+00:00
Frank Sebastián Franco Hernández
20
Reputation points
3 answers
Transient error in SSRS reports.
When we open a report in SSRS web service url it sometimes fails with the below error. When the same report is opened in web portal url with the same account, it opens with no errors. If we open an SSMS session with the same user and run any stored…
asked 2025-01-22T05:16:44.49+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(294.40000000000003, 41%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENR%3C/text%3E%3C/svg%3E)
Nivedita Rao
0
Reputation points
answered 2025-01-24T13:10:11.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(76.8, 38%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERG%3C/text%3E%3C/svg%3E)
Ravi Garg
0
Reputation points
3 answers
Transient error in SSRS reports.
When we open a report in SSRS web service url it sometimes fails with the below error. When the same report is opened in web portal url with the same account, it opens with no errors. If we open an SSMS session with the same user and run any stored…
asked 2025-01-22T05:16:44.49+00:00
Nivedita Rao
0
Reputation points
answered 2025-01-24T13:10:11.51+00:00
Ravi Garg
0
Reputation points
0 answers
SSRS Report Server Connection refused
Hello, i have trouble with SSRS, when i try to connect on the local Server via http://localhost/reports or http://localhost/reportserver the connection is refused. On the machine there are SQL Server2022 and SSRS 2022 installed. I checked the services…
asked 2025-01-24T10:22:22.87+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, 18%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMW%3C/text%3E%3C/svg%3E)
Martin Wegner
0
Reputation points
edited the question 2025-01-24T12:30:10.0733333+00:00
Martin Wegner
0
Reputation points