SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,377 questions
3 answers
Transient error in SSRS reports.
When we open a report in SSRS web service url it sometimes fails with the below error. When the same report is opened in web portal url with the same account, it opens with no errors. If we open an SSMS session with the same user and run any stored…
asked 2025-01-22T05:16:44.49+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(294.40000000000003, 41%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENR%3C/text%3E%3C/svg%3E)
Nivedita Rao
0
Reputation points
commented 2025-01-27T06:01:35.3666667+00:00
Nivedita Rao
0
Reputation points
0 answers
SSRS Report Server Connection refused
Hello, i have trouble with SSRS, when i try to connect on the local Server via http://localhost/reports or http://localhost/reportserver the connection is refused. On the machine there are SQL Server2022 and SSRS 2022 installed. I checked the services…
asked 2025-01-24T10:22:22.87+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(268.8, 18%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMW%3C/text%3E%3C/svg%3E)
Martin Wegner
0
Reputation points
edited the question 2025-01-24T12:30:10.0733333+00:00
Martin Wegner
0
Reputation points
2 answers
Installed Software Inventory Count without being broken up by version information SCCM
Installed Software Inventory Count without being broken up by version information SCCM
asked 2025-01-23T17:59:40.9466667+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(278.4, 57.00000000000001%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDJ%3C/text%3E%3C/svg%3E)
Denning, James
0
Reputation points
edited an answer 2025-01-24T06:27:28.45+00:00
AllenLiu-MSFT
47,626
Reputation points Microsoft Vendor
0 answers
extensionfactory!ReportManager_0-13!5100!01/24/2025-08:59:30:: w WARN: The extension Report Server Email does not have a LocalizedNameAttribute. extensionfactory!ReportManager_0-13!5100!01/24/2025-08:59:30:: w WARN: The extension Report Server FileShare d
extensionfactory!ReportManager_0-13!5100!01/24/2025-08:59:30:: w WARN: The extension Report Server Email does not have a LocalizedNameAttribute. extensionfactory!ReportManager_0-13!5100!01/24/2025-08:59:30:: w WARN: The extension Report Server FileShare…
asked 2025-01-24T05:55:20.9466667+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(102.4, 82%, 19%)' 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)
Shubham Sunil Mehetre-MIBS
0
Reputation points
asked 2025-01-24T05:55:20.9466667+00:00
Shubham Sunil Mehetre-MIBS
0
Reputation points
3 answers
Export SSRS report from 2207 to a new 2409
I am trying to export custom reports from an old site and bring them into the new site, what would be the best option to do so?
asked 2025-01-17T17:20:12.6766667+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, 70%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Belgian Malinois
421
Reputation points
answered 2025-01-23T14:28:46.1766667+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, 19%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
Garth
806
Reputation points
1 answer
One of the answers was accepted by the question author.
What will be the REST API URL for the SSRS to be embedded in the Blazor Server Application?
I am working on adding the SSRS based reports into the Blazor Sever Application. SSRS Configuration is working fine and I can access SSRS on browser as well. I searched for different methods to implement the SSRS reports (created using MS Report…
asked 2025-01-22T10:49:43.2466667+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(150.4, 53%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Aima Maqsood
25
Reputation points
edited an answer 2025-01-23T07:56:44.1466667+00:00
ZoeHui-MSFT
40,051
Reputation points
2 answers
How to export from SSRS some blank columns in a report that user will be entering data into appear as text?
Currently, the exported Excel columns are of type General and when user enters values like 06-71, iit converts it to a date format. However, it should be treated as text and remain as is.
asked 2025-01-22T23:47:43.7+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(265.6, 70%, 35%)' 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)
Manveet Kaur
0
Reputation points
answered 2025-01-23T06:26:52.0333333+00:00
Olaf Helper
45,776
Reputation points
1 answer
One of the answers was accepted by the question author.
Get month name in report
How to get current month name in SSRS report？For today i want to get the value like January
asked 2025-01-22T08:16:45.3+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, 96%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ2%3C/text%3E%3C/svg%3E)
Jefferson-2765
586
Reputation points
accepted 2025-01-23T06:05:47.9233333+00:00
Jefferson-2765
586
Reputation points
1 answer
Configuration Manager Notification SQL version
CM v2403. Why does "Configuration Manager Notification" warn us that we need to update "SQL" if our installation is version 2019 ? https://go.microsoft.com/fwlink/?linkid=2280831 Is anyone else receiving this notification despite…
![](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, 24%, 10%)' 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)
2 answers
Can SSRS 2022 Developer edition will be installed with SQL Server 2019 standard edition?
We would like to know: Can we install the SSRS 2022 developer edition with SQL Server 2019 Standard Edition? We have SQL server 2016 standard edition license already procured, Can we use the same to install the SSRS 2022 standard edition?
asked 2025-01-22T09:18:00.22+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(294.40000000000003, 44%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
Chirag Maheshwari
0
Reputation points
commented 2025-01-22T10:58:55.58+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, 38%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERG%3C/text%3E%3C/svg%3E)
Ravi Garg
0
Reputation points
6 answers
One of the answers was accepted by the question author.
AdventureWorksDW2020 DB is missing a table
Hi, I'm trying to go through the PowerBI lab at this url: https://learn.microsoft.com/en-gb/learn/modules/get-data/lab-prepare I downloaded the AdventureWorksDW2020 from GitHub and loaded into SQL server management studio. 6 tables are…
asked 2020-10-18T18:54:21.503+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(230.39999999999998, 90%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPO%3C/text%3E%3C/svg%3E)
Philip O'Donnell
26
Reputation points
answered 2025-01-21T14:55:54.0433333+00:00
Scott Hay
15
Reputation points
2 answers
One of the answers was accepted by the question author.
How can DomainA user acces DomainB SSRS?
Hi all, I got a problem with SSRS. I run an SQL server on DomainA but I would like to let some DomainB users read the reports. Is it possible? If it is, the how can i do it?
![](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(12.8, 1%, 11%)' 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)
1 answer
barcode 3 of 9 spacing issue in ssrs
When using barcode 3 of 9 font format in ssrs, we are getting extra spaces in between. Working fine in lower environment but getting a space after each underlying number in production environment when trying to Print Preview. Scan not working with RF…
asked 2025-01-20T17:08:24.91+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(208, 94%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
Naga Sasikanth Pendurthi
0
Reputation points
answered 2025-01-21T02:24:25.56+00:00
ZoeHui-MSFT
40,051
Reputation points
6 answers
SSRS 2019 failed to Generate Reports after installed to Windows Server 2019
Hello, I have got a problem to generate SSRS reports from SSRS 2019 on Windows Server 2019, but it starts to work after installed SSRS 2019 to Windows Server 2016. Here is the exception messages: [2021-01-19 12:26:23Z] [ERR] Report generation task…
asked 2021-01-19T14:38:58.673+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(291.2, 28.000000000000004%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPF%3C/text%3E%3C/svg%3E)
Pengxin Fan
116
Reputation points
answered 2025-01-20T16:49:02.89+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(19.2, 75%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Aurore Guéninchault
0
Reputation points
2 answers
One of the answers was accepted by the question author.
I would like to have capability to design reports in SSRS. What is the license I need?
I would like to have capability to design reports in SSRS. What is the license I need?
asked 2025-01-20T15:37:43.2633333+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(304, 9%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Sakis Balanis
20
Reputation points
accepted 2025-01-20T15:45:21.37+00:00
Sakis Balanis
20
Reputation points
2 answers
How to login the SQL server authentication?
I can only access my database via the SQL Database Query Editor via the "Microsoft Extra Authentication". I tried logging in using the "SQL server authentication" but that doesn't allow me to do so. Question: Where do I generate or…
asked 2025-01-17T18:34:44.3566667+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(6.4, 64%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBT%3C/text%3E%3C/svg%3E)
Brian Thomas
0
Reputation points
answered 2025-01-20T02:34:53.3333333+00:00
ZoeHui-MSFT
40,051
Reputation points
1 answer
Can an SSRS cumulative update (15.0.9098.6826) be rolled back or uninstalled without uninstalling SSRS?
If an SSRS cumulative update has been installed on a server, such as 15.0.9098.6826, 2025/01/06, is there any way to uninstall it or roll it back to the previous version without completely uninstalling SSRS? Obviously, some sort of system restore point…
asked 2025-01-14T20:19:55.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(86.4, 53%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHS%3C/text%3E%3C/svg%3E)
Harry Sauers
0
Reputation points
answered 2025-01-15T02:17:55.88+00:00
ZoeHui-MSFT
40,051
Reputation points
2 answers
One of the answers was accepted by the question author.
How do I lock files in a Git repository to prevent others from working on the same file?
Hello, I'm very new to Azure DevOps, and I've used TFS for version control in the past for our .rdl files. Now we are using Git in Azure DevOps for source control. I have a repository with several files that will be used by more than one developer. We…
asked 2021-10-19T15:37:46.01+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(198.4, 37%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETA%3C/text%3E%3C/svg%3E)
Tezino, Angelique
21
Reputation points
commented 2025-01-14T20:02:17.4933333+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(227.2, 6%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Randall Spychalla
0
Reputation points
1 answer
SSRS2022 Custom Header Problem
Hi Guys, I found SSRS2022 16.0.1116.12 Custom Headers…
asked 2025-01-07T02:59:18.05+00:00
Wilson Shen
0
Reputation points
commented 2025-01-14T06:16:47.55+00:00
Wilson Shen
0
Reputation points
1 answer
Measure grand total
Hi community, I work with report builder, I trying to calculate grand total, but I don't make a correct calculation. The Source is actually semantic model in power bi service, I have on semantic model this dimensions: Country, City and measures : stock,…
asked 2025-01-13T20:35:23.1966667+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, 8%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPQ%3C/text%3E%3C/svg%3E)
Pedro Quiroz
0
Reputation points
commented 2025-01-14T05:36:13.6366667+00:00
ZoeHui-MSFT
40,051
Reputation points