SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,759 questions
1 answer
The MSSQLSERVER service terminated unexpectedly
Dear All SQL expert, Do you know what is the case that make The MSSQLSERVER service terminated unexpectedly? Recently, The SQL server (MSSQLSERVER) and SQL Server Agent are stopped automatically during running import data to sql server. We are using…
![](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(41.6, 44%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
1 answer
SSRS Report ignoring the Data Source credentials it is given, while other reports use the credentials properly
I have an SSRS report deployed that works locally but not on the SSRS site. It is using a shared Data Source that has 40+ other reports using it as well. The issue is this report returns the following error: Query execution failed for dataset…
asked 2024-03-27T19:06:33.7833333+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(89.60000000000001, 28.999999999999996%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Shane Kelley
0
Reputation points
answered 2024-03-28T02:50:25.7533333+00:00
ZoeHui-MSFT
33,126
Reputation points
1 answer
One of the answers was accepted by the question author.
Filter Tablix with LIKE and OR
With SSRS, I need to filter a tablix with a LIKE and an OR condition. For example: WHERE MedCampaign LIKE AffCPD_1224* OR MedCampaign LIKE AffCPD_1225* I tried the below suggestion I found, but this just returns the entire dataset. How should I go about…
asked 2023-08-22T16:15:47.6533333+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, 23%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
Dom
751
Reputation points
commented 2024-03-27T18:25:08.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(54.400000000000006, 32%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAV%3C/text%3E%3C/svg%3E)
Alexandre Vieira (DIF)
0
Reputation points
1 answer
Unable to install SQL Server (setup.exe). Exit code (Decimal): -2061893607;Error description: could not find the database engine startup handle
I am trying to install sql server 2022 and I keep getting the same error: Unable to install SQL Server (setup.exe). Exit code (Decimal): -2061893607;Error description: could not find the database engine startup handle This is the error log that I…
asked 2024-03-26T18:31:35.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(262.40000000000003, 43%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJN%3C/text%3E%3C/svg%3E)
Jawahiir Nabhan
0
Reputation points
commented 2024-03-27T05:06:09.53+00:00
Jawahiir Nabhan
0
Reputation points
3 answers
has inline function got any catch?
hi, I heard many people saying "functions are denounced in tsql" is there any catch? q1) need to know what are the cases where we should not use? q2) should we avoid scaler functions also? q3) should we avoid scaler functions if we have to…
asked 2024-03-11T05:57:35.8533333+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(41.6, 42%, 14%)' 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)
Rajesh Kumar Yadav
0
Reputation points
answered 2024-03-26T17:11:52.99+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(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bruce (SqlWork.com)
56,846
Reputation points
2 answers
.NET 6.0 framwork SSRS Report Viewer.
Hi Team, I am using .Net 6.0 farmwork with MVC. Not able to bind Report viewer in razor pages. .Net 6.0 not supporting old packages and web forms. How to bind SSRS rdl in .Net 6.0 MVC framework. Kindly provide a solution with an example source…
asked 2023-09-05T14:43:03.99+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(89.60000000000001, 17%, 18%)' 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)
santhosh shekar
15
Reputation points
commented 2024-03-26T05:49:20.52+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(22.400000000000002, 13%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEE%3C/text%3E%3C/svg%3E)
esam elzain
0
Reputation points
8 answers
One of the answers was accepted by the question author.
SSRS Count rows in colmns to get the percentage
Hi I could do with some help in getting find the expression that will, Count the total number of Shipment_ID's in the column / by the number of 0 in GOOD_BAD_TIME * 100. to calculate the percentage. (Delivered on Time) Aim is to calculate the…
asked 2021-03-18T10:47:21.42+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(51.2, 31%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECW%3C/text%3E%3C/svg%3E)
Clive Wightman
126
Reputation points
accepted 2024-03-22T09:44:24.1+00:00
Clive Wightman
126
Reputation points
3 answers
One of the answers was accepted by the question author.
SSRS Sub Reports Not passing Paramteres
HI I'm Running SQL Server 2019, with Reporting Services. I'm creating a report that only has 4 sub reports within it. When I run the sub reports indiviually they work fine. When I run the report selecting multiple sub reports it fails, 2…
asked 2022-11-21T07:57:20.98+00:00
Clive Wightman
126
Reputation points
accepted 2024-03-22T09:43:27.2833333+00:00
Clive Wightman
126
Reputation points
1 answer
One of the answers was accepted by the question author.
SSRS with Database Sizes
Hi I'm trying to create a report that will show the size of the databases, but as we have 32GB available on the Azure Managed instance I would like to have a chart that shows the % we have used, could anyone help with this please. I'm gathering the…
asked 2024-01-09T10:25:14.22+00:00
Clive Wightman
126
Reputation points
accepted 2024-03-22T09:42:55.2933333+00:00
Clive Wightman
126
Reputation points
2 answers
HSTS for Default page on SSRS
Hi, Our SSRS server is failing a vulnerability (Nessus) scan for HSTS. I have been able to add the SQL CustomHeader for HSTS and I can confirm this is working. SQL CustomHeader XML string…
asked 2024-03-15T03:39:19.55+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(144, 38%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECG%3C/text%3E%3C/svg%3E)
Craig Garland
286
Reputation points
answered 2024-03-22T08:39:02+00:00
ZoeHui-MSFT
33,126
Reputation points
1 answer
One of the answers was accepted by the question author.
VS 2019 SSRS Report:Request for the permission of type 'System.Security.Permissions.FileIOPermission, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
Good Day, I have a SSRS report that must display an image on a particular file share. The exact name of the image is not known, however the file name is partially known. We have created custom code that is using System.IO functions to find the file…
asked 2024-03-20T08:53:25.4366667+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(240, 44%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMV%3C/text%3E%3C/svg%3E)
Martie van Staden
25
Reputation points
commented 2024-03-22T07:33:01.9766667+00:00
ZoeHui-MSFT
33,126
Reputation points
0 answers
SSRS on SharePoint: Check for Subscription failure issue
Hi all, I am dealing with an SSRS data-driven subscription failure issue. I am using SQL Server 2008 R2 with its reporting services run on SharePoint integration mode (in a SharePoint 2010 server): As shown above, this subscription instance generated 27…
asked 2024-03-22T07:06:44.1433333+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(57.599999999999994, 13%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
Norman K. F. Chow
75
Reputation points
asked 2024-03-22T07:06:44.1433333+00:00
Norman K. F. Chow
75
Reputation points
1 answer
One of the answers was accepted by the question author.
[Question] Recycle Time - SQL Server Reporting Services
From the RecycleTime article in SQL Server Reporting Services - The ASP.NET manages the recycle operation for the Web service and Report Manager. The current configuration is set to default recycle time which is 720 minutes. ‹Service› ... ... …
1 answer
SSRS CSV export issue
I have a SSRS report with dynamic column and also Column display order is getting handle through parameter "ColumnOrder". Once I generate the report it works fine and based on column order it display columns on report. Once I export it to CSV…
asked 2023-08-25T13:16:20.0366667+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(272, 69%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Arvind Singh Gusain
5
Reputation points
commented 2024-03-21T12:01:17.21+00:00
Arvind Singh Gusain
5
Reputation points
1 answer
SQL Server 2022 Kurulum Hatası
Microsoft SQL Server Geliştirici indirip 3. seçenekten Basic olanı seçtim. Ekran Görüntüsünde görüldüğü üzere bu hatayla karşılaştım.
asked 2024-03-14T09:35:38.1566667+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(83.2, 57.99999999999999%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKV%3C/text%3E%3C/svg%3E)
Kadir Veysel SAYAR
0
Reputation points
commented 2024-03-21T09:50:36.3466667+00:00
Kadir Veysel SAYAR
0
Reputation points
1 answer
Deploy rdl report from Visual Studio solution to PowerBI.
Is this possible? I know I can deploy to an on-prem report or Power BI server. I tried changing the settings in the project for the URL to a Power BI workspace then when I selected deploy I had to reauthenticate, that failed. Thanks for any guidance…
asked 2024-03-20T16:55:39.2033333+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(144, 42%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETT%3C/text%3E%3C/svg%3E)
Tim Toennies
0
Reputation points
answered 2024-03-21T01:36:46.3233333+00:00
ZoeHui-MSFT
33,126
Reputation points
3 answers
SSRS Report doesn't show anything unless I click View Report
Hello, I have a Visual Studio 2017 SSRS report with multiple parameter running perfectly fine against SQL Server 2017. But, when I deply the report and run it in the SQL Server Reporting Service portal, the report shows empty until I press enter! I have…
asked 2024-03-19T19:18:22.7866667+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, 28.999999999999996%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBK%3C/text%3E%3C/svg%3E)
Bikhod Khan
20
Reputation points
commented 2024-03-21T01:13:22.31+00:00
ZoeHui-MSFT
33,126
Reputation points
1 answer
Why did Microsoft deprecate the use of SSRS Models?
We recently moved an older SSRS 2005 server over to SSRS 2019 server but many of the reports created on SSRS 2005 used Models. Models are still supported in SSRS 2019 but there is NO way to edit or modify them. Microsoft provided NO conversion process…
asked 2024-03-19T17:01:19.05+00:00
Rob Ainscough
26
Reputation points
commented 2024-03-20T08:10:16.0933333+00:00
Amira Bedhiafi
15,676
Reputation points
3 answers
How do I configure Reporting Services on an Always-On cluster?
I need to install Reporting Services on an Always-On cluster with two nodes. Setting up the database is not a problem. I create the database using the listener address and then set up the Always-On availability group for it on the primary and use…
asked 2024-03-19T15:03:11.46+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, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERT%3C/text%3E%3C/svg%3E)
Reilly, Todd
0
Reputation points
answered 2024-03-20T06:02:06.9566667+00:00
Olaf Helper
40,901
Reputation points
1 answer
Why did SSRS move away from IIS?
My situation which doesn't have a solution since Microsoft removed IIS and went with internal Http.sys: I need to enable security via SSL/TLS on my SSRS server. I have 20 web apps that reference SSRS front end using HTTP, since SSRS doesn't use IIS I…
asked 2024-03-19T16:52:37.1333333+00:00
Rob Ainscough
26
Reputation points
answered 2024-03-20T05:57:54.0466667+00:00
ZoeHui-MSFT
33,126
Reputation points