SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,771 questions
2 answers
Issue with excessive error messages in SQL Server Log during the reading of Server Audit session (.sqlaudit) files
Hello, I am encountering an issue with a high volume of error messages in the SQL Server Log while reading from an active Server Audit session. This problem occurs in SQL Server 2019 and later versions. I have set up database auditing using Server Audit…
asked 2024-09-23T08:23:47.0466667+00:00
Aleksandar Miljkovic (amiljkov)
0
Reputation points
commented 2024-10-01T13:45:08.17+00:00
Zahid Butt
956
Reputation points
2 answers
One of the answers was accepted by the question author.
rdlc files donot compile or validate in VS 2022
I am trying to upgrade and compile a project in VS 2022 with some rdlc files, it does not show any errors when we try to build or rebuild. It was working on VS2013 before. It showed any compile errors in the files and does not complete the build until…
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,918 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.
10,904 questions
0 answers
Could not connect Azure SQL connect through private link
We encountered an error in the application (dotnet 8.0 console running in AKS container) when trying to connect to a Azure SQL database hosted on a standalone Azure SQL server. Error message A network-related or instance-specific error occurred while…
asked 2024-09-23T09:52:47.7+00:00
Michael Qiuxing Xu
21
Reputation points
commented 2024-10-01T11:03:45.6666667+00:00
Sai Raghunadh M
310
Reputation points Microsoft Vendor
2 answers
SQL 2022 Timeout issues
We recently migrated our databases from SQL Server 2014 to SQL Server 2022 and have noticed sudden timeout issues occurring in the application, specifically with stored procedures containing SELECT queries in the SQL 2022 database. These timeouts are…
asked 2024-09-12T06:13:58.0366667+00:00
MOHAMMED ILYAS
0
Reputation points
commented 2024-10-01T09:29:07.2+00:00
Erland Sommarskog
111.1K
Reputation points MVP
4 answers
A SQL2005 query worked before but not now.
select name, EDI_code, perdose, perday, howlongday, count(*) AS frequencies from prescriptions_pharmacy group by name, EDI_code, perdose, perday, howlongday When I execute above query in Server Management Studio Express, Incorrect syntax near '' error is…
asked 2024-09-27T08:50:40.3566667+00:00
Kay_Lee
101
Reputation points
commented 2024-10-01T09:20:15.7366667+00:00
Erland Sommarskog
111.1K
Reputation points MVP
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: …
asked 2024-09-02T13:02:14.1133333+00:00
TheSimoz
0
Reputation points
commented 2024-10-01T08:35:33.2466667+00:00
Sai Raghunadh M
310
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
asked 2024-09-28T11:08:59.5566667+00:00
Ngô Thành Quang
20
Reputation points
commented 2024-10-01T05:52:08.5+00:00
Ngô Thành Quang
20
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…
asked 2024-09-09T03:47:00.48+00:00
Mohammed Akbar Pasha
0
Reputation points
commented 2024-10-01T03:58:05.1833333+00:00
Mohammed Akbar Pasha
0
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…
asked 2024-09-09T03:47:00.48+00:00
Mohammed Akbar Pasha
0
Reputation points
commented 2024-10-01T03:58:05.1833333+00:00
Mohammed Akbar Pasha
0
Reputation points
1 answer
What are the port requirements for Distributed Availability Group (DAG)?
I plan to implement DAG with below topology (winserver 2019, sql server 2019): DC A: Primary DC Secondary DC Quorum witness DC B: Primary DRC Secondary DRC Quorum witness Notes: Seperated replication and access IP Question: What is all of…
asked 2024-09-30T08:18:48.19+00:00
Bayu Aji Setyawan
0
Reputation points
commented 2024-10-01T03:33:06.6566667+00:00
Bayu Aji Setyawan
0
Reputation points
0 answers
how to fix "XAAccess - EnableXAAccess(EnalbeXAAccess) => Exiting(False)" error in DB2OLEDBv6 in for Windows 2019 Server
When install DB2OLEDBv6.msi for a Windows 2019 Server it start install, but in middle cancel and do rollback for install process. I tried install it with "DB2OLEDBv6 /quiet /l log.txt" In log.txt file appears first errors: Calling custom…
asked 2024-09-30T17:24:55.6+00:00
Malagon, Jairo E INTL - Colombia
0
Reputation points
asked 2024-09-30T17:24:55.6+00:00
Malagon, Jairo E INTL - Colombia
0
Reputation points
0 answers
how to fix "XAAccess - EnableXAAccess(EnalbeXAAccess) => Exiting(False)" error in DB2OLEDBv6 in for Windows 2019 Server
When install DB2OLEDBv6.msi for a Windows 2019 Server it start install, but in middle cancel and do rollback for install process. I tried install it with "DB2OLEDBv6 /quiet /l log.txt" In log.txt file appears first errors: Calling custom…
asked 2024-09-30T17:24:55.6+00:00
Malagon, Jairo E INTL - Colombia
0
Reputation points
asked 2024-09-30T17:24:55.6+00:00
Malagon, Jairo E INTL - Colombia
0
Reputation points
3 answers
SQL SERVER 2017 fails to be installed on the laptop.code:-2068119551
OS:windows11 sql server 2017 I encountered this problem when installing sql server 2017 on my laptop. There have been attempts: A. Uninstall and reinstall b. Before reinstallation, install the latest patch of sql server 2017, KB5016884 c. Turn off the…
asked 2024-09-30T08:10:16.6033333+00:00
Max Song
0
Reputation points
answered 2024-09-30T15:11:45.9833333+00:00
Bruce (SqlWork.com)
64,901
Reputation points
2 answers
I have installed Microsoft SQL Server 2022, but I cannot see the SSIS & SSAS packages.
Good day! When I installed SQL Server, I remember having ticked the options that asked me whether I wanted to include SSAS, SSIS & SSRS; I ticked them all since I wanted to have a many features as I possibly could. Now, am studying the book below: I…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,099 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,771 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,918 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,576 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,282 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,099 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,771 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,918 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,576 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,282 questions
asked 2024-09-30T10:23:41.08+00:00
Eric KALONJI
0
Reputation points
commented 2024-09-30T13:48:32.31+00:00
Eric KALONJI
0
Reputation points
2 answers
I have installed Microsoft SQL Server 2022, but I cannot see the SSIS & SSAS packages.
Good day! When I installed SQL Server, I remember having ticked the options that asked me whether I wanted to include SSAS, SSIS & SSRS; I ticked them all since I wanted to have a many features as I possibly could. Now, am studying the book below: I…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,099 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,771 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,918 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,576 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,282 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,099 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,771 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,918 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,576 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,282 questions
asked 2024-09-30T10:23:41.08+00:00
Eric KALONJI
0
Reputation points
commented 2024-09-30T13:48:32.31+00:00
Eric KALONJI
0
Reputation points
0 answers
Azure DevTunnel Host cannot access sql server instance.
Hi. I'm trying to access my local SQL Server instance remotely, using Azure DevTunnel as the remote host. I'm doing the following: devtunnel host -p 1433 -a Then I'm using the host that comes back to attempt to log in to sql server. This doesn't seem…
asked 2024-09-30T13:47:02.5833333+00:00
Nore Gabbidon
0
Reputation points
asked 2024-09-30T13:47:02.5833333+00:00
Nore Gabbidon
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
mm
0
Reputation points
commented 2024-09-30T08:45:39.3233333+00:00
MikeyQiaoMSFT-0444
2,950
Reputation points
asked 2024-09-23T20:19:32.15+00:00
Lokesh Sivaprakash
0
Reputation points
commented 2024-09-30T08:36:54.11+00:00
MikeyQiaoMSFT-0444
2,950
Reputation points
1 answer
DQS DATA QUALITY AGENT
I GOT THIS ERROR
asked 2024-09-27T11:51:37.3833333+00:00
ADEL RAMADAN TAHA
0
Reputation points
commented 2024-09-30T07:22:52.6966667+00:00
LucyChenMSFT-4874
4,750
Reputation points
2 answers
Description of the security update for SQL Server 2016 SP3 GDR: failed with error Exit Code - 2068052374
How to Fix KB5042207 - Description of the security update for SQL Server 2016 SP3 GDR: failed with error Exit Code - 2068052374. Kindly help to fix above issue.
asked 2024-09-23T10:20:26.3466667+00:00
Rakesh
0
Reputation points
commented 2024-09-30T07:22:01.2433333+00:00
LucyChenMSFT-4874
4,750
Reputation points