Internet Information Services
Microsoft web server software.
1,578 questions
2 answers
SSL Redirect for SSRS 2019
I'm working with SSRS 2019. I think that I've determined that SSRS doesn't natively support a way to redirect HTTP to HTTPS. The workaround seems to be to remove port 80 from Report Server Configuration Manager and install IIS to handle port 80 traffic…
asked 2021-10-21T20:55:57.557+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(32, 44%, 13%)' 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)
Bob Singer
1
Reputation point
edited a comment 2024-04-24T22:10:23.39+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, 5%, 18%)' 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)
B T
0
Reputation points
1 answer
Dynamic data masking with deterministic values
I would like to check for data masking solution when reading data from a SQL Server database. To elaborate further, the data elements should be encrypted/masked when a set of users querying the tables. The data stored at rest should be clear (i.e.…
asked 2024-04-24T06:20:07.5333333+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(256, 52%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAR%3C/text%3E%3C/svg%3E)
Aravindhan Ravichandran
0
Reputation points
commented 2024-04-24T21:33:05.9333333+00:00
Erland Sommarskog
100.9K
Reputation points MVP
1 answer
VIEW SERVER STATE vs DB role for DMV on master
Hi, I have a logging procedure that reads from the two tables on master: sys.dm_exec_connections sys.dm_exec_sessions I had to assign permissions to a group for correct execution: GRANT VIEW SERVER STATE TO [domain\mygroup]; but I didn't want…
asked 2024-04-24T08:29:59.1+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, 60%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAC%3C/text%3E%3C/svg%3E)
Alen Cappelletti
891
Reputation points
answered 2024-04-24T21:28:20.9333333+00:00
Erland Sommarskog
100.9K
Reputation points MVP
1 answer
Syntax to PRINT the row counts using Dynamic SQL?
Hello, what would be the syntax to PRINT the row counts using Dynamic SQL (in my case here need to get the row counts via a Linked Server View) I would like to have this as a step in a SQL Agent job which after it runs it PRINTs the row counts in it's…
asked 2024-04-24T18:57:32.9433333+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, 45%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
techresearch7777777
1,766
Reputation points
commented 2024-04-24T21:24:10.3033333+00:00
Erland Sommarskog
100.9K
Reputation points MVP
1 answer
Row-level security in SQL server
In this scenario, I seek assistance in implementing row-level permissions for a table named 'user' with columns 'username' and 'role'. The objective is to establish a security model where access to individual rows is controlled based on the role assigned…
asked 2024-04-24T11:39:39.74+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(140.8, 16%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELC%3C/text%3E%3C/svg%3E)
Lộc Nguyễn
0
Reputation points
answered 2024-04-24T21:15:24.5566667+00:00
Erland Sommarskog
100.9K
Reputation points MVP
1 answer
SQL2022-SSEI-Expr setup file is not opening
I downloaded the express edition file from here :https://www.microsoft.com/en-us/sql-server/sql-server-downloads When I try to open it , the file dont open . dont know whats wrong with it. Need Help with the installation. TIA
asked 2024-04-24T12:17:54.3266667+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(124.80000000000001, 57.99999999999999%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
sakib rahman
0
Reputation points
answered 2024-04-24T21:04:42.8066667+00:00
Erland Sommarskog
100.9K
Reputation points MVP
0 answers
SQL SERVER IMPORT AND EXPORT WIZARD
I clicked on the next button to import my data from excel and it brings me this error message; TITLE: SQL Server Import and Export Wizard The operation could not be completed. ADDITIONAL INFORMATION: The 'Microsoft.ACE.OLEDB.16.0' provider is not…
asked 2024-04-24T13:50:36.61+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, 2%, 11%)' 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)
Mariam Wasiu
0
Reputation points
commented 2024-04-24T20:57:06.31+00:00
Erland Sommarskog
100.9K
Reputation points MVP
3 answers
One of the answers was accepted by the question author.
Locking comparison SQL Server 2017 versus SQL Server 2022
We upgraded from SQL Server 2017 to SQL Server 2022. With SQL Server 2022 we are experiencing a lot more and longer locks. When long lasting locks happens, a lot of process are getting suspended. As soon that the lock is resolved, the processes are like…
asked 2024-04-22T12:53:22.4133333+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, 18%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPT%3C/text%3E%3C/svg%3E)
Paolo Taverna
71
Reputation points
commented 2024-04-24T20:51:15.74+00:00
Erland Sommarskog
100.9K
Reputation points MVP
0 answers
Error loading report.rdlc,Unable to copy bin\debug\
Good afternoon again, I have already searched for information online, but I have not been able to find the error. The error is the following: An error occurred during local report processing. The report definition has not been specified, the file is not…
Windows Forms
Windows Forms
A set of .NET Framework managed libraries for developing graphical user interfaces.
1,827 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,798 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,233 questions
asked 2024-04-24T20:48:56.4066667+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(134.4, 18%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERC%3C/text%3E%3C/svg%3E)
Roberto Carlos Melgar Dorado
40
Reputation points
asked 2024-04-24T20:48:56.4066667+00:00
Roberto Carlos Melgar Dorado
40
Reputation points
0 answers
Using SSDT on a build server
I need to use SSDT on my build server. What exactly do need to install to get it working? I have a docker image that does the builds. It's based on mcr.microsoft.com/dotnet/framework/sdk:4.8-20230110-windowsservercore-ltsc2019Ideally, it would be nice…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,599 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.
12,690 questions
asked 2024-04-24T19:26:26.72+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(313.6, 95%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMD%3C/text%3E%3C/svg%3E)
Mark DeMichele
0
Reputation points
asked 2024-04-24T19:26:26.72+00:00
Mark DeMichele
0
Reputation points
3 answers
One of the answers was accepted by the question author.
Can I drop or disable the default NT Service Accounts from SSMS Logins?
The following accounts are automatically created upon SQL Server installation: NT SERVICE\SQLWriter NT SERVICE\Winmgmt NT SERVICE\MSSQLSERVER NT SERVICE\SQLSERVERAGENT If I am using a seperate domain account to use as SQL…
asked 2022-08-22T08:30:51.323+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(44.800000000000004, 23%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EML%3C/text%3E%3C/svg%3E)
Michelle Lopez Santos
41
Reputation points
commented 2024-04-24T15:31:16.3133333+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(313.6, 48%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELJ%3C/text%3E%3C/svg%3E)
Longstreet, James [USA]
1
Reputation point
2 answers
One of the answers was accepted by the question author.
VS 2022 ReportViewer Error: "The report cannot be displayed. The report viewer could not find a report definition."
Please help me with this problem I'm having. I'll start by explaining my problem: I need to load reports, and for that I'm using the native reports of VS 2022. Here's what I've done so far: I created my .xsd file called DataSetInformes.xsd I added my…
Windows Forms
Windows Forms
A set of .NET Framework managed libraries for developing graphical user interfaces.
1,827 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.
12,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,233 questions
asked 2024-04-23T16:21:18.7333333+00:00
Roberto Carlos Melgar Dorado
40
Reputation points
accepted 2024-04-24T14:52:18.47+00:00
Roberto Carlos Melgar Dorado
40
Reputation points
1 answer
SSRS report - image has phantom borders
I am showing an image in a table row. Image border is turned off, but it still shows some: Any idea why? Thanks
asked 2021-05-17T12:58:45.17+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(297.6, 17%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZ%3C/text%3E%3C/svg%3E)
Zolotoy
221
Reputation points
commented 2024-04-24T14:41:17.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(124.80000000000001, 81%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
John Sanger
0
Reputation points
0 answers
analysis services pivot taking a long time to refresh
We have an analysis services object that we connect in excel for pivot tables. This has been running fine for 3 years. IN the past month it is taking very long to refresh and also prevents anything else in Excel from being opened (even outlook). What…
asked 2024-04-24T14:37:25.1533333+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, 4%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETD%3C/text%3E%3C/svg%3E)
Tina Douglass
1
Reputation point
asked 2024-04-24T14:37:25.1533333+00:00
Tina Douglass
1
Reputation point
1 answer
One of the answers was accepted by the question author.
Ubuntu 22.04 - The install the ODBC driver error
Here is the result of the trying to build docker image with installing the ODBC driver: RUN apt-get update && ACCEPT_EULA=Y apt-get install -y msodbcsql18: 0.361 Hit:1 http://ports.ubuntu.com/ubuntu-ports jammy InRelease 0.440 Hit:2…
asked 2024-04-24T12:22:25.1866667+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(284.8, 54%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEG%3C/text%3E%3C/svg%3E)
Efim Gerasimov
0
Reputation points
commented 2024-04-24T13:53:52.8433333+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, 23%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVP%3C/text%3E%3C/svg%3E)
Vaibhav Patil
20
Reputation points
0 answers
Unable to import excel workbook into MSSQ.
I created a localdb through cmd via a youtube tutorial which allowed me to connect. i am in the mssql application and created my first database. I am wanting to import excel workbooks but the wizard is showing the below error message here, i checked…
![](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, 19%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
0 answers
Synapse Python/Spark Notebook code with SQL to query data from linked service to SQL Server
In Synpase, I have linked service to a SQL Server database. I'm looking for a sample notebook code, either in python or spark, that I can run a complex SQL qery within this code to get data from multiple SQL Server tables, put the rsults in a dataframe…
![](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, 27%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EY%3C/text%3E%3C/svg%3E)
1 answer
How to use SSL Wildcard Certificate in SSRS 2016
I am trying to use an SSL wildcard certificate in SSRS but so far I have no luck. I am able to access http://ServerName:80/ReportServer but not https://myReports.mycompany.com/ReportServer. The error I am getting is that the page cannot be displayed. Do…
asked 2020-08-18T01:18:30.25+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(60.8, 5%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
Eigh
1
Reputation point
commented 2024-04-24T13:39:32.6833333+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(307.2, 6%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYN%3C/text%3E%3C/svg%3E)
★Yevhen Nedashkivskyi - ALLSTARSIT
0
Reputation points
1 answer
how to fix this issue Msg 64, Level 20, State 0, Line 114 A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)
When I am trying to run two queries on same database but in different windows one query is doing deletion of a table from particular date ranges along with roll back mechanism and another query is doing fetching data by joining different tables based on…
asked 2024-04-24T08:07:29.2066667+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, 38%, 10%)' 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)
sharuk
0
Reputation points
answered 2024-04-24T13:17:47.2733333+00:00
Amira Bedhiafi
15,056
Reputation points
2 answers
Download link for Microsoft.ACE.OLEDB.12.0
We need the Microsoft.ACE.OLEDB.12.0 32 bit install, can someone please provide a link. We need the functionality to import excel files in via SSMS so the 32 bit driver is required
asked 2024-04-19T14:09:09.57+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, 68%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETD%3C/text%3E%3C/svg%3E)
Thomas Davies
0
Reputation points
edited a comment 2024-04-24T12:45:52.3933333+00:00
Mariam Wasiu
0
Reputation points