Windows for business | Windows Server | Storage high availability | Clustering and high availability
1,129 questions
2 answers
SQL cluster cannot failover. SQL services cannot start
Hi, I have a 2 node SQL server cluster which cannot failover. The SQL program and DB are located in the shared disk When we try to failover the resource, it cannot auto failover from node A to B. We need to stop node A, manual active all resource in node…
Windows for business | Windows Server | Storage high availability | Clustering and high availability
SQL Server | Other
14,530 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(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)
![](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, 89%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
0 answers
cant get SQL server to connect to SSMA
I don't know enough about SQL Server to really tell you what is going wrong, SSMA won't connect to anything I've downloaded SQL Express twice and I can't seem to get this thing to work, AI keep saying something about a .mof file I can't find on my…
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
574 questions
asked 2025-08-28T21:26:31.44+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, 7.000000000000001%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJG%3C/text%3E%3C/svg%3E)
Judy Graham
0
Reputation points
commented 2025-08-29T13:39:09.52+00:00
Erland Sommarskog
124.9K
Reputation points MVP
Volunteer Moderator
0 answers
InvalidItemNameException in SSRS 2016/2019 – Impact of URL-Encoded Characters Post Upgrade to Version 15.0.1104.39
After upgrading SQL Server Reporting Services (SSRS) from version 15.0.1102.962 to 15.0.1104.39, attempts to create folders via the SSRS web service now fail with the following error: InvalidItemNameException: “The name of the item 'Name contains…
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,077 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(272, 2%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZ%3C/text%3E%3C/svg%3E)
3 answers
SQL Server 2022 : Issue Restoring Database from 2014 Fails Without 'sysadmin' Role
We are attempting to restore a SQL Server 2014 database to SQL Server 2022. The process includes updating the database compatibility level from 120 (SQL 2014) to 160 (SQL 2022) after restoration. The issue we are encountering is: The restore and…
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
574 questions
asked 2025-06-12T06:28:17.4766667+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(220.8, 39%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPA%3C/text%3E%3C/svg%3E)
Pagare, Ankit
0
Reputation points
answered 2025-08-29T09:35:12.75+00:00
AJIN ANIYAN
0
Reputation points
0 answers
SSRS Report Export to Excel Shows Content Warning
Hello, In our application, while trying to open an SSRS report exported to Excel, we are getting the following warning message: “We found a problem with some content in excelfilename.xlsx. Do you want us to recover as much as we can? If you trust the…
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,077 questions
asked 2025-08-29T06:01:53.6166667+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, 10%, 40%)' 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)
Akshayaa Kalyanavenkatesh
60
Reputation points
asked 2025-08-29T06:01:53.6166667+00:00
Akshayaa Kalyanavenkatesh
60
Reputation points
0 answers
How to resolve issue of Audit log table containing incorrect data?
We have created a parent table & child table in SQL Server database. For one parent record, there are multiple child records. When a child record in updated, a Stored Procedure is called in which a few fields of all the child records are updated that…
SQL Server | Other
14,530 questions
asked 2025-08-28T09:25:17.3166667+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, 57.00000000000001%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
John
0
Reputation points
commented 2025-08-28T21:27:51.1366667+00:00
Erland Sommarskog
124.9K
Reputation points MVP
Volunteer Moderator
0 answers
WCF EndpointNotFoundException when connecting to
System.ServiceModel.EndpointNotFoundException: Could not connect to the remote endpoint 18775299031 Server stack trace: at System.ServiceModel.Channels.SocketConnectionInitiator.Connect(Uri uri, TimeSpan timeout) at…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,721 questions
asked 2025-08-28T14:42:13.1433333+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, 2%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
shreyansh raj
0
Reputation points
commented 2025-08-28T21:17:28.2533333+00:00
Erland Sommarskog
124.9K
Reputation points MVP
Volunteer Moderator
2 answers
Cores Per Socket Best Practices for VMs
Hello, What configuration offers better performance for SQL Server Enterprise Edition Running on virtual machines like VMWare: multiple sockets with one core each (e.g., 8 sockets, 1 core per socket) or a multi-core setup (e.g., 1 socket, 8 cores)?…
SQL Server Database Engine
334 questions
asked 2025-07-22T19:08:33.1466667+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(220.8, 1%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWG%3C/text%3E%3C/svg%3E)
Wallace, Glenn
20
Reputation points
commented 2025-08-28T16:41:47.5533333+00:00
Ben Miller-(DBADuck)
195
Reputation points MVP
1 answer
I have a 2019 SQL database which is the primary, I want to set up a secondary server using logshipping. What is the highest version on SQL server I can install. Upgrading the primary is not an option.
The supplier has a transactional database that is on a SQL 2019 server. They provide us a reporting copy using logshipping. We would like to install the latest possible version of SQL server that would be compatible. Will be able to get away with a SQL…
SQL Server Database Engine
334 questions
asked 2025-08-28T12:47:25.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(19.2, 46%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Shipra Bajpai NHS
0
Reputation points
answered 2025-08-28T15:08:51.2166667+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(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bruce (SqlWork.com)
79,601
Reputation points
Volunteer Moderator
3 answers
What is Microsoft Plan for upgrading SSRS Report Viewer Control to Unified .NET platform
What is the Microsoft Plan for upgrading SSRS Report Viewer Control to Unified .NET platform? Link…
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,077 questions
asked 2025-03-12T20:54:28.5033333+00:00
Ambar Prajapati
0
Reputation points
answered 2025-08-28T09:34:38.75+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, 87%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Sathesh Dhanasekaran
0
Reputation points
1 answer
sql cluster failover slower failover when only cluster and client network fails much faster when all networks fail
We have setup a simple two node SQL Server Cluster using SQL cluster (not WSFC windows cluster), plus witness disk, with two network adaptors on each node Cluster network 1 = 'Cluster and Client' / Cluster network 2 = 'Cluster only'. SQL server version -…
SQL Server | Other
14,530 questions
asked 2025-08-12T14:58:24.01+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, 22%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPB%3C/text%3E%3C/svg%3E)
Pal Ban
0
Reputation points
answered 2025-08-28T07:03:27.9666667+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(220.8, 55.00000000000001%, 31%)' 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)
Nam Bui (WICLOUD CORPORATION)
80
Reputation points Microsoft External Staff
Moderator
1 answer
Cannot connect to SQL Server - username issue
Trying to connect to SQL Server and getting "Login failed for user '<username>'. (Microsoft SQL Server, Error: 18456). My other colleagues are using the same credentials to log in with success. Don't know what else to do.
SQL Server Database Engine
334 questions
asked 2025-08-26T15:19:50.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(86.4, 72%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
Hugo Mendonca
0
Reputation points
commented 2025-08-28T06:27:10.5166667+00:00
Erland Sommarskog
124.9K
Reputation points MVP
Volunteer Moderator
1 answer
Performance degrade after migrating to SQL server 2022
Application performance degraded by 15-20 % after moving the database from SQL server 2019 to 2022 on a stand alone server. The resources and maintenance remains the same as the 2019.
SQL Server Database Engine
334 questions
asked 2025-08-27T13:56:31.7266667+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(67.2, 63%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
Ginesh
0
Reputation points
answered 2025-08-27T21:28:12.16+00:00
Erland Sommarskog
124.9K
Reputation points MVP
Volunteer Moderator
1 answer
Can I safely use NORECOVERY option when restoring a database by a BAK file?
Hello, I am trying to extract the data from a customer-provided BAK file and then discard the SQL server container after. I am using the syntax below. RESTORE DATABASE [ABC123] FROM DISK = '/var/opt/mssql/data/ABC123.bak' WITH MOVE 'ABC123.mdf'…
SQL Server Database Engine
334 questions
asked 2025-08-22T21:26:12.3866667+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, 48%, 26%)' 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)
dave
0
Reputation points
commented 2025-08-27T21:02:13.0733333+00:00
Erland Sommarskog
124.9K
Reputation points MVP
Volunteer Moderator
1 answer
SQL 2025 release candidate - 180day expiration too for (free edition) express version?
SQL 2025 release candidate - 180day expiration too for (free edition) express version?
SQL Server Database Engine
334 questions
asked 2025-08-27T07:20:53.24+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(28.799999999999997, 10%, 12%)' 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)
Salka, Milan
21
Reputation points
edited an answer 2025-08-27T17:39:42.6766667+00:00
Bruce (SqlWork.com)
79,601
Reputation points
Volunteer Moderator
1 answer
Error execute a SSIS Packed with SQL Agent
Hello, we have a very strange problem when executing an SSIS package with the SQL Agent. The package has the following tasks for an Excel file: 1. Check file in the source path. 2. Copy file to the destination path. 3. Open file in the destination…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,721 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(217.60000000000002, 15%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
MSOLEDBSQL19 driver seems to ignore TrustServerCertificate=yes if SQL Server Force Encryption is yes
Microsoft SQL Server 2019 with GDR 2101 (KB5021125) is installed on a Windows Server 2019 computer. The SQL Server has a self-signed certificate and is configured with Force Encryption = yes. A Windows Server 2012 R2 computer has Microsoft OLEDB…
SQL Server | Other
14,530 questions
asked 2023-06-29T16:59:55.2+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(60.8, 88%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMG%3C/text%3E%3C/svg%3E)
Mitch Gershonowitz
25
Reputation points
commented 2025-08-26T22:25:44.45+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, 48%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENL%3C/text%3E%3C/svg%3E)
Nayak, Lakshminarayan
20
Reputation points
1 answer
installation Signing Certificate Authority pour MSSQL.
Il semble que le problème ne soit pas lié à l'application, mais plutôt à SQL Server qui tombe en panne. Ainsi, si MM Server et Client sont en cours d'exécution et que SQL Server tombe en panne, MM Client ne peut pas charger/actualiser les données de la…
SQL Server Database Engine
334 questions
asked 2025-08-26T16:46:04.66+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(89.60000000000001, 96%, 18%)' 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)
ANDRE CONGO
0
Reputation points
answered 2025-08-26T21:38:45.5433333+00:00
Erland Sommarskog
124.9K
Reputation points MVP
Volunteer Moderator
3 answers
Best practice with sp_syspolicy_events_reader and ##MS_PolicyEventProcessingLogin##
The SQL Server logs on our primary replica (Microsoft SQL Server 2022 with Always On) has been filling up with this repeated message: The activated proc '[dbo].[sp_syspolicy_events_reader]' running on queue 'SQLAG1_msdb.dbo.syspolicy_event_queue'…
SQL Server Database Engine
334 questions
asked 2025-08-05T14:53:19.4333333+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, 74%, 33%)' 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)
anna@tec
0
Reputation points
answered 2025-08-26T20:36:57.6366667+00:00
Erland Sommarskog
124.9K
Reputation points MVP
Volunteer Moderator
1 answer
"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
334 questions
asked 2025-08-26T18:17:37.55+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, 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)
N B
0
Reputation points
edited an answer 2025-08-26T19:56:26.97+00:00
Alberto Morillo
34,926
Reputation points MVP
Volunteer Moderator