18,162 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
2 answers

SQL backups are getting failed with below error

Error encountered while trying to open backup device. Error: [Microsoft.SqlServer.Management.Common.ExecutionFailureException:Cannot open backup device '8122c6ff-b1c3-4550-a77b-c79a3066c737'. Operating system error 0x80770006(failed to retrieve text for…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,914 questions
asked 2024-05-14T05:12:06.68+00:00
Manjunatha Reddy 0 Reputation points
answered 2024-05-28T23:10:56.9433333+00:00
Ben Miller-(DBADuck) 0 Reputation points MVP
3 answers

Removing database from AG

I have an AG. On secondary replica, if we remove database from AG, what will be the database status on primary replica

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,914 questions
asked 2024-05-26T09:31:01.73+00:00
Chaitanya Kiran 716 Reputation points
answered 2024-05-28T23:02:20.7233333+00:00
Ben Miller-(DBADuck) 0 Reputation points MVP
4 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.
12,914 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,309 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.
637 questions
asked 2024-02-20T16:28:13.2166667+00:00
Doug V 0 Reputation points
answered 2024-05-28T22:48:50.4766667+00:00
Ben Miller-(DBADuck) 0 Reputation points MVP
2 answers

Windows 11 Microsoft SQL 2022 Express Edition

Hey, currently in work we have PC with Windows 11 Pro license which is used as small "server". Here we have installed MS SQL servers. We want to add new software database into MS SQL 2022 Express Edition but software creator said we need…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,914 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
8,455 questions
asked 2024-05-27T12:19:53.0033333+00:00
Richard Uhrin 0 Reputation points
commented 2024-05-28T22:45:39.3466667+00:00
Ben Miller-(DBADuck) 0 Reputation points MVP
3 answers

How to check root cause of "Agent message code 20084. The process could not connect to Distributor" on a Pull subscription(SQL MI) and Publisher/Distributor (ON Prem SQL Server)

How to check root cause of "Agent message code 20084. The process could not connect to Distributor" on a Pull subscription(SQL MI) and Publisher/Distributor (ON Prem SQL Server) The firewall and network settings looks fine. However we are…

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.
12,914 questions
asked 2024-05-21T13:10:34.7166667+00:00
Nitya V 40 Reputation points
answered 2024-05-28T22:41:38.1933333+00:00
Oury Ba-MSFT 16,891 Reputation points Microsoft Employee
2 answers

Problems with AlwaysOn, HADR_LOGPROGRESS_SYNC waits and missing log block

Hi Folks! Need help from you ! We have some issues with AlwaysOn synchronisation on high load system and we can it repeat on PROD and LT environmets(not depend from hardware). Configuration: SQL Seerver 2019 EE CU24 Prod- 4 nodes (2 synchronous mode…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,914 questions
asked 2024-05-23T13:55:55.1133333+00:00
Viacheslav Nikonorov 0 Reputation points
answered 2024-05-28T22:30:10.3033333+00:00
Ben Miller-(DBADuck) 0 Reputation points MVP
2 answers

Sql server Metrics : is 100% CPU percentage is a blocker for all DB operations?

HI All We have observed a case in our database where the CPU perncetage is 100% for quite some time but my application are still able to hit & operate over DB, is 100% CPU usage isnt a blocker for DB operations ?? I see 2 CPU metrics 1) CPU…

Azure SQL Database
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,294 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.
12,914 questions
asked 2024-05-27T01:27:28.3866667+00:00
Manoj Mathe 0 Reputation points Microsoft Employee
answered 2024-05-28T22:26:55.4933333+00:00
Oury Ba-MSFT 16,891 Reputation points Microsoft Employee
1 answer

Debugging SQL Server on Linux from remote VS 2022 pc

Is it possible to debug an SQL-Server on an Ubuntu 22 machine from Visual Studio 2022? I can reach the server an can execute queries from within VS2022. But debugging fails with no useful message (error 80004005). Firewall on the server pc is inactive.…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,914 questions
Visual Studio Debugging
Visual Studio Debugging
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Debugging: The act or process of detecting, locating, and correcting logical or syntactical errors in a program or malfunctions in hardware. In hardware contexts, the term troubleshoot is the term more frequently used, especially if the problem is major.
953 questions
asked 2024-05-28T18:57:39.8333333+00:00
Torsten Kiltz 0 Reputation points
answered 2024-05-28T21:19:13.94+00:00
Erland Sommarskog 102.4K Reputation points
3 answers

SQL Server integration service installed with SQL Server management studio

Hi Can you please let us know if SQL Server integration service (or SSIS) which is a licensable product installed with SQL Server management studio (SSMS) (a non licensable product)? We have got instances of our DBAs mentioning that they can see…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,914 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,469 questions
asked 2024-05-27T06:59:06.6266667+00:00
Srinivas Ramanujaiah 0 Reputation points
commented 2024-05-28T21:15:36.9466667+00:00
Erland Sommarskog 102.4K Reputation points
1 answer

My listview is listing only the id instead of 3 items on the table

PLEASE HELP ME I am working on sqlite database , i have the following code in c# maui return (await conn.Table<ServiceData>().ToListAsync()) ```.Where(s…

Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
704 questions
.NET MAUI
.NET MAUI
A Microsoft open-source framework for building native device applications spanning mobile, tablet, and desktop.
2,989 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.
10,401 questions
SQL Server Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
4 questions
asked 2024-05-28T15:40:05.35+00:00
Gbenga Banuso Odumosu 40 Reputation points
answered 2024-05-28T20:33:37.04+00:00
hossein jalilian 4,285 Reputation points
0 answers

Managed Instance - Weekly report of logins

What's the best way to get a weekly report from an Azure Managed Instance giving all logon information (User, date, IP, success, etc)? I want all SQL logins and Entra ID logins. I've followed the steps detailed here:…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,914 questions
asked 2024-05-28T19:29:46.55+00:00
HSB 25 Reputation points
0 answers

Path to Microsoft ODBC SSL Driver loaded libraries

How do configure dynamic loading of OpenSSL libraries for use MS ODBC? The Microsoft ODBC Driver for SQL Server on Linux version 17 dynamically loads the latest version of libssl based on its availability on the system. Our software is linked custom…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,469 questions
asked 2024-05-28T17:09:47.63+00:00
Denis Kupavtsev 0 Reputation points
2 answers

"An operation that uses the database driver could not be completed. If the driver is a Microsoft driver, make sure the driver file isn't damaged, and if it is, reinstall the driver by reinstalling Microsoft Query."

One of the users receive this error. is this issue at our end or at microsofts ?

Azure SQL Database
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
439 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,547 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,249 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,661 questions
asked 2023-10-25T20:03:28.8633333+00:00
zubaid ahmed 0 Reputation points
answered 2024-05-28T13:30:39.0233333+00:00
Gabriel Roldan 25 Reputation points
1 answer One of the answers was accepted by the question author.

Reporting Services logs and database tables

hi all, Do the RS logs and various log database tables contain the same information? I have no access to the admin page for the production environment RS, however I am responsible for fixing issues with reports being scheduled in that…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,914 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.
2,827 questions
asked 2024-05-27T12:41:11.9033333+00:00
elsvieta 346 Reputation points
commented 2024-05-28T12:49:28.1033333+00:00
elsvieta 346 Reputation points
2 answers

The MSSQLSERVER and AGENT service terminated unexpectedly

Dear All SQL expert, Do you know what is the case that make The MSSQLSERVER service terminated unexpectedly? Recently, The SQL server (MSSQLSERVER) and SQL Server Agent are stopped automatically during running import data to sql server through scheduled…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,914 questions
Windows Server 2012
Windows Server 2012
A Microsoft server operating system that supports enterprise-level management, data storage, applications, and communications.
1,544 questions
asked 2024-05-27T20:33:02.6366667+00:00
Yohany Sanchez 0 Reputation points
commented 2024-05-28T12:12:11.3066667+00:00
Yohany Sanchez 0 Reputation points
4 answers

How to connect my c# application to my phpmyadmin database from my NAS?

Good day, I want to try to connect to my database in my NAS. Please take a look the image below. As you can see at the image, I want to access my database outside in my home network. I already installed phpmyadmin in my NAS, but the problem is I don't…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,914 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.
10,401 questions
asked 2024-05-26T11:07:34.2566667+00:00
BgnerNprg207 226 Reputation points
answered 2024-05-28T11:24:12.5333333+00:00
BgnerNprg207 226 Reputation points
2 answers

SSRS Report Subscription Windows Share File Option Failed

We have configured SSRS Report Subscription export report automatically and place the file in shared path location, we did all the configurations but getting error like "Failure writing file acctbalrw : The permissions granted to user '' are…

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,827 questions
asked 2024-05-24T14:47:14.9633333+00:00
Vinaya Velli 0 Reputation points
commented 2024-05-28T10:17:12.3+00:00
Vinaya Velli 0 Reputation points
1 answer

How to install SQL Server 2022 on Ubuntu Server 24.04 LTS

I couldn't find a proper way to install the SQL Server 2022 on Ubuntu Server 24.04 LTS, I tryed to use the microsoft SQL Server 2022 from Ubuntu 22.04 repo, but couldn't get the service running properly. I ended with this service status (see print). Is…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,914 questions
asked 2024-05-24T00:46:20.3866667+00:00
Michael F. Assis 5 Reputation points
commented 2024-05-28T10:01:30.78+00:00
MikeyQiao-MSFT 655 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

Dataset format needed for azure blob storage

How do I select what format is right for me while moving documents from SQL Server to Azure blob storage using Azure Data Factory pipeline? The existing documents in the Blob storage show the type as Block Blob, but it doesn't show the format. I need to…

Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,493 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.
12,914 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,773 questions
asked 2024-05-24T13:53:47.7833333+00:00
Reema DSouza 0 Reputation points
accepted 2024-05-28T09:55:59.89+00:00
Reema DSouza 0 Reputation points
3 answers One of the answers was accepted by the question author.

Polybase s3 not working on SQL Server 2022 Linux

Trying to connect to parquet files on S3 from SQL server 2022 Linux fails with the following error: CREATE EXTERNAL DATA SOURCE myds WITH ( LOCATION = 's3://mybucket' , CREDENTIAL = mycreds ); GO 111631;The specified…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,914 questions
asked 2022-06-06T18:53:24.237+00:00
Daniel Hartl 21 Reputation points
commented 2024-05-28T09:46:29.1333333+00:00
Maxpia 1 Reputation point