SQL Express 2019 Install Failure SQLEngineConfigAction_Install_Confignonrc_CPU64
I have been fighting an SQL Express 2019 Install on Windows 11 home for a few days. It all of a sudden stopped working and now I cannot get it to reload. I am not sure if Microsoft pushed out an update but I have 2 computers with the exact same issue…
SQL Server Management Studio 18 remember password not working?
With one of the latest updates of SSMS 18 (I'm now on 18.6), the remember password feature does not seem to work anymore. Am I missing something? Cheers, Galletto
Cannot add drive using Failover Cluster Manager - no disks suitable for cluster disks were found
I am creating a new SQL cluster to replace out old cluster. I created a new, two server cluster running Server 2022. I am told I need to add the disk to the cluster before I can install our SQL server software. I created a new volume in our PowerStore.…
Understand the backup and restore of Azure SQL Managed instances Logins
Hi Team, I want to do backup and restoration of SQL managed instances, Is there any way to migrates SQL logins and jobs too? Thanks Krupa G
Why MSDN deprecates the AddWithValue method
I am trying to connect to a SQL Server table and update or register data in a program created in C#. In order to create a program that can take measures against SQL injection and support N prefixes, I am thinking of using the AddWithValue method, a…
Region-specific drives for a VM located in Azure AU region
Hi Team, We have a requirement from clients to have the data in the respective data drives, for example - client from US wants to have their data in a drive which is physically located in the azure data centre in US region. We are looking at partitioning…
SSRS - Exporting report with 2 tables to CSV Issue
Hello, Historically we have been exporting 2 tables seperated by one blank row in an SSRS report to CSV format. However recently this month the format has changed and not displaying correctly. The version of SSRS being used is 15.0.7243.37714. …
Error when connecting to Sql Server using Microsoft Sql Server Management Studio
Hi, Team I got an error when connecting to Sql Server using Microsoft Sql Server Management Studio. There was no problem before. Can you help me find out the reason? The following is the detailed error information TITLE: Connect to Server Cannot…
SSAS Development How to fix "Cannot open BIM Model. Localhost server unreachable" ?
Hello everyone ! I've had a weird problem during the last couple of days. I downloaded a SSAS project from Azure to work on it with some people. I set it up to use "Integrated workspace", and I left everything else as default. The first time I…
How to migrate Dedicated SQL Pool database from cloud to onprem SQL Server 2019
Hi, i have a 128 gb Dedicated SQL Pool in Azure and want to create a copy of the database (or the data) to an on-prem SQL Server 2019, what tools are available to achieve this?
Metric Storage space used
I see this value in the attached screenshot and would like to clarify its meaning. Additionally, I need to determine how much free storage space is available in my SQL Managed Instance. Ideally, I should see a clear breakdown, such as "10 GB…
How to fix Error installing SQL Server Database Engine Services Instance Features Invalid command line argument. Consult the Windows Installer SDK for detailed command line help.
I tried installing MS SQL Server it throws up an error every time. I used installation center error.png Please help me to install MS SQL ServerSummary_Yaswanth_20250206_140424.txt
Will Always On remain uninterrupted while upgrading SQL Server 2019 to SQL Server 2022?
I have two servers running SQL Server 2019 in a primary-secondary Always On configuration, and I want to upgrade them to SQL Server 2022. If I upgrade them separately, will Always On remain uninterrupted? My plan is to first upgrade the secondary server…
SQL Server
Beim Installieren von SQL 2019 auf einem Server mit Server 2019 Standard kommt der Fehler : Fehlercode 50000
Sortable MVC Tables with Stored Procedure
Hello everyone and thanks for the help in advance. I am developing a MVC application that requires a sortable table. The issue is that the tables utilize queries that are best suited for stored procedures. While researching, I cam across older…
How granting the execute permission for several stored procedures - SQL Server 2019
Hi, in order to review some security aspects about a SQL Server 2019 instance I need to assign the execute permission for several stored procedures to a db_datareader and db_datawriter user without operating one by one. How could I accomplish a such…
Automate End of Month Redgate SQL Backup Copies in Azure Storage
The requirement is to automate the copying of End of Month backups for select critical databases from their main Azure storage container to a separate audit container within the same storage account. Currently, each server writes full, differential, and…
VS - How to fix "Could not load file or assembly 'Newtonsoft.Json, Version=13.0.0.0"
Hi, I have created a new SSIS project in Visual Studio, and there is a Script Task built in the SSIS package. This Script Task is used get a bearer token from an API website, this C# script run successfully in C# Console. When I run the Script Task…
Does Microsoft offer professional administrator sql server training with labs for a database administrator?
How can I find sql server administration training with labs for new DBA taught on SqlServer 2019 or later.
Upgrading SQL 2019 to SQL 2022
Hello, We are planning to upgrade SQL 2019 to SQL 2022. As with SQL 2022, we can add master & msdb databases to the SQL Alwayson Availability group, so that local SQL logins along with AD logins and SQL jobs can be synced between the primary and…