14,500 questions
2 answers
One of the answers was accepted by the question author.
Database Migration Assistant Related Queries
Hi There! Could you please help with below queries. Database Migration Assistant for assessment. Does it require internet connectivity on server to run the assessment effectively? I can see in 'Assessment Type' options are 'Database Engine' and…
SQL Server | Other
asked 2025-07-06T06:11:54.2533333+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, 11%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Chirag Sachdeva
281
Reputation points
commented 2025-07-06T11:59:37.9966667+00:00
Chirag Sachdeva
281
Reputation points
1 answer
SQL SERVER 2022 INSTALL FAILING File activation error on a drive that has never existed on my pc. File activation failure. The physical file name "D:\dbs\sh\5uj5\1008_054209\cmd\11\obj\x64retail\sql\mkmastr\databases\mkmastr.nativeproj\modellog.ldf"
This is definitely a weird issue. Let me setup the scenario. Just bought a new CyberPowerPC with a AMD Ryzen 5 5500, 3600 mhz, 6 core(s) , 12 logical processors. My issue is with installing SQL server 2022 developer's edition. Checking the error log I…
SQL Server Database Engine
266 questions
asked 2025-07-05T20:09:34.1733333+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(121.6, 68%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
kevin miller
0
Reputation points
answered 2025-07-06T08:27:52.88+00:00
Erland Sommarskog
121.8K
Reputation points MVP
Volunteer Moderator
1 answer
Do Microsoft CSP Annual and Triennial licenses include Software Assurance (SA)?
Do Microsoft CSP Annual and Triennial licenses include Software Assurance (SA)?
SQL Server | Other
14,500 questions
asked 2025-07-04T03:06:34.8+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(166.4, 72%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKW%3C/text%3E%3C/svg%3E)
Kannika_W Warunyaporn
0
Reputation points
answered 2025-07-05T08:37:18.91+00:00
Erland Sommarskog
121.8K
Reputation points MVP
Volunteer Moderator
1 answer
Problème d’installation de SQL Server 2022 sur un serveur RDS avec User Profile Disks (UPD)
Je tente d’installer SQL Server 2022 Standard sur un Windows Server 2022 qui héberge déjà les rôles RDS (Remote Desktop Services), avec la fonctionnalité User Profile Disks (UPD) activée. L’installation échoue au niveau du moteur de base de données…
SQL Server Database Engine
266 questions
asked 2025-07-03T15:26:50.9+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, 6%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECG%3C/text%3E%3C/svg%3E)
Charlie GOURDIEN
0
Reputation points
answered 2025-07-04T14:46:45.3466667+00:00
Erland Sommarskog
121.8K
Reputation points MVP
Volunteer Moderator
1 answer
Handling of very long strings
Hi! We are trying to include a (sometimes) very long string into our reports, rendered with SRSS. Due to the nomenclative background of it (ISCN), the string does not contain a lot of spaces, where breaks are able to occur. There are however places we…
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,063 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(86.4, 6%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
1 answer
Many SQL 823, 824 and 3041 errors since VM migrations
Our server team migrated our SQL Server VMs (VMware) from: HPE hosts using fibre channel through brocade fabric to our Pure FlashArray to: Cisco hosts connected directly to the same Pure FlashArray, but now using iSCSI. Ever since the VM…
SQL Server | Other
14,500 questions
asked 2022-05-31T16:57:01.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(99.2, 92%, 19%)' 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)
Mike Liening
6
Reputation points
edited a comment 2025-07-04T06:00:28.8+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, 12%, 19%)' 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)
Biswajit Sinha
0
Reputation points
3 answers
SQL upgrade from 2019 to 2022. Error 1639. Specified instance {My GUID} via transform: InstID02.mst;: InstName01.mst is already installed. MSINEWINSTANCE requires a new instance that is not installed.
Hi there, We had a tech attempt to upgrade SQL Server from 2019 Standard to SQL Server 2022 Standard. The upgrade initially failed with the following error: 1706. An installation package for the product Microsoft OLE DB Driver for SQL Server cannot…
SQL Server Database Engine
266 questions
asked 2025-06-30T13:29:58.4433333+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, 68%, 14%)' 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)
Chris Rutherford
5
Reputation points
commented 2025-07-03T20:00:10.3466667+00:00
Erland Sommarskog
121.8K
Reputation points MVP
Volunteer Moderator
1 answer
Joins vs Functions and Performance
It is axiomatic that joining to another table from your primary table to retrieve data, using primary keys, provides better performance than using a function. At least that's what I know from the last time I cared about it years ago. It's time to care…
SQL Server | SQL Server Transact-SQL
200 questions
asked 2025-07-03T19:12:57.03+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, 97%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDT%3C/text%3E%3C/svg%3E)
Don Thompson
0
Reputation points
answered 2025-07-03T19:48:52.9233333+00:00
Erland Sommarskog
121.8K
Reputation points MVP
Volunteer Moderator
2 answers
SQL Server 2025 Installation Error
Action required: Use the following information to resolve the error, and then try the setup process again. Feature failure reason: An error occurred for a dependency of the feature causing the setup process for the feature to fail. Error details: § Error…
SQL Server Database Engine
266 questions
asked 2025-06-10T14:07:02.23+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(118.4, 93%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUJ%3C/text%3E%3C/svg%3E)
Usman Jalil
0
Reputation points
commented 2025-07-03T19:37:47.4066667+00:00
Erland Sommarskog
121.8K
Reputation points MVP
Volunteer Moderator
1 answer
SkipErrors not working in peer-to-peer replication
I have a three node peer to peer replication and have configured the distribution agent with the profile continue on consistency errors -SkipErrors 2601:2627. I get Command attempted: if @@trancount > 0 rollback tran (Transaction sequence number:…
SQL Server | Other
14,500 questions
asked 2025-07-02T18:56:58.1766667+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, 99%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPE%3C/text%3E%3C/svg%3E)
Peter Ericsson
0
Reputation points
commented 2025-07-03T08:20:44.9833333+00:00
Peter Ericsson
0
Reputation points
1 answer
The requested OLE DB provider SQLNCLI11.1 is not registered
I'm getting the "The requested OLE DB provider SQLNCLI11.1 is not registered" on my new SQL Server 2022 installation when I try to run my tasks. The catch is that I updated all of my SSIS tasks to use the Microsoft OLE DB Driver 19 for SQL…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,703 questions
asked 2025-07-01T21:00:26.1033333+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, 33%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELP%3C/text%3E%3C/svg%3E)
Lee Polikoff
21
Reputation points
commented 2025-07-02T21:29:00.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(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' %3EGP%3C/text%3E%3C/svg%3E)
Gary Paquette
0
Reputation points
1 answer
SQL Server Data Import Error
I'm getting this error when trying to import an excel file into my server: TITLE: SQL Server Import and Export Wizard The operation could not be completed. ADDITIONAL INFORMATION: A network-related or instance-specific error has occurred while…
SQL Server Database Engine
266 questions
asked 2025-07-02T19:55:22.25+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, 22%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EER%3C/text%3E%3C/svg%3E)
Erik Rodriguez
0
Reputation points
answered 2025-07-02T21:25:14.44+00:00
Erland Sommarskog
121.8K
Reputation points MVP
Volunteer Moderator
3 answers
SQL Server 2022 Developer Edition failing install with error code -2068052310
I'm trying to install SQL Server 2022 Developer Edition and am getting an error stating that an installation package for the product Microsoft OLE DB Driver for SQL Server cannot be found and giving me the exit code -2068052310. I've downloaded and…
SQL Server | Other
14,500 questions
asked 2023-11-12T03:58:22.8866667+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, 11%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAV%3C/text%3E%3C/svg%3E)
Angel Van de Feniks
11
Reputation points
answered 2025-07-02T21:23:48.5233333+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(156.8, 54%, 25%)' 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)
Darren
1
Reputation point
2 answers
BACKUP LOG Write Fail to Azure Storage
Hello, We have a SQL VM running out of Azure with SQL Agent jobs running BACKUP LOG every x hours to Azure Blob. These jobs have been running fine for a long time until recently. We keep getting the below error and these jobs fail intermittently for…
SQL Server on Azure Virtual Machines
SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
412 questions
Azure Storage
Azure Storage
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
3,539 questions
Developer technologies | Transact-SQL
4,707 questions
SQL Server | Other
14,500 questions
asked 2022-06-13T18:07:29.267+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, 52%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESL%3C/text%3E%3C/svg%3E)
sidney l
21
Reputation points
answered 2025-07-02T21:20:53.65+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, 23%, 32%)' 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)
Andy Soushek
0
Reputation points
2 answers
Finding old SQL Server licenses we own
Hello, We purchased Microsoft SQL Server many years ago. This sever was decommissioned, but the license was never removed. We would like to reinstall the license on a new server, but have no record of this license number. How can we go about finding…
SQL Server | Other
14,500 questions
asked 2025-07-01T16:26:08.7866667+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, 84%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKW%3C/text%3E%3C/svg%3E)
Ken Wanek
0
Reputation points
commented 2025-07-02T21:12:35.49+00:00
Erland Sommarskog
121.8K
Reputation points MVP
Volunteer Moderator
1 answer
One of the answers was accepted by the question author.
Unable to install SQL Server. Exit code (Decimal): -2061893607
I get a very kindly worded error message when attempting to install SQL Server 2022, Express Edition. It states, "Unable to install SQL Server (setup.exe). Exit code (Decimal): -2061893607 Error description: Could not find the Database Engine…
SQL Server | Other
14,500 questions
asked 2025-07-02T02:04: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(28.799999999999997, 61%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Mike Banes
20
Reputation points
accepted 2025-07-02T16:03:45.9566667+00:00
Mike Banes
20
Reputation points
0 answers
How can I implement impersonation on SSRS without prompting the normal user.
How can I implement impersonation (i.e. domain/user) across a domain for all users to use without prompting for user name and password SSRS. I have been trying to modify the configuration files without success. Besides the security risks please can…
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,063 questions
asked 2025-07-02T13:42:15.1733333+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, 13%, 14%)' 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)
Mark Askins
0
Reputation points
asked 2025-07-02T13:42:15.1733333+00:00
Mark Askins
0
Reputation points
1 answer
Error in installing Sql Server Express 2022
Use the following information to resolve the error, and then try the setup process again. Feature failure reason: An error occurred during the setup process of the feature. Error details: § Error installing SQL Server Database Engine Services Instance…
SQL Server Database Engine
266 questions
asked 2025-07-02T01:42:16.9366667+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, 89%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
vinod singh
0
Reputation points
answered 2025-07-02T07:55:05.5966667+00:00
Erland Sommarskog
121.8K
Reputation points MVP
Volunteer Moderator
1 answer
Sql server history is not updating
Hi Team,I one of my sql server, jobs are not showing last run outcome and last run details.we have only 4 jobs in this server.These jobs are weekly maintenance plans only.if i start one job and stop it immediately also,its not showing stopped.Sql server…
SQL Server Database Engine
266 questions
asked 2025-07-01T08:50:03.27+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(252.8, 84%, 34%)' 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)
ACDBA
421
Reputation points
commented 2025-07-02T07:38:04.58+00:00
Erland Sommarskog
121.8K
Reputation points MVP
Volunteer Moderator
0 answers
How to identify MS SQL Server enterprise core software installation
Discovery solution uses patterns that execute- WMI commands on SQL Server to identify the installed edition. Recently, we've observed that in some instances, the discovered edition is returned as "Enterprise Edition: Core-based Licensing." As…
SQL Server Database Engine
266 questions
asked 2025-07-01T11:37:00.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(268.8, 50%, 36%)' 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)
Srinivas Ramanujaiah
0
Reputation points
commented 2025-07-02T06:20:46.93+00:00
Srinivas Ramanujaiah
0
Reputation points