SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,689 questions
0 answers
Has anyone resolved the "Database Engine recovery handle failed" and "firewall warrnig" error during SQL Server installation on Windows 11?
I am encountering critical issues with installing both SQL Server 2017 or SQL Server 2022 on my Windows 11 Home (x64) machine. Below is a summary of the problems and the steps I have taken to resolve them: Issue Summary: Warning: Firewall warning…
asked 2024-09-18T20:12:32.37+00:00
Yogendra Dwivedi
20
Reputation points
commented 2024-09-19T13:36:48.46+00:00
Erland Sommarskog
110.4K
Reputation points MVP
0 answers
Has anyone resolved the "Database Engine recovery handle failed" and "firewall warrnig" error during SQL Server installation on Windows 11?
I am encountering critical issues with installing both SQL Server 2017 or SQL Server 2022 on my Windows 11 Home (x64) machine. Below is a summary of the problems and the steps I have taken to resolve them: Issue Summary: Warning: Firewall warning…
asked 2024-09-18T20:12:32.37+00:00
Yogendra Dwivedi
20
Reputation points
commented 2024-09-19T13:36:48.46+00:00
Erland Sommarskog
110.4K
Reputation points MVP
0 answers
In SSRS, I need to display only one record on each page
In SSRS, I need to display only one record on each page, with the next record appearing on the second page, and so on. Currently, I have two tables, two text boxes, and one matrix per page. I've tried rows grouping, but it's affected the first table…
asked 2024-09-19T13:19:37.65+00:00
M ZUNAIR TARIQ
20
Reputation points
edited the question 2024-09-19T13:21:37.3566667+00:00
M ZUNAIR TARIQ
20
Reputation points
1 answer
One of the answers was accepted by the question author.
SQL Server Integration Services and Azure Data Lake Store Connection Manager
Is it possible a SQL Server Integration Services (SSIS) package can use the Azure Data Lake Store Connection Manager to connect to an Azure Data Lake Storage Gen2 ?? From what I read the article below refers only for Gen 1 but and about the Gen 2? Link…
asked 2024-09-18T14:52:20.88+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 74%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELB%3C/text%3E%3C/svg%3E)
Leonardo Bruno Pereira de Araujo
0
Reputation points
commented 2024-09-19T11:29:24.41+00:00
Leonardo Bruno Pereira de Araujo
0
Reputation points
0 answers
how to get max min date from a tuple
suppose i have a bunch of people (with dimension) they have a bunch of claims (dimension) and in each claim there is a bunch of records with amount and date! those records/transactions form a cube with measures like amounts paid Ultimately i need to get…
asked 2024-09-19T10:53:17.7133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 76%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGL%3C/text%3E%3C/svg%3E)
greg lipman
61
Reputation points
asked 2024-09-19T10:53:17.7133333+00:00
greg lipman
61
Reputation points
1 answer
How to fix sql server agent job failure while extracting data from a excel file and storing in a sql db using a ssis .dtsx package?
I am getting following error when running ssis .dtsx package from sql server agent job. This package is extracting data from a excel file and storing in a sql DB. please find following error: The step did not generate any output. The return value was…
asked 2023-11-29T18:31:31.6633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 27%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDK%3C/text%3E%3C/svg%3E)
Deepak Kumar
5
Reputation points
commented 2024-09-19T10:48:40.04+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 6%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
Likhitha
0
Reputation points
2 answers
Prevent access from excel
I am looking to prevent access from Excel to my SSAS... I have 10 cubes, and several PowerBI that consume from it... But I have some users that connect from excel and I want to prohibit that access. How can I prevent people accessing from excel?
asked 2024-09-18T13:04:27.5766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 71%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
mm
0
Reputation points
answered 2024-09-19T09:46:45.8766667+00:00
MikeyQiaoMSFT-0444
2,790
Reputation points
0 answers
Azue Arc SqlAgent Extension Status Failed or stuck as Creating
Many of the Azure Arc Enabled SQL Servers were no longer reporting SQL BPA as being enabled. After some investigation I found that all the servers with issues had the SqlAgent Extension with a Status of failed. I would like to know how that could have…
asked 2024-09-17T01:27:08.17+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 40%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESI%3C/text%3E%3C/svg%3E)
Sean I
0
Reputation points
commented 2024-09-19T09:31:50.93+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
ShaktiSingh-MSFT
15,131
Reputation points
1 answer
Linkedserver connection to MySQL database with ODBC driver failed
Hi I am attempting to use a SQL Server 2014 linked server to connect to a MySQL 8 instance. My single openquery insert statement works fine, but when I try to run multiple insert statements to insert data to multiple tables, I receive a generic error…
asked 2024-09-17T05:53:47.2933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 40%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
binrip
0
Reputation points
edited a comment 2024-09-19T09:19:37.8433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Mahesh Kurva
5
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Persistent SQL Server Service Termination with Port Configuration Errors Despite Firewall and TCP/IP Adjustments and basic troubleshooting
Hello, I am using an enterprise application on one of my servers (Server 2019) and recently migrated its database to MSSQL 2022 on another server. Initially, it was slow, but now SQL Server is repeatedly stopping right after starting. Here’s what I’ve…
asked 2024-09-18T06:26:14.5033333+00:00
Tharun Reddy K
20
Reputation points
accepted 2024-09-19T07:20:30.2466667+00:00
Tharun Reddy K
20
Reputation points
1 answer
unable to save SQL-Query in SQL Server Management Studio 18 on company's sharepoint
Use case: I uploaded a .sql file on the company's SharePoint in order to share it with my colleagues / collaborate on the query with them. when opening it in SQL Server Management Studio 18 i can edit it, but cannot re-safe it, as it is "locked by…
asked 2024-09-17T14:13:58.2966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 69%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPD%3C/text%3E%3C/svg%3E)
Pein David
0
Reputation points
commented 2024-09-19T07:12:46.22+00:00
Pein David
0
Reputation points
1 answer
Queries are limited to 4000 characters.
I am working on a semantic search engine and I need to be able to search for synonyms and inflections of the words in the phrase that the user enters. I have encountered the problem that the parameter “contains_search_condition” of the Contains or…
asked 2024-09-19T04:19:40.1633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 26%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZ%3C/text%3E%3C/svg%3E)
zequion
401
Reputation points
edited an answer 2024-09-19T06:55:48.8466667+00:00
LiHongMSFT-4306
26,791
Reputation points
1 answer
Failover for secondary read-only endpoint in SQL failover group
Usecase My team has a SQL failover group set up where we use primary region for read-write workloads. We use secondary region to serve read only workloads. I am exploring options for ensuring data availability when secondary server/region is down. …
asked 2024-09-16T19:03:20.43+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 84%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDP%3C/text%3E%3C/svg%3E)
Devanshi Patel
0
Reputation points Microsoft Employee
edited an answer 2024-09-19T06:41:20.18+00:00
LucyChenMSFT-4874
4,430
Reputation points
2 answers
Autogrowth option for Log File (Image files)
Data Migration Assistant (DMA) suggested below recommendation, But the DB Properties don't have option for Autogrowth to ImageFiles How to make it autogrow? The DB is currently in CL100, soon to be upgraded to CL160
asked 2024-09-05T05:55:42.31+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 75%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Radhai Krish
191
Reputation points
commented 2024-09-19T06:00:25.5466667+00:00
MikeyQiaoMSFT-0444
2,790
Reputation points
2 answers
Errors during build of SQL Server 2022 Projects with VS2019 Professional & AzureDataStudio
Stuck with this issue for longer time. I am trying to create SQL Server Projects for a DB being in SQLServer2022 using VS2019 Professional. DB is old running/being in use since 2009. How much ever I try I face the following warnings & errors, but…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,056 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,689 questions
Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
112 questions
asked 2024-09-18T06:08:31.24+00:00
Radhai Krish
191
Reputation points
edited a comment 2024-09-19T05:53:49.63+00:00
LucyChenMSFT-4874
4,430
Reputation points
1 answer
Unable to process the existing user settings and will overwrite the file with user settings from this session.
I have local install of sql server 2022, with Analysis server & MSRS features enabled, when I launch the management studio, I get the error message below, any suggestions on how to suppress the message ? Thanks Jay Unable to process the existing…
asked 2024-07-30T16:36:54.4966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 65%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJT%3C/text%3E%3C/svg%3E)
Jay Tabatabai
20
Reputation points
commented 2024-09-19T03:46:10.2233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(76.8, 25%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENC%3C/text%3E%3C/svg%3E)
Nick Christie
1
Reputation point
2 answers
Is my Resource Governor set up correctly?
Greetings. I have a particular server configured as follows: DB1 -- this guy is the Subscriber of a transaction replication topology. DB2 -- this guy is a Data Warehouse (using that term loosely). If queries data from DB1, as well as other sources…
asked 2024-09-18T18:01:13.3533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 26%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
chrisrdba
386
Reputation points
answered 2024-09-19T03:27:11.2633333+00:00
CathyJi-MSFT
21,871
Reputation points Microsoft Vendor
2 answers
PivotTable in Excel
Hi All, I'm using a tabular model in Excel, everytime i add a filter, row or column in the PivotTable, the excel tries to execute the query to refresh data. Since our tabular model is full of data and dax, it takes time every time the excel refresh…
asked 2021-05-03T21:26:19.957+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 30%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Samir abdelmalek
21
Reputation points
edited a comment 2024-09-19T02:30:33.8966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 68%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM0%3C/text%3E%3C/svg%3E)
MyName-0111
0
Reputation points
2 answers
How to make sql server backup files immutable
How to make sql server backup files immutable without using Azure Storage?
asked 2024-09-18T16:46:04.53+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 34%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDG%3C/text%3E%3C/svg%3E)
Dave Guo
0
Reputation points
answered 2024-09-19T02:01:03.6833333+00:00
LucyChenMSFT-4874
4,430
Reputation points
2 answers
Unable to connect SQL server to Power BI
Getting below error while connecting Sql to Power Bi We encountered an error while trying to connect. Details: "Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not…
asked 2024-09-18T11:26:34.39+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 62%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESY%3C/text%3E%3C/svg%3E)
Sachin Yadav
0
Reputation points
answered 2024-09-19T01:26:24.8133333+00:00
LiHongMSFT-4306
26,791
Reputation points