19,029 questions with SQL Server-related tags

Sort by: Updated
1 answer One of the answers was accepted by the question author.

SSRS 2019 installation

I need to install and run SSRS 2019 from Azure VM. Database Engine is a SQL Managed Instance for ReportServer and ReportServer_Tempdb. VM and SQL MI are located in same region on same Vnet. Where do I get the product key from SQL MI to complete a…

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.
13,638 questions
asked 2024-09-05T20:19:54.0566667+00:00
Charles Dove 20 Reputation points
commented 2024-09-09T15:09:16.19+00:00
Mahesh Kurva 0 Reputation points Microsoft Vendor
0 answers

Which dot net frame is used by SQL server 2016 SSIS packages

Which dot net frame is used by SQL server 2016 SSIS packages

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
527 questions
asked 2024-09-09T14:23:34.13+00:00
Kallavi, Vasudeva Gururaja 0 Reputation points
4 answers

IDbConnection error on process SASS database caused by Windows updates

Hello, At some point, our developer instance of Analysis Services started to give an error: Errors in the high-level relational engine. . The exception was raised by the IDbConnection interface. It does not contain any on what is wrong with it. It…

Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,897 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,272 questions
asked 2020-09-22T10:05:03.96+00:00
Vladimir Kovalenko 11 Reputation points
commented 2024-09-09T14:21:37.4933333+00:00
Ali Alyaqubi 0 Reputation points
0 answers

Defender for SQL Servers - DCRs, LAW and settings

Hello all, we have activated Defender for SQL Servers in a customer environments. When we have enabled Defender for SQL, it automatically created some resources (as documented by MS) specifically: DCR: MicrosoftDefenderForSQL--dcr DCRA:…

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.
15 questions
asked 2024-08-04T07:47:51.4966667+00:00
vincent manzari 41 Reputation points
edited the question 2024-09-09T12:45:11.38+00:00
SadiqhAhmed-MSFT 44,251 Reputation points Microsoft Employee
0 answers

Cannot insert duplicate key row in object with index ncix_id with non-unique index

Hello! Microsoft SQL Server 2019 (RTM-CU20) (KB5024276) on Linux (CentOS Linux 7 (Core)) <X64> We have a table with 3 indexes: FIX_ActionSerial - nonclustered, unique located on PRIMARY - ActionSerial ncix_planID - nonclustered located on…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,638 questions
asked 2024-09-09T10:38:28.17+00:00
Oleksii Filipov 20 Reputation points
edited a comment 2024-09-09T11:09:48.8066667+00:00
Oleksii Filipov 20 Reputation points
1 answer

Retrieve connection string from PowerBI reports

Hi All, I need to retrieve the connection string of the PowerBI reports. Could you help to get the query for it. As I have seen in Catalog, Datasource and Extended Datasource, but unable to get the data related to PowerBI reports dashboards, their type…

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,912 questions
asked 2024-09-02T07:43:16.9966667+00:00
Sravanthi Godavarthy 20 Reputation points
commented 2024-09-09T10:59:17.8633333+00:00
Lai Sabina 0 Reputation points
0 answers

What are best security best practices to connect AKS with SQL Server?

Hi, I have an AKS cluster on Azure and one of the pod is connecting to the SQL server, the SQL server is also being consumed by a function app. I dont want my SQL server to be exposed publicly, and I know private endpoint can be used between function app…

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.
13,638 questions
Azure Kubernetes Service (AKS)
Azure Kubernetes Service (AKS)
An Azure service that provides serverless Kubernetes, an integrated continuous integration and continuous delivery experience, and enterprise-grade security and governance.
2,068 questions
asked 2024-09-09T07:58:28.5733333+00:00
Najam ul Saqib 240 Reputation points
edited the question 2024-09-09T10:48:28.3266667+00:00
Najam ul Saqib 240 Reputation points
1 answer One of the answers was accepted by the question author.

Error while loading image - MySQL Workbench

When I am opening a local connection in MySQL, an error occurring while loading image search_sidebar.png.How can I solve this problem in MySQL? I have attached a screenshot of error showing I am using MySQL Server 5.7 and MySQL Workbench 6.3 version…

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.
13,638 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,912 questions
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.
13,638 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,912 questions
asked 2024-09-09T10:26:35.3366667+00:00
Laxmikant mainaji Katkhade 140 Reputation points
accepted 2024-09-09T10:31:42.78+00:00
Laxmikant mainaji Katkhade 140 Reputation points
1 answer One of the answers was accepted by the question author.

Error while loading image - MySQL Workbench

When I am opening a local connection in MySQL, an error occurring while loading image search_sidebar.png.How can I solve this problem in MySQL? I have attached a screenshot of error showing I am using MySQL Server 5.7 and MySQL Workbench 6.3 version…

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.
13,638 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,912 questions
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.
13,638 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,912 questions
asked 2024-09-09T10:26:35.3366667+00:00
Laxmikant mainaji Katkhade 140 Reputation points
accepted 2024-09-09T10:31:42.78+00:00
Laxmikant mainaji Katkhade 140 Reputation points
1 answer

Azure SQL data encryption

I want to confirm that Azure SQL connections are encrypted or that this Azure space does not allow unencrypted connections.

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.
13,638 questions
asked 2024-09-04T16:54:31.8166667+00:00
gmplaunt 0 Reputation points
edited a comment 2024-09-09T08:46:23.0066667+00:00
Mahesh Kurva 0 Reputation points Microsoft Vendor
1 answer

What would be the best asp.net option that allows a SQL database and communicates with a .NET MAUI frontend?

