18,058 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
0 answers

Encrypt a SQL session with PowerBI Desktop

I want to connect to a local SQL Server database, using Power BI Desktop. On the SQL Server instance encryption has been enforced. When I make the connection Power BI Desktop keeps telling that it cannot make a connection because encryption is not…

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,825 questions
asked 2024-05-14T09:38:46.7366667+00:00
Erik Verheuvel 41 Reputation points
commented 2024-05-14T11:17:13.1633333+00:00
Erik Verheuvel 41 Reputation points
1 answer

I am facing Issues for data replication of specific tables (Bi-Directional) in SQL databases at two different regions hosted on Azure Cloud.

Hi, I have SQL Databases in Europe Region & USA Region hosted on Microsoft Azure cloud. I want to sync specific tables of both databases. I have researched about database replication approach (Transactional Replication, Snapshot Replication,…

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,825 questions
asked 2024-05-09T18:23:13.1233333+00:00
Raj, Ritu 0 Reputation points
edited a comment 2024-05-14T10:06:23.7+00:00
Raj, Ritu 0 Reputation points
0 answers

How can we access SQL Server hosted on on-premises from Function app

I am trying to access SQL Server hosted on Azure VM from Function app using python. But I am getting this error: Result: Failure Exception: OperationalError: (pyodbc.OperationalError) ('HYT00', '[HYT00] [Microsoft][ODBC Driver 18 for SQL Server]Login…

Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
4,334 questions
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,220 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,825 questions
asked 2024-05-14T09:32:05.17+00:00
Ritika Pandey 0 Reputation points
2 answers

-2061893606 error

ERRORLOG.txt I can't download sql 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.
12,825 questions
asked 2024-05-11T10:45:29.8933333+00:00
JONATHAN HANSEN 0 Reputation points
commented 2024-05-14T09:29:24.7733333+00:00
MikeyQiao-MSFT 575 Reputation points Microsoft Vendor
3 answers

Unable to install SQL Server (setup.exe). Exit code (Decimal): -2061893606Error description: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.

I have been trying to run kestrel in Visual Studio, and then I got this message: System.AggregateException: 'One or more errors occurred. (A network-related or instance-specific error occurred while establishing a connection to SQL Server. The 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.
12,825 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,247 questions
asked 2024-05-10T07:45:13.2366667+00:00
Natalia Medrano 0 Reputation points
commented 2024-05-14T09:29:04.8366667+00:00
MikeyQiao-MSFT 575 Reputation points Microsoft Vendor
2 answers

SQL Connectivity Issue From Cloud app to on-prem server

hi, I have deployed a .net core MVC app in azure app service as a webapp. I have to connect to a on-prem sql server to retrieve data. I have setup Azure relay/hybrid connection for the same. Also I have installed hybrid connection manager in on-prem…

ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,214 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,825 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
6,963 questions
asked 2024-05-07T10:38:07.05+00:00
Santhi Dhanuskodi 145 Reputation points
answered 2024-05-14T09:25:52.63+00:00
MikeyQiao-MSFT 575 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

Azure Managed disk performance analysis for SQL Server DB Backup

We are currently trying to optimize cost in our Azure environment and are reviewing dedicated backup disks on servers. We have a few servers running single Premium SSD P50 - 4TB as backup disks, but the actual backup files on these drives are often less…

SQL Server on Azure Virtual Machines
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,825 questions
Azure Disk Storage
Azure Disk Storage
A high-performance, durable block storage designed to be used with Azure Virtual Machines and Azure VMware Solution.
578 questions
asked 2024-05-11T11:20:30.0233333+00:00
Abimbola Adeniran 41 Reputation points
accepted 2024-05-14T08:39:12.5733333+00:00
Abimbola Adeniran 41 Reputation points
0 answers

I have a problem with the SQL server. The connection is disconnected. Sometimes I looked in the events. The code prints event 17886.

<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event"> <System> <Provider Name="MSSQLSERVER" /> <EventID Qualifiers="49152">17886</EventID> …

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,825 questions
asked 2024-05-14T06:51:54.7566667+00:00
saleh ahmed 0 Reputation points
2 answers

How to restore SQL server 2019 database backup (.bak) to SQL server 2017.

Hi, In one of our legacy project we are using SQL Server 2017 database, and in this we need to restore backup (.bak) taken from SQL Server 2019 database. While database restore (taken from 2019) in SQL server 2017 we are getting incompatibility error. …

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,825 questions
asked 2024-05-14T05:26:36.97+00:00
Shyam Kumar 0 Reputation points
answered 2024-05-14T06:50:53.81+00:00
LucyChen-MSFT 1,280 Reputation points Microsoft Vendor
2 answers

Will there be any problems in directly replacing the version of Log4j.jar from 1.17 to 2.X in SQL Server 2019?

Hi Team, Background: We now have installed Microsoft SQL Server 2019 Express locally. After installation, we found that it automatically uses the Log4j 1.2.17 version jar package. (As shown in the picture.) Since the jar package of Log4j version 1.2.17…

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,825 questions
asked 2024-05-13T02:26:20.46+00:00
Shi Liu 0 Reputation points
commented 2024-05-14T06:39:53.2233333+00:00
MikeyQiao-MSFT 575 Reputation points Microsoft Vendor
1 answer

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,825 questions
asked 2024-05-14T05:12:06.68+00:00
Manjunatha Reddy 0 Reputation points
answered 2024-05-14T06:25:47.04+00:00
MikeyQiao-MSFT 575 Reputation points Microsoft Vendor
1 answer

How to sql dump generation on sql server 2008 ?

Good morning, I use SQL SERVER 2008 R2 and for a few days now I have had disk C filling up due to the generation of SQLDUMP files in the log directory. Can you give me the procedure to disable the generation of these files please. Thanks in advance.

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,825 questions
asked 2024-05-13T16:40:04.5466667+00:00
Tidiane TRAORE 0 Reputation points
edited an answer 2024-05-14T06:05:47.0466667+00:00
LucyChen-MSFT 1,280 Reputation points Microsoft Vendor
1 answer

How to grant a single SSRS User access to multiple folders

Is there any way to grant a SSRS login the same level of access to multiple folders in one shot instead of going through each and any Folder that has "custom" security or in other words not inherited from parent "Home"? In new SSRS…

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,815 questions
asked 2024-05-13T20:20:43.9433333+00:00
Nenea Nelu 66 Reputation points
answered 2024-05-14T05:51:29.42+00:00
ZoeHui-MSFT 33,301 Reputation points
2 answers

Unable to connect to my SQL Server/Database. Listed resources on Microsoft do not address this issue.

Error codeSqlFailedToConnect DetailsCannot connect to SQL Database. Please contact SQL server team for further support. Server: 'blazor-wasm-app.database.windows.net', Database: 'BrandedFoodMacrosContent', User: [...BLANK...] Check the linked service…

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,825 questions
asked 2024-05-04T23:34:12.1833333+00:00
Albert Kirpach 0 Reputation points
commented 2024-05-14T03:57:33.04+00:00
ShaktiSingh-MSFT 13,826 Reputation points Microsoft Employee
3 answers

SQL Select subquery using exists

I am trying to write a query with a subquery. The subquery returns what is in the attached image below. select top(1) with ties matter_uno, PART_CAT_CODE, EFF_DATE, EMPL_UNO from TBM_CLMAT_PART where MATTER_UNO = 11275 and PART_CAT_CODE = 'BILL' order…

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,825 questions
asked 2024-05-13T17:35:44.68+00:00
Joseph Mancini 41 Reputation points
answered 2024-05-14T02:26:21.54+00:00
CosmogHong-MSFT 23,401 Reputation points Microsoft Vendor
1 answer

Unable to install SQL Server. Exit code (Decimal): -2064908287

Hi, I tried to reinstall SQL server and it shows this error, please tell me how to solve this problem. Thank you. This is all it says in the summary file Overall summary: Final result: Failed: see details below Exit code…

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,825 questions
asked 2024-05-11T19:27:24.82+00:00
Dante904 0 Reputation points
commented 2024-05-13T21:57:12.06+00:00
Dante904 0 Reputation points
2 answers

can not start sql server2012.the request failed or ther service did not respond in a timely fashion.

This error will be reported after starting sql server 2012, check the log，Please refer to the following picture to view the log. How to solve it? The description for Event ID 17836 from source MSSQL$MSSQL2012 cannot be found. Either the component 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,825 questions
asked 2024-05-11T04:10:59.0033333+00:00
Han Yang 0 Reputation points
commented 2024-05-13T21:05:52.08+00:00
Erland Sommarskog 101.9K Reputation points MVP
2 answers

SQL2022-SSEI-Expr setup file is not opening

I downloaded the express edition file from here :https://www.microsoft.com/en-us/sql-server/sql-server-downloads When I try to open it , the file dont open . dont know whats wrong with it. Need Help with the installation. TIA

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,825 questions
asked 2024-04-24T12:17:54.3266667+00:00
sakib rahman 0 Reputation points
commented 2024-05-13T20:55:27.6666667+00:00
Erland Sommarskog 101.9K Reputation points MVP
2 answers One of the answers was accepted by the question author.

How can I run an automation template

I want to run an automation template for a sql database deployed with ARM. The aim is to trigger a stored procedure

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,825 questions
Azure Automation
Azure Automation
An Azure service that is used to automate, configure, and install updates across hybrid environments.
1,134 questions
asked 2024-05-08T00:16:54.5566667+00:00
Oyin 20 Reputation points
accepted 2024-05-13T20:11:52.9266667+00:00
Oyin 20 Reputation points
1 answer One of the answers was accepted by the question author.

Keep getting this error regardless to the accoun tused

SQL server 2022 / SSRS 2022, getting this error even when using an admin account An error has occurred during report processing. (rsProcessingAborted) Cannot impersonate user for data source 'AutoGen__5C6349F2_4BB6_4a1b_A16E_8D69795D8602_'.…

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,815 questions
Microsoft Configuration Manager
asked 2024-05-13T01:25:46.7933333+00:00
Belgian Malinois 356 Reputation points
commented 2024-05-13T16:32:12.89+00:00
Belgian Malinois 356 Reputation points