19,620 questions with SQL Server-related tags

Sort by: Updated
2 answers

AlwaysON issue v2

Hello! There are two newly installed SQL Server 2022 Standard servers installed from the same ISO(say SQL1 and SQL2), OS = WinServer 2022 Standard (for both servers, same ISO), both added to the domain with the single domain controller named DC1. Here's…

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,147 questions
asked 2024-12-06T14:46:03.6333333+00:00
Hram Admin 40 Reputation points
answered 2024-12-06T17:38:08.36+00:00
Hram Admin 40 Reputation points
3 answers

Azure Resource Graph Explorer - Retrieving DTU Percentage

I am trying to use Azure Resource Graph Explorer to obtain a list of databases along with their DTU percentage. However, my query returns NULL for the DTU_percentage column. Is it possible to retrieve this information? Thanks in advance

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,147 questions
asked 2024-12-02T14:51:25.14+00:00
Suthii09 0 Reputation points
commented 2024-12-06T16:12:33.18+00:00
Vijayalaxmi Kattimani 495 Reputation points Microsoft Vendor
2 answers

SQL backup failing every night

Hello All, SQL backup is failing every night with different error. As i am new to DPM, Unfortunatelly i could not understand why it is failing. Could someone help me, how to fix it ? Error: The replica of SQL Server 2017 database…

Azure Backup
Azure Backup
An Azure backup service that provides built-in management at scale.
1,302 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,147 questions
asked 2024-12-06T13:19:05.5866667+00:00
Rajeswaran Sundarsingh 20 Reputation points
edited an answer 2024-12-06T15:35:14.0933333+00:00
Amardeep Saini 1,335 Reputation points Microsoft Employee
0 answers

AlwaysON issue

Hello! There are two newly installed SQL Server 2022 Standard Edition servers (say SQL1 and SQL2), both installed from the same iso, with the OS also installed from the same ISO (Windows Server 2022 Standard), both are member of the domain with the…

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,147 questions
asked 2024-12-06T14:33:31.1433333+00:00
Hram Admin 40 Reputation points
2 answers

Transparent Data Encryption (TDE) on AlwaysON Availability Group

I’ve been tasked with securing SQL Server data and log files (MDF and LDF) using Transparent Data Encryption (TDE) across all SQL Servers in our environment, which consists of over 85 instances. This is a significant undertaking, and I’m concerned about…

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,147 questions
Windows Server Security
Windows Server Security
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Security: The precautions taken to guard against crime, attack, sabotage, espionage, or another threat.
1,865 questions
asked 2024-12-05T16:58:35.36+00:00
Augie 0 Reputation points
commented 2024-12-06T09:26:01.49+00:00
Erland Sommarskog 113.5K Reputation points MVP
1 answer One of the answers was accepted by the question author.

Stack Dump on SQL Server

Hi expert, Stack dump has been generated as attached when failover AOG enforcement occurred... any suggestion to getting solution with this information? great appreciation for all reply regards, UrBel SQLDump0052.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,147 questions
asked 2024-12-06T06:43:35.7133333+00:00
UrBel 200 Reputation points
commented 2024-12-06T08:52:18.27+00:00
UrBel 200 Reputation points
1 answer One of the answers was accepted by the question author.

Unable to install SQL server

Detail.txt Summary.txt I couldnt make out the log file, Could you help me figure out what i should do to install this server, I will try to install a 2019 server and try again, but any help is appriciated, Thanks

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,147 questions
asked 2024-12-06T03:46:46.39+00:00
Vibin 0 Reputation points
accepted 2024-12-06T08:08:24.08+00:00
Vibin 0 Reputation points
1 answer

How can I update the data source (Azure Storage) for Azure Analysis Services without using the SQLServer module or the Invoke-ASCmd method, preferably using Python?

I am looking for a way to achieve this using Python. Please suggest any tools, libraries, or approaches that can facilitate this, such as using REST APIs or handling XMLA directly. A step-by-step explanation or references would be greatly appreciated.

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
463 questions
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,262 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,989 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,297 questions
asked 2024-12-03T10:34:09.55+00:00
T, Charandeep 0 Reputation points
answered 2024-12-06T07:27:52.5133333+00:00
T, Charandeep 0 Reputation points
3 answers One of the answers was accepted by the question author.

Reading SQL Transaction log

Hi Expert, I've added new *LDF file, but I would like old *LDF can't be used anymore\inactive, so all transaction will be recorded into new *LDF i've just created... then, how to know transaction recorded into new *LDF? thanks for all respond great…

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,147 questions
asked 2024-12-03T03:55:35.7+00:00
UrBel 200 Reputation points
answered 2024-12-06T06:36:40.17+00:00
UrBel 200 Reputation points
2 answers

Unable to restore database in ssms

Getting below error while i am trying to restore a database in SSMS. TITLE: Microsoft SQL Server Management Studio An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ADDITIONAL…

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,147 questions
asked 2024-12-05T10:23:45.48+00:00
Ahuja, Muskan 0 Reputation points
answered 2024-12-06T06:35:00.69+00:00
ZoeHui-MSFT 38,621 Reputation points
3 answers

i am getting this error

please give me some solution for SqlConnection, SqlCommand and Clear ()

