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.
3,031 questions
2 answers
SSRS report - all hyperlinks have target of _top
I am creating a hyperlink like this: ="<a href=""https://www.google.com"" target=""_blank"">Link</a>" It works but I need to open it in the tab. When I inspect the element the target is…
asked Sep 16, 2021, 11:32 AM
![](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(112.00000000000001, 13%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMG%3C/text%3E%3C/svg%3E)
mark goldin
691
Reputation points
edited a comment Apr 10, 2025, 2:36 PM
![](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(188.79999999999998, 69%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAF%3C/text%3E%3C/svg%3E)
Alain Fricker
0
Reputation points
2 answers
Visual Studio 2019 (SSAS) - Error when trying to open my model
The backstory: I work with SSAS and a tabular model via a VDI. The connection with my VDI went wonky and now there is a disconnect involving my tabular model. I'm only trying to open my tabular model (.bim) via SSAS, and I keep getting the error that…
asked Aug 17, 2022, 10:03 PM
![](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(304, 12%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETY%3C/text%3E%3C/svg%3E)
Tanner Yatsko
11
Reputation points
commented Apr 10, 2025, 12:52 PM
![](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, 93%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Melissa Asher
0
Reputation points
2 answers
IP assignment on sql managed instance
How frequently Microsoft changes IP on sql managed instances? My understanding is that it is dynamic IP and can change anytime we are using custom DNS and need to make some dns entries - shall we create a private endpoint on sql managed instance and use…
asked Apr 9, 2025, 1:22 AM
![](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(278.4, 14.000000000000002%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAJ%3C/text%3E%3C/svg%3E)
Ankit Jain
0
Reputation points
answered Apr 10, 2025, 10:36 AM
![](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(211.20000000000002, 51%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKA%3C/text%3E%3C/svg%3E)
Khuloud Alkaf
5
Reputation points
0 answers
Why are query executed first blocked by update executed later
There are sessions 1-4, and session 1 is update, which is used to block the environment needed for other sessions to form. Symptom 1: Sessions 2 and 4 are select and 3 are update. 1-2-3-4 is executed in sequence. Once session 1 is terminated, I expect…
![](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(108.80000000000001, 66%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
0 answers
Error Encountered During Custom SQL Server Express 2022 Installation on Windows 10
While attempting to perform a custom installation of SQL Server Express 2022 on a Windows 10 64-bit laptop, an error is displayed: "SQL Server Setup encountered the following error: An exception was thrown by the destination of a call."…
asked Apr 9, 2025, 10:02 PM
![](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(51.2, 98%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERR%3C/text%3E%3C/svg%3E)
Rogério Abril
0
Reputation points
edited the question Apr 10, 2025, 3:52 AM
![](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, 11%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPM%3C/text%3E%3C/svg%3E)
Pradeep M
7,220
Reputation points Microsoft External Staff
1 answer
Certificate chain was issued by an authority that is not trusted. Error suddenly when loading into excel?
Hello all, With my credentials I can use and manipulate a database in SQL management studio. However, when I try to load that data into excel or PowerBI I receive the error (this previously worked for months):
asked Dec 22, 2022, 9:04 PM
![](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(204.8, 82%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Abigayle Paulson
1
Reputation point
commented Apr 9, 2025, 10:03 PM
Erland Sommarskog
120.2K
Reputation points MVP
1 answer
How to fetch full sql statement execution plan
Querying the sys.dm_exec_query_plan_stats.QUERY_PLAN results in a truncated version of the showplanxml How to get the full length ?
asked Apr 7, 2025, 7:02 AM
![](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, 14.000000000000002%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EID%3C/text%3E%3C/svg%3E)
Ivan Devloo
0
Reputation points
edited a comment Apr 9, 2025, 9:46 PM
Dan Guzman
9,371
Reputation points
1 answer
One of the answers was accepted by the question author.
Query Availability Group Permissions to CREATE ANY DATABASE
When configuring an availability group with automatic seeding, the secondary replicas must be given the following permission in order to automatically create/seed new databases. ALTER AVAILABILITY GROUP [????] GRANT CREATE ANY DATABASE Question:…
asked Aug 11, 2022, 3:55 PM
![](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(300.8, 53%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
Crain, Brett
31
Reputation points
edited a comment Apr 9, 2025, 9:27 PM
![](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(156.8, 96%, 25%)' 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)
ChadP
10
Reputation points
0 answers
SQL server is using high CPU
Hi, SQL server is using unusual high CPU. Trying updating stats and index reorganization, bt no help. SQL agent refresher is taking high CPU, please help. Thank you
![](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, 94%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
0 answers
SQL Server Reporting Services chrome http2_protocol_error
I have web app that display a report page in inframe. Lately I deploy app on Windows Server 2022. when I use Chrome(135.0.7049.85) i get err_http2_protocol_error. What is more, when in another tab I open Url to web portal and later refresh my page report…
asked Apr 9, 2025, 1:36 PM
![](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(236.8, 6%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERA%3C/text%3E%3C/svg%3E)
Roslan, Anna
0
Reputation points
edited the question Apr 9, 2025, 2:21 PM
Roslan, Anna
0
Reputation points
0 answers
How to fix connectivity timeout issue between azure function and azure sql server.
We are trying to connect to SQL database using azure function. We are facing a connectivity timeout issue. Below is the error message :- 4/7/2025, 4:10:22.220 PM An error occurred in updateDatabase: RequestError: Timeout: Request failed to complete in…
![](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, 12%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
0 answers
getting the below error while trying a run a python script present in azure data bricks workspace from adf pipeline
getting the below error while trying a run a python script present in azure data bricks workspace from adf pipeline and also the same error is being occurred when i run the script in a adb notebook as well Connecting to Database ... Database connection…
asked Apr 9, 2025, 1:57 PM
![](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, 19%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELS%3C/text%3E%3C/svg%3E)
Lakshmi Srinivas Pallapothu
0
Reputation points
asked Apr 9, 2025, 1:57 PM
Lakshmi Srinivas Pallapothu
0
Reputation points
0 answers
Type Cast Error
I am trying to write a derived column expression to check for year. We get a data file for employees for previous month in the current month and I am trying to tackle the year so when I get the file in January the year should be 2024 since I will get the…
0 answers
I am importing database from a bacpac file to one of sql server in Azure (PaaS). however the deployment failed. Can someone guide how to ensure the bacpac file under is accessible and what permissions need to be ser on the container or a storage account.
I am importing database from a bacpac file to one of sql server in Azure (PaaS). however the deployment failed. Can someone guide how to ensure the bacpac file under is accessible and what permissions need to be set on the container or a storage account.
asked Apr 9, 2025, 1:37 PM
![](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(108.80000000000001, 77%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Shoeb Shabibi
0
Reputation points
asked Apr 9, 2025, 1:37 PM
Shoeb Shabibi
0
Reputation points
1 answer
One of the answers was accepted by the question author.
I would like to know if connector is available for SAP BPC?
Hi Experts, I am working on solution development to ingest data from different SAP systems to ADLS Gen 2. I have selected ADF for the integration and could see ADF connectors available for SAP BW, HANA, C2C etc. However, I don't find any information…
asked Dec 18, 2023, 1:44 PM
![](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(284.8, 59%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Sivaramakrishnan S
20
Reputation points
commented Apr 9, 2025, 8:08 AM
![](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(6.4, 70%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
Gowtham Selvaraj
0
Reputation points
0 answers
How to clone database in SQL 2022?
My customer has SQL 2022 (16.0.1000.6) and a production database. To investigate performance of the database I need the db backup. But customer cannot provide it because of some tables contain sensitive data. I have tried to clone the db because it has…
asked Apr 9, 2025, 7:49 AM
![](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, 99%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOC%3C/text%3E%3C/svg%3E)
Oleg Cherkasenko
0
Reputation points
edited the question Apr 9, 2025, 7:53 AM
Oleg Cherkasenko
0
Reputation points
0 answers
Issue with Configuring SSRS on EC2 with RDS
Hello, I am currently working on setting up SQL Server Reporting Services (SSRS) on an Amazon RDS instance with an EC2 instance acting as the application client. Specifically, I want to store SSRS metadata in Amazon RDS while using the EC2 instance to…
![](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(73.60000000000001, 63%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
0 answers
Issue with SSL certificate after SQL SERVER SSRS UPGRADE
hi All Experts, looking for some help here, we have SQL SERVER and SSRS running under: Microsoft SQL Server 2017 (RTM-CU31-GDR) (KB5040940) - 14.0.3471.2 (X64) 2017 Microsoft Corporation Developer Edition (64-bit) on Windows Server 2016…
![](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(57.599999999999994, 75%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
1 answer
SQL Server Secondary
Please guide if we can keep an AlwaysON SQL Server secondary database in read write mode
asked Apr 8, 2025, 12:42 PM
![](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(192, 60%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
Vishu
1,716
Reputation points
answered Apr 8, 2025, 4:00 PM
Dan Guzman
9,371
Reputation points
0 answers
SQL Connection Issues from Power Bi tenant
Recent 2025 issues connecting to SQL Servers from Gateway Connections that were successful last week
asked Apr 8, 2025, 3:45 PM
![](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(275.2, 3%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Ritzinger, Michael W
0
Reputation points
asked Apr 8, 2025, 3:45 PM
Ritzinger, Michael W
0
Reputation points