451 questions
1 answer
DB recovery in a semi-annual SQL plan
I accidentally downloaded SQL Server and SSMS to a computer for a half-year plan and suddenly I can't connect to the localhost server because half a year has passed. My problem is that I have a very important DB that I don't have access to now. Is there…
SQL Server Database Engine
![](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, 72%, 38%)' 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
How can I get the email used to buy a sqlserver license
I have a SQL Server 2017 license, but I can't find the email address it was purchased with. I don't think it's tied to a tenant, but it could be tied to another account, but I can't figure out which one. Isn't there a form where I can enter the license…
SQL Server Database Engine
451 questions
asked 2025-10-24T13:48:47.1+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(288, 72%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Meteo Solutions
0
Reputation points
answered 2025-10-25T21:08:09.1233333+00:00
Azar
30,735
Reputation points MVP
Volunteer Moderator
1 answer
Event error log :-fatal error occurred while reading the input stream from the network. The session will be terminated
Event error log :-fatal error occurred while reading the input stream from the network. The session will be terminated Impact:- Application is not working properly with below error. Error: TCP Provider, error: 0 - The specified network name is no…
SQL Server Database Engine
451 questions
asked 2025-10-25T11:46:42.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(54.400000000000006, 10%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJE%3C/text%3E%3C/svg%3E)
Jagadeesan E
0
Reputation points
answered 2025-10-25T19:34:14.41+00:00
Erland Sommarskog
127.4K
Reputation points MVP
Volunteer Moderator
1 answer
I have A clustered SQL Server Instance that does not fail-over completely due to using SQL authenticating credentials on an appvolumes database for a VDI database.
Hello, I have A clustered SQL Server Instance that does not fail over completely due to using SQL authenticating credentials on an AppVolumes database for a VDI database. The account being used to access the database has the user mapping to the…
SQL Server Database Engine
451 questions
asked 2025-09-22T07:03:14.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(300.8, 24%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMO%3C/text%3E%3C/svg%3E)
Marc o
0
Reputation points
commented 2025-10-25T10:58:58.78+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, 84%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKD%3C/text%3E%3C/svg%3E)
Karpurapu Durga Prasanna (Quadrant Resource LLC)
5
Reputation points Microsoft External Staff
2 answers
SQL Server patching and information on Cumulative Updates and Security Updates(GDR and CU GDR)
Hello Support, I am a bit confused of what the patches mean and contain for SQL Server and will appreciate if you can clarify this for me: My question is for SQL Server 2019( but it is also applicable for SQL Server 2022 We have the RTM version…
SQL Server Database Engine
451 questions
asked 2025-10-24T08:54:05.6366667+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, 14.000000000000002%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIR%3C/text%3E%3C/svg%3E)
iliyan Rashev
0
Reputation points
answered 2025-10-24T21:06:55.2133333+00:00
Erland Sommarskog
127.4K
Reputation points MVP
Volunteer Moderator
1 answer
AT TIME ZONE - GMT Standard Time - Windows [Bug]
Hi, On Windows, SQL Server "AT TIME ZONE" uses the Windows Registry to determine time zone conversion. However, daylight savings conversions in the "GMT Standard Time" time zone on Windows become inaccurate and problematic from years…
SQL Server Database Engine
451 questions
asked 2025-10-24T09:57:17.63+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, 41%, 24%)' 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)
Alexander Ali
0
Reputation points
answered 2025-10-24T17:01:46.4166667+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, 96%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Rekha
0
Reputation points Microsoft External Staff
Moderator
2 answers
Sql Server 2014 connectivity issue after Windows patch update
Hello, We have currently Sql server 2014 SP1 and after our windows team apply the patch with GPO which caused connectivity issue within the application although I am able to connect via my local SSMS but when our application trying to connect it causing…
SQL Server Database Engine
451 questions
asked 2025-09-23T00:35:23.5033333+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
431
Reputation points
commented 2025-10-24T15:16:19.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(105.60000000000001, 79%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDY%3C/text%3E%3C/svg%3E)
Dinesh Yadlapalli
0
Reputation points Microsoft External Staff
Moderator
0 answers
Experience with SQL2014 to SQL2022 where table column data has been encrypted.
Have a SQL2014 Express database (instance=COMP) where some columns in a table have been encrypted (using Master Key, Certificate, Symmetric etc). Have created a SQL2022 database (instance=COMP2022) and Restored into SQL2022 a backup of SQL2014. Queries…
SQL Server Database Engine
451 questions
asked 2025-10-21T09:35:04.7633333+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(44.800000000000004, 97%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBC%3C/text%3E%3C/svg%3E)
Brian Chandler
0
Reputation points
commented 2025-10-24T10:30:55.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(227.2, 35%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELN%3C/text%3E%3C/svg%3E)
Lakshmi Narayana Garikapati
470
Reputation points Microsoft External Staff
Moderator
1 answer
How to fix this error
Got this error while logging in to my Access account
SQL Server Database Engine
451 questions
asked 2025-10-15T19:05:47.4466667+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(233.6, 38%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDE%3C/text%3E%3C/svg%3E)
David Enweremadu
0
Reputation points
commented 2025-10-24T09:59:51.5666667+00:00
Lakshmi Narayana Garikapati
470
Reputation points Microsoft External Staff
Moderator
1 answer
download sql server express 2016
From where download sql server express 2016 for free
SQL Server Database Engine
451 questions
asked 2025-10-24T04:37:30.86+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(83.2, 42%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EML%3C/text%3E%3C/svg%3E)
Michael Ladyzhensky
0
Reputation points
answered 2025-10-24T09:07:22.25+00:00
Lakshmi Narayana Garikapati
470
Reputation points Microsoft External Staff
Moderator
1 answer
Connection Problem
Failed to connect to database. Error code 999 Error text Invalid OLE DB provider name specified.
SQL Server Database Engine
451 questions
asked 2025-09-09T06:37:26.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(137.6, 67%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Sandeep Mudgal
0
Reputation points
commented 2025-10-24T07:08:26.3333333+00:00
Lakshmi Narayana Garikapati
470
Reputation points Microsoft External Staff
Moderator
1 answer
DDL and DML Capture
Hello Community, I am wondering if there's an already established way to track and log all TRUNCATE, INSERTS AND DELETES statements across SQL Server. I already have a DDL trigger process that logs every DDL event on the server, specifically for CREATE,…
SQL Server Database Engine
451 questions
asked 2025-10-09T10:57:00.12+00:00
Babawale Dawodu
110
Reputation points
commented 2025-10-23T11:27:52.1933333+00:00
Babawale Dawodu
110
Reputation points
1 answer
Assistance Needed for Rolling Back Specific Transaction from SQL Server Log
Guidance is needed on recovering data from a specific transaction in SQL Server after an unintentional DELETE/UPDATE operation. The database is operating in Full Recovery Model with access to transaction log backups. Understanding that SQL Server doesn't…
SQL Server Database Engine
451 questions
asked 2025-09-09T12:18:31.7833333+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(195.2, 66%, 28%)' 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)
Rahul Lohar
0
Reputation points
commented 2025-10-23T10:00:37.95+00:00
Lakshmi Narayana Garikapati
470
Reputation points Microsoft External Staff
Moderator
1 answer
CHANGING DATE FORMAT OF SQL SERVER DATABASE
I have a database in which smalldatetime field exists. Its format is YYYYDDMM, yet I prefer YYYYMMDD. It could be set using set dateformat command, but it is only valid for current connection. I am looking for a solution to change date format permanently…
SQL Server Database Engine
451 questions
asked 2025-09-13T14:29:28.2833333+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(115.19999999999999, 7.000000000000001%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
MOON
60
Reputation points
commented 2025-10-23T09:57:25.8866667+00:00
Lakshmi Narayana Garikapati
470
Reputation points Microsoft External Staff
Moderator
1 answer
how to avoid incidents on Drive getting full due to transaction log getting full
We have been observing that the G-Drive log on the SQL server is filling up frequently in our SQL Server eventhou we have configured log drive double in size of data drive
SQL Server Database Engine
451 questions
asked 2025-09-17T06:02:49.3933333+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(192, 82%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM2%3C/text%3E%3C/svg%3E)
MohanReddyYadamuri-2064
0
Reputation points
commented 2025-10-23T09:49:44.8966667+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, 28.999999999999996%, 11%)' 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)
Singam shetty Sri ganesh
80
Reputation points Microsoft External Staff
Moderator
1 answer
Faster way to restore a MSSQL DB hosted on storage spaces.
Problem Summary We need a faster way to restore SQL Server Always On Availability Groups (AGs) that use Windows Storage Spaces, with each database on its own pool, from Nutanix app-consistent storage snapshots. Challenge Even with a per-DB pool, a…
SQL Server Database Engine
451 questions
asked 2025-09-22T07:17:43.2133333+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(176, 87%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETK%3C/text%3E%3C/svg%3E)
Tinku Kumar
0
Reputation points
answered 2025-10-23T10:05:12.9766667+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(233.6, 6%, 32%)' 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)
Nithin Krishna Madadi
0
Reputation points Microsoft External Staff
Moderator
3 answers
Why are my SQL Servers not running and won't run when I try to start them? How do I fix this?
I am trying to download new time clock software for my business, TimePilot Central 5. I keep getting error stating cannot connect to SQL Server. I have updated Windows 11, shut off my firewall, unistalled TimePilot and restarted my computer and then…
SQL Server Database Engine
451 questions
asked 2025-10-01T19:45:49.73+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, 41%, 23%)' 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)
Amber Cheramy
0
Reputation points
commented 2025-10-23T10:00:17.4933333+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(134.4, 49%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Akhil Gajavelly
645
Reputation points Microsoft External Staff
Moderator
1 answer
SQL 2022 Ent. AlwayOn availability secondary replica disconnected. Error log showing Database Mirroring login attempt failed with error: 'Connection handshake failed. An OS call failed: (8009030c) 0x8009030c(The logon attempt failed). State 67.'. [CLIENT
SQL 2022 Ent. AlwayOn availability secondary replica disconnected. Error log showing Database Mirroring login attempt failed with error: 'Connection handshake failed. An OS call failed: (8009030c) 0x8009030c(The logon attempt failed). State 67.'. …
SQL Server Database Engine
451 questions
asked 2025-10-06T12:16:21.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(73.60000000000001, 99%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPD%3C/text%3E%3C/svg%3E)
Pooran, Dave
0
Reputation points
edited a comment 2025-10-23T10:45:40.7766667+00:00
Akhil Gajavelly
645
Reputation points Microsoft External Staff
Moderator
1 answer
How to fix work on MS SQL Server
I've run Python 3.10.18 to create a connection to MS SQL Server DB 17 on macOS 15.6.1 and I get the error: The issue in the driver or the python wrapper. Fatal Python error: Segmentation fault Extension modules: charset_normalizer.md,…
SQL Server Database Engine
451 questions
asked 2025-10-06T15:01:58.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, 38%, 19%)' 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)
Ирина Грачева
0
Reputation points
commented 2025-10-23T10:49:14.2133333+00:00
Akhil Gajavelly
645
Reputation points Microsoft External Staff
Moderator
1 answer
Unable to Purchase SQL Server Pay-Per-Incident Support from Services Hub in South Korea
Hi everyone, I'm based in South Korea and trying to purchase a one-time incident support ticket for SQL Server via Microsoft Services Hub. However, when I attempt to buy the ticket, the system only allows me to select United States as the country, and I…
SQL Server Database Engine
451 questions
asked 2025-10-20T04:25:34.0233333+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(25.6, 15%, 12%)' 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)
권태우
20
Reputation points
commented 2025-10-23T11:23:40.6066667+00:00
Akhil Gajavelly
645
Reputation points Microsoft External Staff
Moderator