I am currently working on designing a cross platform application with .NET MAUI. I've decided to migrate my previous database to a SQL database. Looking at the Microsoft documentation, it showed the asp.net core web MVC project as the standard for using…

ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,504 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.
13,638 questions
.NET MAUI
.NET MAUI
A Microsoft open-source framework for building native device applications spanning mobile, tablet, and desktop.
3,377 questions
asked 2024-09-08T23:12:50.52+00:00
Anis Redmond 0 Reputation points
answered 2024-09-09T08:44:58.0866667+00:00
Yonglun Liu (Shanghai Wicresoft Co,.Ltd.) 41,601 Reputation points Microsoft Vendor
0 answers

Quickest way to restore remote Azure SQL Database from the cloud to local

Working with Azure SQL Database on elastic pool I often need to pull entire database locally mainly for performance reasons on intensive tasks. Currently, whenever I need to bring a cloud database to my local (Sql Server on Docker) I do the following: …

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.
13,638 questions
asked 2024-09-02T13:02:14.1133333+00:00
TheSimoz 0 Reputation points
commented 2024-09-09T08:05:45.2933333+00:00
Sai Raghunadh M 75 Reputation points Microsoft Vendor
1 answer

Azure Blob Download Task error

Greetings!!! I am using the Azure Blob Download task to copy files from Azure Data Lake Storage Gen2 on to a local directory on-premise. But, when I do this I run into error. Error Message: [Azure Blob Download Task] Error: Download task has stopped with…

Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,782 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,560 questions
asked 2024-09-04T23:35:58.4833333+00:00
Raj D 591 Reputation points
commented 2024-09-09T07:41:24.8533333+00:00
Nehruji R 7,046 Reputation points Microsoft Vendor
1 answer

SSRS report are getting stuck in executing mode

Hi Team, SSRS reports in Microsoft Dynamics AX 2012 are frequently becoming stuck in execution mode. This issue occurs across all reports, not just specific ones. To resolve this, we must manually stop and restart the SSRS Reporting Service on the report…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,638 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,912 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.
13,638 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,912 questions
asked 2024-09-09T03:47:00.48+00:00
Mohammed Akbar Pasha 0 Reputation points
edited an answer 2024-09-09T07:36:56.4866667+00:00
ZoeHui-MSFT 36,111 Reputation points
1 answer

SSRS report are getting stuck in executing mode

Hi Team, SSRS reports in Microsoft Dynamics AX 2012 are frequently becoming stuck in execution mode. This issue occurs across all reports, not just specific ones. To resolve this, we must manually stop and restart the SSRS Reporting Service on the report…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,638 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,912 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.
13,638 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,912 questions
asked 2024-09-09T03:47:00.48+00:00
Mohammed Akbar Pasha 0 Reputation points
edited an answer 2024-09-09T07:36:56.4866667+00:00
ZoeHui-MSFT 36,111 Reputation points
4 answers

How to write/read comma-separated data from an SQL table and load them into a datagridview column?

I want to write comma-separated string values entered in a text box to an SQL table and later fetch them from the table and load them into a data grid view column.

.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,782 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.
13,638 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,713 questions
SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
88 questions
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,782 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.
13,638 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,713 questions
SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
88 questions
asked 2024-09-07T16:06:21.0566667+00:00
Priyantha Niroshan 21 Reputation points
edited the question 2024-09-09T07:30:50.49+00:00
Jiachen Li-MSFT 30,931 Reputation points Microsoft Vendor
4 answers

How to write/read comma-separated data from an SQL table and load them into a datagridview column?

I want to write comma-separated string values entered in a text box to an SQL table and later fetch them from the table and load them into a data grid view column.

.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,782 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.
13,638 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,713 questions
SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
88 questions
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,782 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.
13,638 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,713 questions
SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
88 questions
asked 2024-09-07T16:06:21.0566667+00:00
Priyantha Niroshan 21 Reputation points
edited the question 2024-09-09T07:30:50.49+00:00
Jiachen Li-MSFT 30,931 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

How can i generate a personal unique number for user?

Hello. i am creating a website for a courier in my local area and i want to be able to implement a feature. Once the users' registers, they will be given a personal unique id which can be used for one user only to keep track of their data from the…

Blazor
Blazor
A free and open-source web framework that enables developers to create web apps using C# and HTML being developed by Microsoft.
1,551 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.
13,638 questions
ASP.NET API
ASP.NET API
ASP.NET: A set of technologies in the .NET Framework for building web applications and XML web services.API: A software intermediary that allows two applications to interact with each other.
328 questions
asked 2024-09-08T20:56:19.2566667+00:00
A.haque 0 Reputation points
commented 2024-09-09T07:07:53.8833333+00:00
A.haque 0 Reputation points
2 answers One of the answers was accepted by the question author.

What is difference between VCore of SQL Database and Vcore of General Purpose

Hi! I am doing this training: Prepare to maintain SQL databases on Azure And it says the below which really confuses me. It makes a difference between VCore of SQL Database and Vcores of General Purpose, and in the Standard Edition it does not include a…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,638 questions
asked 2024-09-06T11:16:44.18+00:00
Blanka Oljelund 20 Reputation points
commented 2024-09-09T06:32:08.5966667+00:00
Blanka Oljelund 20 Reputation points
2 answers

Hello Microsoft, I am having problems installing SQL Server Developer. I have tried several ways but it doesn't work. I hope you can help me.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,638 questions
asked 2024-09-02T22:35:16.6566667+00:00
Lathif Nur Hidayat 0 Reputation points
commented 2024-09-09T06:26:36.8733333+00:00
CathyJi-MSFT 21,786 Reputation points Microsoft Vendor