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,915 questions
1 answer
SQL Reporting Services 2022 some users cannot export to PDF. It just hangs when exporting.
SQL Reporting Services 2022 some users cannot export to PDF. It just hangs when exporting. In our US offices there are no problems, in our UAE office there is a problem that the export does not work.
asked 2024-09-17T12:01:52.3466667+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(67.2, 24%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
Michael Perrien
0
Reputation points
answered 2024-09-18T02:12:35.9533333+00:00
ZoeHui-MSFT
36,116
Reputation points
2 answers
SQL license with package license
Hi team My company deployed a database server, and the vendor is using their legal license of MS SQL server. They said they use the package license, not single license. So I just want to ask can the data leaking happen on this case, if they try to…
asked 2024-09-16T11:33:16.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(86.4, 34%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHD%3C/text%3E%3C/svg%3E)
Hung, Duong Xuan
0
Reputation points
edited an answer 2024-09-18T02:00:58.46+00:00
CathyJi-MSFT
21,871
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Access Denied Error in SQL Server Snapshot Agent During Replication Setup
Hi, I'm trying to set up SQL Server Transactional Replication, but I'm encountering an "Access Denied" error during the Snapshot Agent's operation. The replication process is supposed to create a snapshot of the database, but it fails with…
asked 2024-08-24T17:41:58.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(233.6, 19%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
kevin stani
25
Reputation points
edited a comment 2024-09-18T01:39:44.6266667+00:00
CathyJi-MSFT
21,871
Reputation points Microsoft Vendor
0 answers
RMO error after upgrading SQL server from 2019 to 2022
This script works ok until SQL upgrade from SQL 2019 to SQL2022. I use it to get scripts of replication settings. Command: New-Object "Microsoft.SqlServer.Replication.ReplicationServer" $sqlserver Error: Could not load file or assembly…
asked 2024-09-10T22:09:43.6566667+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(195.2, 39%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWC%3C/text%3E%3C/svg%3E)
Wu, Clarissa
0
Reputation points
commented 2024-09-18T01:34:11.2466667+00:00
LucyChenMSFT-4874
4,430
Reputation points
2 answers
SQL and IIS server configuration for dot net MVC web app
I have windows server 2012 and IIS 8.5 and SQL server in same network in LAN. We are facing issue about API delayed response.
asked 2024-09-07T03:21:38.1666667+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(153.6, 68%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
Dayanand Sagar
0
Reputation points
commented 2024-09-18T01:33:49.2433333+00:00
LucyChenMSFT-4874
4,430
Reputation points
2 answers
How to fix this error, I can't the error in my SQL Server 2022.
How to solve this one please ? I can't install my SQL Server 2022 on my Laptop Windows 11
asked 2024-09-06T14:58:32.3066667+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, 25%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGJ%3C/text%3E%3C/svg%3E)
Gile, Joseph
0
Reputation points
commented 2024-09-18T01:33:25.8466667+00:00
LucyChenMSFT-4874
4,430
Reputation points
1 answer
I cannot install the SQL server developer version on my new laptop
I cannot install sql server data base engine services and couple of other sql services. It always giving me error. Below is the error details Feature failure reason: An error occurred for a dependency of the feature causing the setup process for the…
asked 2024-09-02T10:22:43.2+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, 76%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMN%3C/text%3E%3C/svg%3E)
Manswab Nechiyil
20
Reputation points
commented 2024-09-18T01:32:48.7733333+00:00
LucyChenMSFT-4874
4,430
Reputation points
2 answers
Using IDENTITY_INSERT with FK_ChildTable_ParentTable?
Hello, Wrapping SaveChanges with ON and OFF works fine with individual tables. But not in case of a parent-child relationship where a foreign key exists. Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot insert explicit value for identity column…
Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
736 questions
ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,526 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,690 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,858 questions
asked 2024-09-16T22:33:43.8366667+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, 43%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
Joyce
80
Reputation points
answered 2024-09-17T21:20:25.1766667+00:00
Erland Sommarskog
110.4K
Reputation points MVP
1 answer
I got an error that I cannot connect to SQL while demoing olap.Help me repair this error,please.
I got an error that I cannot connect to SQL while demoing olap. I cannot connect to SQL and it asks me to enter "user id" and "password"
asked 2024-09-14T09:11:58.3833333+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(64, 43%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVT%3C/text%3E%3C/svg%3E)
võ thị tuyết ngân
20
Reputation points
commented 2024-09-17T20:52:32.24+00:00
Erland Sommarskog
110.4K
Reputation points MVP
1 answer
I got an error that I cannot connect to SQL while demoing olap.Help me repair this error,please.
I got an error that I cannot connect to SQL while demoing olap. I cannot connect to SQL and it asks me to enter "user id" and "password"
asked 2024-09-14T09:11:58.3833333+00:00
võ thị tuyết ngân
20
Reputation points
commented 2024-09-17T20:52:32.24+00:00
Erland Sommarskog
110.4K
Reputation points MVP
0 answers
Azure SQL database restore to Synapse
we need to do restore sql server database from restore point to dedicated sql pool on synapse on same resource group we are trying to do restore azure sql server db on same restore group where we have synapse but it ends up with error ERROR1.JPG Command…
asked 2024-09-11T14:01:57.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(48, 80%, 14%)' 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)
Andrea Galardi
0
Reputation points
commented 2024-09-17T16:00: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(9.6, 34%, 10%)' 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)
Priv - Molly Vander Velde
0
Reputation points
6 answers
Access is denied while connecting SSIS
Hello, While trying to connect SSIS 2019, I am getting below error.. Connecting to the Integration Services service on the computer "localhost" failed with the following error: "Access is denied." By default, only administrators have…
asked 2024-03-21T07:29:41.4466667+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(12.8, 21%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBH%3C/text%3E%3C/svg%3E)
Bilal H. Bhatt
116
Reputation points
commented 2024-09-17T15:21:56.1733333+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, 98%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Victor Savinescu
0
Reputation points
3 answers
One of the answers was accepted by the question author.
Can we install SQL Server Developer Edition in our Non-Production Environment, which will save some licensing cost?
We are already a SQL Server shop with more than 1200+ instances using Enterprise and Standard Edition for our Production and Non-Production environment. For our Non-Production environment can we install SQL Server Developer Edition. Is it possible to…
asked 2020-10-13T00:06:22.017+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(118.4, 71%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKD%3C/text%3E%3C/svg%3E)
Krishna Deepak (KD)
26
Reputation points
commented 2024-09-17T14:18:42.63+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(153.6, 40%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Christopher Shannon
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Best way to migrate SQL2017 nonclustered ReadScale to a true WSFC AOAG
We have a SQL2017 Enterprise Edition server that was setup without clustering with a Read Scale AG copy of DB's to another server. What is the best way to convert this to a true HA Availability Group with WSFC primary and secondary replicas? At this…
asked 2024-09-16T20:14:57.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(16, 79%, 11%)' 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)
Jac Thiessen
20
Reputation points
accepted 2024-09-17T12:58:20.0033333+00:00
Jac Thiessen
20
Reputation points
3 answers
One of the answers was accepted by the question author.
SQL SERVER 2022 INSTALLATION ERROR 1639
I was attempting to reinstall SQL Server, after an installation error occurred from when I had originally installed it. I've tried uninstalling all other remanents of the previous installation but I keep getting this error. I also managed to create one…
asked 2023-04-30T22:33:58.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(51.2, 59%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
Janice Chan
30
Reputation points
commented 2024-09-17T10:07:04.5266667+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(112.00000000000001, 92%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EME%3C/text%3E%3C/svg%3E)
Majd Eddin Alabed
0
Reputation points
3 answers
Way to optimize query where no union needed
I had to use union on two very similar queries where one is just a copy of the other but the having clause is equal with an additional condition in the where clause. Is there a way to clean up the code? DECLARE @PO_DATE_FROM date = '2024-09-08',…
asked 2024-09-10T19:56:39.0933333+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, 82%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Jonathan Brotto
400
Reputation points
commented 2024-09-17T08:53:22.6933333+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(169.60000000000002, 33%, 26%)' 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)
Rodger Kong
0
Reputation points
3 answers
Way to optimize query where no union needed
I had to use union on two very similar queries where one is just a copy of the other but the having clause is equal with an additional condition in the where clause. Is there a way to clean up the code? DECLARE @PO_DATE_FROM date = '2024-09-08',…
asked 2024-09-10T19:56:39.0933333+00:00
Jonathan Brotto
400
Reputation points
commented 2024-09-17T08:53:22.6933333+00:00
Rodger Kong
0
Reputation points
1 answer
One of the answers was accepted by the question author.
SSAS - TMSL Query and Monthly Partition , how to add Filter
Hello Experts, Trust you are all are doing good. Having following environments, one SQL server for DWH and another Enterprise Edition of SSAS hosting Tabular model(TM). DWH design is Star Schema based, where the fact table would receive roughly 1 million…
asked 2024-09-15T05:21:37.1933333+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, 19%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
PANDEY Prashant
105
Reputation points
accepted 2024-09-17T07:03:06.9133333+00:00
PANDEY Prashant
105
Reputation points
1 answer
One of the answers was accepted by the question author.
SSAS - TMSL Query and Monthly Partition , how to add Filter
Hello Experts, Trust you are all are doing good. Having following environments, one SQL server for DWH and another Enterprise Edition of SSAS hosting Tabular model(TM). DWH design is Star Schema based, where the fact table would receive roughly 1 million…
asked 2024-09-15T05:21:37.1933333+00:00
PANDEY Prashant
105
Reputation points
accepted 2024-09-17T07:03:06.9133333+00:00
PANDEY Prashant
105
Reputation points
3 answers
One of the answers was accepted by the question author.
Queries in the same window for multiple databases, servers, and tables
I was wondering in SSMS in the query window could I write multiple queries that use different servers, databases, and tables? A compounded question and answer I am expecting for this.
asked 2024-09-16T13:02:52.5733333+00:00
Jonathan Brotto
400
Reputation points
answered 2024-09-16T21:45:55.07+00:00
Erland Sommarskog
110.4K
Reputation points MVP