19,972 questions with SQL Server-related tags

Sort by: Updated
1 answer

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,432 questions
asked 2025-02-06T21:36:33.11+00:00
Justin Statham 56 Reputation points
edited a comment 2025-02-07T15:23:25.2833333+00:00
Justin Statham 56 Reputation points
11 answers

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,432 questions
asked 2020-09-22T14:20:52.377+00:00
galletto 231 Reputation points
commented 2025-02-07T14:20:45.08+00:00
IAN GREEN-MORRIS 0 Reputation points
5 answers

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.…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,432 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
13,659 questions
Windows Server Storage
Windows Server Storage
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Storage: The hardware and software system used to retain data for subsequent retrieval.
667 questions
asked 2024-02-20T16:28:13.2166667+00:00
Doug V 20 Reputation points
answered 2025-02-07T13:28:26.2966667+00:00
Reeser, Ron - HPW 0 Reputation points
1 answer One of the answers was accepted by the question author.

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,432 questions
asked 2025-02-04T07:47:52.68+00:00
krupa gundraju 20 Reputation points
accepted 2025-02-07T13:07:09.6866667+00:00
krupa gundraju 20 Reputation points
0 answers

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…

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,405 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,432 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
11,277 questions
asked 2025-02-07T08:02:47.0133333+00:00
那由多 0 Reputation points
commented 2025-02-07T09:56:36.7833333+00:00
simo-k 2,240 Reputation points
0 answers

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…

Azure Files
Azure Files
An Azure service that offers file shares in the cloud.
1,354 questions
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
8,326 questions
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
3,063 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,432 questions
asked 2025-02-06T23:25:40.6466667+00:00
Berchmans Marcelline 0 Reputation points
commented 2025-02-07T09:53:13.8833333+00:00
Berchmans Marcelline 0 Reputation points
2 answers

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. …

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.
2,988 questions
asked 2022-04-25T11:19:06.127+00:00
Sarah Chapman 1 Reputation point
commented 2025-02-07T09:49:50.3966667+00:00
Mestri, Rajkumar 0 Reputation points
0 answers

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…

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,432 questions
asked 2025-02-07T07:56:36.96+00:00
Allen F MAO 0 Reputation points
commented 2025-02-07T09:49:16.7166667+00:00
Mahesh Kurva 2,670 Reputation points Microsoft Vendor
1 answer

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…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
472 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,310 questions
asked 2025-02-04T10:14:50.5333333+00:00
D2d3d4d5 20 Reputation points
commented 2025-02-07T09:36:01.33+00:00
Smaran Thoomu 19,875 Reputation points Microsoft Vendor
2 answers

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?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,173 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,432 questions
asked 2025-02-07T02:48:54.7433333+00:00
Milly 0 Reputation points
edited the question 2025-02-07T09:15:42.0333333+00:00
Vijayalaxmi Kattimani 1,085 Reputation points Microsoft Vendor
1 answer

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…

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,432 questions
asked 2025-02-06T20:27:19.7933333+00:00
GP 16 Reputation points
edited an answer 2025-02-07T03:10:12.8966667+00:00
Sai Raghunadh M 2,315 Reputation points Microsoft Vendor
2 answers

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,432 questions
asked 2025-02-06T19:17:24.5233333+00:00
Yaswanth Reddy Soma 0 Reputation points
answered 2025-02-07T02:13:45.2166667+00:00
ZoeHui-MSFT 40,356 Reputation points
2 answers

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,432 questions
asked 2025-02-06T09:14:08.6433333+00:00
ramazan göksoy 0 Reputation points
answered 2025-02-07T01:50:18.5233333+00:00
ZoeHui-MSFT 40,356 Reputation points
0 answers

SQL Server

Beim Installieren von SQL 2019 auf einem Server mit Server 2019 Standard kommt der Fehler : Fehlercode 50000

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,432 questions
asked 2025-02-06T10:24:55.8233333+00:00
Eduard Malkmus 0 Reputation points
commented 2025-02-07T01:32:55.9466667+00:00
LiHongMSFT-4306 30,586 Reputation points
3 answers

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…

ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,772 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,432 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,689 questions
asked 2025-02-06T18:27:54.7366667+00:00
Kmcnet 946 Reputation points
answered 2025-02-07T00:18:33.88+00:00
SurferOnWww 3,816 Reputation points
3 answers One of the answers was accepted by the question author.

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,432 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,689 questions
asked 2025-02-03T08:18:41.0633333+00:00
pmscorca 1,007 Reputation points
edited a comment 2025-02-06T21:51:17.2166667+00:00
Erland Sommarskog 116.5K Reputation points MVP
0 answers

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,432 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
13,659 questions
asked 2025-02-03T10:21:30.6166667+00:00
Abimbola Adeniran 66 Reputation points
edited a comment 2025-02-06T21:25:08.8733333+00:00
Abimbola Adeniran 66 Reputation points
2 answers

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…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,641 questions
asked 2025-01-31T11:58:33.4366667+00:00
Jocelyn Kwong 0 Reputation points
commented 2025-02-06T17:09:14.7066667+00:00
Jocelyn Kwong 0 Reputation points
2 answers

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.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,432 questions
asked 2024-07-12T15:57:37.2466667+00:00
Lewis, Frances 0 Reputation points
edited the question 2025-02-06T13:53:10.4366667+00:00
Rakesh Gurram 11,735 Reputation points Microsoft Vendor
2 answers

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,432 questions
asked 2023-08-19T16:58:21.4933333+00:00
SQLDev 96 Reputation points
commented 2025-02-06T09:09:44.4166667+00:00
ramazan göksoy 0 Reputation points