Windows Forms
Windows Forms
A set of .NET Framework managed libraries for developing graphical user interfaces.
1,908 questions
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,977 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,147 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,753 questions
asked 2024-11-30T11:08:29.9066667+00:00
sayali dhanawade 20 Reputation points
edited the question 2024-12-06T06:28:48.6433333+00:00
Zhi Lv - MSFT 32,561 Reputation points Microsoft Vendor
1 answer

Application getting logout frequently - ASP.NET session has expired or could not be found - Microsoft.ReportViewer.WebForms

Dear all, we are getting below error frequently from few days without any deployment on production environment, unable to find the solution. even after increasing session time out and tried various suggestions on internet still facing the same issue.…

Internet Information Services
ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
3,538 questions
Windows Server 2012
Windows Server 2012
A Microsoft server operating system that supports enterprise-level management, data storage, applications, and communications.
1,606 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,950 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,106 questions
asked 2024-12-05T08:06:48.54+00:00
Rupesh Musale (Ext) 0 Reputation points
commented 2024-12-06T03:14:57.8166667+00:00
XuDong Peng-MSFT 10,836 Reputation points Microsoft Vendor
1 answer

Migrating Publication database in Transaction Replication to another server

Hi. We need to migrate Publication database (SQL 2017) in Transaction Replication from old server (windows 2016) to new server (windows 2019). Please let me know if below approach works. Setup log shopping to migrate Publisher database from old 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,147 questions
asked 2024-12-05T07:54:02.4066667+00:00
Sowjanya Gopal 20 Reputation points
answered 2024-12-06T02:45:59.84+00:00
Greg Low 1,850 Reputation points Microsoft Regional Director
1 answer

Finding the Next Appointment Record

Hello everyone and thanks for the help in advance. I need to develop a report for a physician's office that tracks how many patients made follow up appointments after a first appointment. In other words, lets say a patient had an appointment today and…

ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,672 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,147 questions
asked 2024-12-05T22:40:19.31+00:00
Kmcnet 806 Reputation points
answered 2024-12-06T02:38:11.3233333+00:00
Greg Low 1,850 Reputation points Microsoft Regional Director
1 answer

Not able to connect to a database in SSMS 19.1

TITLE: Connect to Server Cannot connect to WTIN05700927L. ADDITIONAL INFORMATION: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the…

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,147 questions
asked 2024-12-05T12:02:06.4333333+00:00
Bharathiraaja Chandrasekaran 0 Reputation points
edited a comment 2024-12-06T01:59:55.01+00:00
LiHongMSFT-4306 29,111 Reputation points
3 answers

Is there a roadmap for Analysis Services Linked Servers in Azure SQL Managed Instance?

My clients rely heavily on being able to query an Analysis Services Linked Server in SQL Server Enterprise. I'm aware this is not currently possible in SQL MI, which means I can't consider migrating any clients there. I'm not looking for alternative…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
463 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,147 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,297 questions
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
463 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,147 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,297 questions
asked 2024-10-22T04:36:30.9633333+00:00
Jamie 0 Reputation points
commented 2024-12-06T01:56:29.8933333+00:00
Jamie 0 Reputation points
3 answers

Is there a roadmap for Analysis Services Linked Servers in Azure SQL Managed Instance?

My clients rely heavily on being able to query an Analysis Services Linked Server in SQL Server Enterprise. I'm aware this is not currently possible in SQL MI, which means I can't consider migrating any clients there. I'm not looking for alternative…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
463 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,147 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,297 questions
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
463 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,147 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,297 questions
asked 2024-10-22T04:36:30.9633333+00:00
Jamie 0 Reputation points
commented 2024-12-06T01:56:29.8933333+00:00
Jamie 0 Reputation points
1 answer

Database schema change of result in query sql server

How we can get database schema change result in query sql server? Is there any tool ? Suppose we do any change in schema. I want the result of that change in query.

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,147 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,665 questions
asked 2023-11-16T22:31:07.1766667+00:00
Kanav Sharma 25 Reputation points
commented 2024-12-05T22:05:46.39+00:00
Erland Sommarskog 113.5K Reputation points MVP
1 answer

How to fix an error System.TypeLoadException: in an swagger api project ?

System.TypeLoadException: Method 'get_LockReleaseBehavior' in type 'MySql.EntityFrameworkCore.Migrations.Internal.MySQLHistoryRepository' from assembly 'MySql.EntityFrameworkCore, Version=0.0.0.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' does…

Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
763 questions
ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,672 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,147 questions
asked 2024-10-11T08:15:59.3133333+00:00
Mathis De Sousa 0 Reputation points
commented 2024-12-05T20:42:51.56+00:00
Paul Ralph Daudi 0 Reputation points
1 answer

Customized ODBC permission registry setting lost

Hi engineer, We find that this “Authenticated Users” setting in the ODBC.INI permission is lost We upgraded those PC OS to Windows 10 Prof 22H2 a few months ago. Do you know if OS upgrade to Windows 10 Prof 22H2 will reset ODBC this registry settings?

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
864 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,147 questions
asked 2024-12-02T09:30:06.26+00:00
Victor Cheung 0 Reputation points
commented 2024-12-05T17:05:13.77+00:00
Mahesh Kurva 1,070 Reputation points Microsoft Vendor