14,644 questions
1 answer
Login /reset the SQL server/Database credentials
Hi Team, We have a SQL Server on Prem that collects the Machine data (Industrial/Manufacturing) on a daily basis. Unfortunately, we lost the credentials to login to the SQL server. We only have the IP address, SQL server Name and Database Name. We are…
SQL Server | Other
asked 2026-01-20T13:48:41.18+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(131.20000000000002, 67%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENB%3C/text%3E%3C/svg%3E)
Nalini Bhavaraju
110
Reputation points
commented 2026-01-20T21:32:47.2466667+00:00
Erland Sommarskog
131.1K
Reputation points MVP
Volunteer Moderator
2 answers
Databasemail stops working on SQL Server 2025 after CU1 install
We have server with SQL Server 2025 RTM that works fine but when we install CU1 for SQL Server 2025 the databasemail stops sending mail from SQL Server, nor error message no mail reach mailbox. SQL Server version 17.0.4005.7
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
585 questions
asked 2026-01-20T18:20:29.8566667+00:00
Micael Carlsson
1
Reputation point
answered 2026-01-20T21:30:01.67+00:00
Erland Sommarskog
131.1K
Reputation points MVP
Volunteer Moderator
3 answers
How to delete this database?
In order to conduct the test, the 'testdb' database was created, after a series of operations, the size of the data file is 1G and the size of the log file is 0.5M. No application other than SSMS accesses it. Currently, sys.databases.state_desc =…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
585 questions
asked 2026-01-12T03:23:10.54+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(108.80000000000001, 66%, 20%)' 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)
博雄 胡
725
Reputation points
commented 2026-01-20T21:23:08.2266667+00:00
Erland Sommarskog
131.1K
Reputation points MVP
Volunteer Moderator
2 answers
failed to collect frames
continuous sql error logs in secondary read replica always on node, failed to collect frames
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
585 questions
asked 2026-01-19T16:51:40.7966667+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, 99%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBY%3C/text%3E%3C/svg%3E)
Bhavana Yadav
0
Reputation points
answered 2026-01-20T21:16:52.47+00:00
Erland Sommarskog
131.1K
Reputation points MVP
Volunteer Moderator
3 answers
DatabaseMail.exe fails after SQL Server 2022 from CU22 to CU23 - Missing Microsoft.SqlServer.DatabaseMail.XEvents.dll
Product: SQL Server 2022 Enterprise Edition Affected Versions: CU23 Component: Database Mail Summary: Database Mail fails to start or send emails after updating to SQL Server 2022 CU23 (also observed on CU22) with error indicating missing assembly…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
585 questions
asked 2026-01-19T07:29:32.3466667+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, 28.000000000000004%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMY%3C/text%3E%3C/svg%3E)
Musa YILMAZ
30
Reputation points
commented 2026-01-20T18:56:48.9233333+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, 57.99999999999999%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECR%3C/text%3E%3C/svg%3E)
Cristian Rojas Lillo
0
Reputation points
1 answer
Applying token authentication to read data from a ZenDesk source in a SSIS 2022 package
Hi, I need to maintain an existing SSIS 2022 package that performs an API call to a ZenDesk source by the removed username and password authentication method, changing this authentication type to token one. Unfortunately, I don't know ZenDesk and I have…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,772 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(115.19999999999999, 41%, 21%)' 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)
2 answers
Cannot initialize report- SCOM 2022 UR6, SSRSv16.0.8564.33454
Everything worked until a week ago. No changes made to system. These reports were working fine, so well that I created Scheduled Reports for a few of our customers. I have since disabled/removed them. Reports with issues: Reporting\Microsoft Generic…
System Center Operations Manager
System Center Operations Manager
A family of System Center products that provide infrastructure monitoring, help ensure the predictable performance and availability of vital applications, and offer comprehensive monitoring for datacenters and cloud, both private and public.
1,627 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,131 questions
Microsoft System Center | Other
Microsoft System Center | Other
Additional System Center tools and components for managing infrastructure, applications, and services
1,210 questions
asked 2024-10-08T20:02:31+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, 17%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
anthony strother
581
Reputation points
commented 2026-01-20T14:25:38.58+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, 79%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAH%3C/text%3E%3C/svg%3E)
Abdelkader Heni
0
Reputation points
4 answers
One of the answers was accepted by the question author.
Error During In-Place Upgrade from SQL Server 2016 to SQL Server 2019
I am attempting an In-Place upgrade from SQL Server 2016 (13.0.5201.2) to SQL Server 2019 RTM. I have uninstalled Microsoft SQL Server 2012 Native Client & Microsoft SQL Server 2014 Native Client. I also uninstalled SSMS 17.9 and no other SSMS is…
SQL Server | Other
14,644 questions
asked 2021-04-26T19:55:28.257+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(275.2, 5%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
DBAMonkee
96
Reputation points
commented 2026-01-20T13:58:12.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(256, 69%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKN%3C/text%3E%3C/svg%3E)
Krisztián Major
6
Reputation points
1 answer
MySQL INSERT fails with ERROR 1064, 1265, 1292 (invisible character in numeric ID, ENUM mismatch, invalid DATETIME)
Hi, I’m importing seed data into a MySQL table and my bulk INSERT fails with multiple errors depending on the row. I suspect some data-cleaning/format issues during copy/paste or CSV → SQL conversion. Table definition CREATE TABLE lead_broker_status ( …
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
585 questions
asked 2026-01-02T12:42:04.7466667+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, 74%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAT%3C/text%3E%3C/svg%3E)
Arthur Tong
0
Reputation points
edited a comment 2026-01-20T11:03:38.9733333+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
1,125
Reputation points Microsoft External Staff
Moderator
2 answers
"Is it okay to run Ola Hallengren’s index rebuild and stats update script from a separate database instead of master, and will this impact fragmentation handling?"
In my organisation, we run Ola Hallengren’s index rebuild and update stats script on a separate database instead of the master database. Is this a recommended practice, and will it affect index fragmentation or reorganisation?"
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
585 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(102.4, 72%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENB%3C/text%3E%3C/svg%3E)
2 answers
i forgot my password i set for microsoft sql and even name . so can i make new id again
Forgot my Password And and entry name With which I logined so can I reset Or how can I make New ID If I don't know anything about the old account..
SQL Server | Other
14,644 questions
asked 2026-01-02T09:36:33.4733333+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, 36%, 12%)' 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)
ROOPREET GUPTA
0
Reputation points
commented 2026-01-20T10:23:31.12+00:00
Akhil Gajavelly
1,125
Reputation points Microsoft External Staff
Moderator
2 answers
creating a new table on the sql server 2025 application gives me error
am using the ssms version 20.2.37 and SQL SERVER 2025.....creating a new table on the application gives me error TITLE: Microsoft SQL Server Management Studio This backend version is not supported to design database diagrams or tables. (MS Visual…
SQL Server | Other
14,644 questions
asked 2026-01-17T19:08:51.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(198.4, 83%, 29%)' 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)
mohmaed ahmed mohamed rahmo
0
Reputation points
edited a comment 2026-01-20T10:17:11.5633333+00:00
Akhil Gajavelly
1,125
Reputation points Microsoft External Staff
Moderator
3 answers
One of the answers was accepted by the question author.
The ORDER BY clause is invalid in views...
An error occurred while running the tsql statement. The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified. How can I fix this error? Could someone…
SQL Server | Other
14,644 questions
asked 2023-10-04T07:42:54.26+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(57.599999999999994, 59%, 15%)' 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)
ajks
20
Reputation points
edited a comment 2026-01-20T07:02:54.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(310.4, 66%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
Tripathi, Sanjeev Kumar
0
Reputation points
1 answer
Connectivity Issue Between SQL Server Databases and Windows Failover Cluster
image1.png.pdf We are currently experiencing connectivity issues between the Active/Active SQL Server databases and the Windows Failover Cluster. As a result, the cluster is not functioning properly, and all load is currently running on a single…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
585 questions
asked 2025-10-06T14:31:39.9866667+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(275.2, 51%, 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)
Mir Majeed
20
Reputation points
recommended 2026-01-20T05:02:54.6933333+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, 39%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
Vector Indexes
I have a database table with a Vector Column in SQL Server 2025 but unable to use the Create Vector Index Command
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
585 questions
asked 2026-01-19T02:16:48.04+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(48, 0%, 14%)' 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)
Bradley Jones
0
Reputation points
answered 2026-01-19T22:19:02.7766667+00:00
Erland Sommarskog
131.1K
Reputation points MVP
Volunteer Moderator
2 answers
vs_SSMS installation - Destination URLs
Dear all, I'm installing vs_SSMS (SQL Server Management Studio) on a client's server. I requested them to open internet connection to be able to install SSMS as i know that the installation once it runs, will download the required files. The client's IT…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
585 questions
asked 2026-01-13T12:48:10.6633333+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, 57.99999999999999%, 39%)' 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)
Alaa Al Halabi
0
Reputation points
commented 2026-01-19T21:51:41.4166667+00:00
Erland Sommarskog
131.1K
Reputation points MVP
Volunteer Moderator
2 answers
Local is 4.8 QA Is 4.5 Prod is 4.8 developing on local. But still on prod not works and gting error. Like cannot upgrade script component. Please help me. Tried with many options and tired. QA is Working and and same package deployed on prod fails
Local .NET is 4.8, QA Is 4.5, Prod is 4.8. changed 2 columns lengths in SSIS and not any major changes. developed on local But still on prod not works and giving error Like cannot upgrade script component. Please help me. Tried with many options and…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,772 questions
asked 2025-09-13T06:17:50.0066667+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, 38%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERN%3C/text%3E%3C/svg%3E)
ram naveen
0
Reputation points
recommended 2026-01-19T18:02:28.6333333+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
1 answer
Requirements for SQL connection testing
『In the SQL connection test, Windows authentication can connect, but SQL Server authentication cannot connect』
SQL Server | Other
14,644 questions
asked 2025-09-29T09:15:10.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(227.2, 8%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKO%3C/text%3E%3C/svg%3E)
k ogawa
0
Reputation points
recommended 2026-01-19T18:01:55.1766667+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
1 answer
Microsoft Entra ID not working in SQL Server VSCode
Whenever I try to use my Microsoft Entra ID on the SQL Server extension in VSCode, I click 'Sign in', which takes me to the authentication page in my browser where I sign in. I get the page that says I am signed in and can close the browser, but the…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
585 questions
asked 2025-07-11T17:39:09.76+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, 6%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECC%3C/text%3E%3C/svg%3E)
Carlos Casellas Garza
5
Reputation points
recommended 2026-01-19T18:01:37.7266667+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
3 answers
download sql 2022 media
where can i download the media for sql2022? Thank You, Brian
SQL Server | Other
14,644 questions
asked 2025-11-21T19:15:30.2366667+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(204.8, 49%, 29%)' 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 Coder
0
Reputation points
recommended 2026-01-19T18:01:17.4733333+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator