17,412 questions with SQL Server-related tags

Sort by: Updated
0 answers

How do I get the VSS SQL writer to rebuild needed configuration?

Hello Q & A We have a rather odd situation on our hands. A server 2016 machine was setup years ago to run our Active Directory Sync Service. Back then, the server was a regular machine without a specific role, and the ADSync Service was setup running…

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,288 questions
Windows Server Backup
Windows Server Backup
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Backup: A duplicate copy of a program, a disk, or data, made either for archiving purposes or for safeguarding valuable files from loss should the active copy be damaged or destroyed.
439 questions
asked 2024-02-27T08:10:16.6066667+00:00
Alexander Lindberg 1 Reputation point
2 answers One of the answers was accepted by the question author.

Replicating an on-premises VM with SQL Server Always On to an Azure VM

I am looking for a detailed explanation on how to replicate a single VM from on-premises to Azure using SQL Server Always On Availability Groups. Specifically, I have an on-premises VM with SQL Server 2022 that I need to replicate to an Azure VM with SQL…

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,288 questions
asked 2024-02-26T17:31:35.4866667+00:00
ares 201 Reputation points
accepted 2024-02-27T08:10:06.2633333+00:00
ares 201 Reputation points
3 answers

CLUSTER SERVICE NOT STARTING AND CLUSTER REGISTRY MISSING

After upgrading my SQL Server OS from 2016 to 2019, my failover clustering feature is not working, the cluster service has stopped and is disabled, even after trying to bring it back up, it is giving the error " Couldn't find file…

Windows Server 2019
Windows Server 2019
A Microsoft server operating system that supports enterprise-level management updated to data storage.
3,335 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,288 questions
Windows Server Clustering
Windows Server Clustering
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Clustering: The grouping of multiple servers in a way that allows them to appear to be a single unit to client computers on a network. Clustering is a means of increasing network capacity, providing live backup in case one of the servers fails, and improving data security.
941 questions
asked 2024-02-25T13:44:53.7566667+00:00
klean Sap 0 Reputation points
answered 2024-02-27T07:19:39.38+00:00
Ian Xue (Shanghai Wicresoft Co., Ltd.) 27,831 Reputation points Microsoft Vendor
2 answers

Unable to delete maintenance plan in SQL Server Management Studio

Hi I'm unable to delete one of my maintenance plan in SQL Server Management Studio, this above error pop-up. I attempted to delete the maintenance plan but encountered an error. I also faced an error when trying to stop the job. Here are the details…

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,288 questions
asked 2024-02-26T08:51:19.3233333+00:00
Luqman Razak 0 Reputation points
commented 2024-02-27T03:06:31.1766667+00:00
CosmogHong-MSFT 20,371 Reputation points Microsoft Vendor
0 answers

Azure Analysis Server becomes unresponsive if tables are getting processed

We have multiple Power BI reports hosted on a server(S9V2) which has multiple databases. We have been noticing that whenever entities are getting processed, the reports are becoming very slow and even the processing of entities take more time than…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
428 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,234 questions
asked 2024-02-26T17:23:14.1466667+00:00
Sachin Kumar 1 Reputation point Microsoft Employee
commented 2024-02-27T00:03:29.6266667+00:00
SatishBoddu-MSFT 19,836 Reputation points
1 answer

Active X Error

We have a Web application that can generate Excel file. We trigger creating the Excel in the front-end and the services will take care of the Excel creation in the background. Sometimes, we encountered error related to Active X. And sometimes, we…

.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,177 questions
ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
3,180 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,288 questions
asked 2024-02-26T01:40:02.1+00:00
Louie 21 Reputation points
answered 2024-02-26T23:13:21.6833333+00:00
Bruce (SqlWork.com) 52,586 Reputation points
4 answers

Displaying Files of Unknown Types Stored in SQL Server Using C# WPF

I am developing a C# WPF application using .NET 6 in Visual Studio 2022, with a SQL Server 2008 R2 database. My database contains a table GRADE_CUST_GRP with a column GCPS of type image, where files of various types are stored without any file extension…

Windows Presentation Foundation
Windows Presentation Foundation
A part of the .NET Framework that provides a unified programming model for building line-of-business desktop applications on Windows.
2,633 questions
ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,018 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,288 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.
9,961 questions
asked 2024-02-25T12:17:45.5366667+00:00
Mojtaba_Hakim 281 Reputation points
answered 2024-02-26T22:59:45.59+00:00
Bruce (SqlWork.com) 52,586 Reputation points
1 answer

Assistance Needed: SQL Server 2012 to 2019 In-Place Upgrade - Uninstall 2012 setup file from control panel

I am Santhu, and I recently performed an in-place upgrade from SQL Server 2012 to 2019.I have checked the installed programs and verified the SQL Server 2012. I am considering uninstalling it to prevent any security risks. However, I wanted to seek your…

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,288 questions
asked 2024-02-26T09:54:59.7933333+00:00
Santhosh Dasari 0 Reputation points
answered 2024-02-26T22:42:12.95+00:00
Erland Sommarskog 99,071 Reputation points MVP
1 answer

Unable to enable Microsoft Entra authentication for SQL Server 2022 in Azure Arc page in azure portal

I tried enabling Entra ID in Microsoft Entra ID and Purview for my on premise SQL Server 2022 server registered successfully in Azure Arc. I have also added key vault access policy to the server name, and enabled network access from the server ip. I…

Azure Arc
Azure Arc
A Microsoft cloud service that enables deployment of Azure services across hybrid and multicloud environments.
284 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,288 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
18,673 questions
asked 2024-02-20T12:09:59.7666667+00:00
Chew Kok Hoor 20 Reputation points
commented 2024-02-26T22:05:01.58+00:00
JamesTran-MSFT 36,046 Reputation points Microsoft Employee
1 answer

Can Azure Migrate handle other SQL Server components?

Hello, I have just started to work on a migration project for a client that has the current onpremise environment on Win/SQL 2012 and want to replatform (migrate & upgrade) to Win/SQL 2019. They have cubes (SSAS), Reports (SSRS) and SSIS that need to…

Azure Migrate
Azure Migrate
A central hub of Azure cloud migration services and tools to discover, assess, and migrate workloads to the cloud.
695 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,288 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,732 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,412 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,234 questions
asked 2024-02-26T17:48:38.31+00:00
Abimbola Adeniran 21 Reputation points
answered 2024-02-26T21:29:01.8266667+00:00
Marcin Policht 1,145 Reputation points MVP
0 answers

issue with dynamic query

I am working with windows form(Infragistics grid) with ms sql what is my task : I want to store event related data in database see my below data strucuture: this is event_master -> master table SELECT * FROM dbo.EVENT_MASTER WHERE EVENT_ACTIVE =…

Windows Forms
Windows Forms
A set of .NET Framework managed libraries for developing graphical user interfaces.
1,800 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,288 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.
9,961 questions
asked 2024-02-25T07:22:15.8933333+00:00
Rahul Patil 26 Reputation points
commented 2024-02-26T21:12:57.3566667+00:00
Erland Sommarskog 99,071 Reputation points MVP
1 answer

Can SQL server patching be accomplished on GCC Azure Arc

Can SQL server patching be accomplished on GCC Azure Arc?

Azure Arc
Azure Arc
A Microsoft cloud service that enables deployment of Azure services across hybrid and multicloud environments.
284 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,288 questions
asked 2024-02-06T21:09:39.1033333+00:00
Tom Nesbitt 0 Reputation points Microsoft Employee
commented 2024-02-26T20:11:56.8966667+00:00
Monalla-MSFT 9,756 Reputation points
1 answer

Test Connection failure in Linked Service in data factory while connecting to DB2

Expectation: Data transfer from DB2 to SQL Server Details : While providing all details in the linked service the test connection it getting failed, can you please let me know if whitelisting my IR public IP will resolve it? ERROR details : Cannot…

Azure SQL Database
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
674 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,288 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,101 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,412 questions
asked 2024-02-22T09:59:55.43+00:00
ADMMMLIFEADFADMIN 0 Reputation points
commented 2024-02-26T20:01:57.92+00:00
BhargavaGunnam-MSFT 23,931 Reputation points Microsoft Employee
1 answer

I am unable to publish the DACPAC file: Error: SQL72014: Framework Microsoft SqlClient Data Provider: Msg 15893, Level 16, State 51, Procedure colors, Line 3 Resolving CosmosDB path has failed with error 'Incorrect account 'cosmosdb' or region 'euw'.

I have a DACPAC file and i am unable to publish the it using the cmd command sqlpackage /action:Publish /SourceFile:"ReportingDB.dacpac" /TargetDatabaseName:Database /TargetServerName:”Test-ondemand.sql.azuresynapse.net”…

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,360 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,288 questions
asked 2024-02-16T15:41:30.09+00:00
Lingareddy Chandrakanth Reddy 1 Reputation point
commented 2024-02-26T18:26:14.3266667+00:00
Oury Ba-MSFT 15,116 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

Changing table storage from MDF to NDF

I have a SQL Server DB with a table that takes up too much space. I want to change the table storage from MDF file to NDF in order to improve performance. I have created an NDF file. How can I achieve this? Additionally, I welcome any other suggestions…

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,288 questions
asked 2024-02-26T11:49:09.2466667+00:00
Rafael Carmona Arteaga 20 Reputation points
accepted 2024-02-26T15:13:54.99+00:00
Rafael Carmona Arteaga 20 Reputation points
4 answers One of the answers was accepted by the question author.

ERROR: Method not found: 'Void Microsoft.NetEnterpriseServers.ExceptionMessageBox.SetButtonText(System.String[])'. (Microsoft.DataWarehouse)

Hello, When I want to edit the configuration file at Package Configuration Wizard, I get this error: Method not found: 'Void Microsoft.NetEnterpriseServers.ExceptionMessageBox.SetButtonText(System.String[])'. (Microsoft.DataWarehouse) Please refer to the…

.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,177 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,420 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,288 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,412 questions
.NET Runtime
.NET Runtime
.NET: Microsoft Technologies based on the .NET software framework.Runtime: An environment required to run apps that aren't compiled to machine language.
1,101 questions
asked 2023-02-08T07:25:00.0866667+00:00
syazwan amir 20 Reputation points
answered 2024-02-26T13:57:57.98+00:00
Rakesh 0 Reputation points
1 answer

SSRS Report renders HTML with header and footer embedded images swapped

I've created a report in SSRS (v.15) that has a header and footer defined; I've added two embedded images to the report, one of which I've placed in the header and the other in the footer. When the report is exported from the report server as a PDF, it…

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,732 questions
asked 2023-10-05T20:52:11.5833333+00:00
Cole Smith 0 Reputation points
edited an answer 2024-02-26T09:47:18.0233333+00:00
Andrzej Strzała 0 Reputation points
0 answers

MFA when connecting Azure Sql via ssms

I have not enabled MFA, but when I try to sign in to Azure SQL Database via SSMS, it asks me for an MFA code. I logged in with my M365 account and checked the security info, and MFA was not enabled there. I am able to login to Azure portal without…

Azure SQL Database
Microsoft Authenticator
Microsoft Authenticator
A Microsoft app for iOS and Android devices that enables authentication with two-factor verification, phone sign-in, and code generation.
5,112 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,288 questions
asked 2024-02-07T18:12:56.2+00:00
Siva Prasad 0 Reputation points
commented 2024-02-26T09:15:12.5066667+00:00
Siva Prasad 0 Reputation points
2 answers One of the answers was accepted by the question author.

Should I install latest SQL server update only or all history updates?

I recently installed SQL server 2019 two years ago and haven't installed any updates since then. Should I install the latest update only or all history updates?

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,288 questions
asked 2024-02-18T07:29:18.5533333+00:00
Sayed Ali 20 Reputation points
accepted 2024-02-26T08:50:59.31+00:00
Sayed Ali 20 Reputation points
1 answer

permissions to refresh a data model in azure analysis services

I am refreshing a data model in Azure Analysis Services using an Azure Function App (C# .NET 6). I am using the Microsoft.AnalysisServices.Tabular package available at https://www.nuget.org/packages/Microsoft.AnalysisServices.NetCore.retail.amd64. When I…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
428 questions
Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
4,011 questions
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,177 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,234 questions
asked 2024-02-19T11:10:09.8366667+00:00
Muhammad Pathan 20 Reputation points
commented 2024-02-26T08:22:59.33+00:00
PRADEEPCHEEKATLA-MSFT 73,731 Reputation points Microsoft Employee