I am not sure on that one but the error is saying (based on google translate):

OSError WinError 10013 Access to a socket was not allowed due to the access rights...

Pretty sure putting the logins in the datareader role should handle this.

alternately, you could generate the script it with something like:

SELECT N'GRANT SELECT ON ' + name...

• This reply was modified 5 years, 7 months ago by Mr. Brian Gale. Reason: alternate option
• This reply was modified 5 years, 7 months ago by Mr. Brian Gale. Reason: fixing typo
• This reply was modified 5 years, 7 months ago by Mr. Brian Gale. Reason: added NOTE

As a guess on your data, it isn't returning multiple rows in the first select subquery.

I am guessing that in the table HumanResources.Employee, the BusinessEntityID column is unique.  So p.BusinessEntityID...

My understanding (experts correct me if I am wrong) is that if the conversion is potentially possible, but the conversion is invalid, then you get NULL.  If the conversion is...

If it was me, I would look at encrypting by certificate OR by passphrase.

To see some TSQL on it:

https://docs.microsoft.com/en-us/sql/t-sql/functions/encryptbypassphrase-transact-sql?view=sql-server-ver15

Use those examples but instead of displaying to screen, store it in...

To answer question number 2 about the folders, those are version numbers.  110 is 2012, 140 is 2017, 150 is 2019.

If you installed SSMS 18, it does not come with...

I think you need to change your query a little bit to something more like this:

CREATE FUNCTION [dbo].[LastBuyer1]
(@SC1 varchar(30))
RETURNS VARCHAR(3)
AS
BEGIN
DECLARE @LB VARCHAR(3);
WITH CTE AS
(SELECT TOP 1 Buyer,...

I was following this thread because I was curious about this too.  Thanks Anthony for the answer to it.

It also bring up the question, why would you want to restrict...

If you subnet mask is 255.255.255.0, then 1.2.3.x cannot see or talk to 1.2.4.x. with a subnet mask of 255.255.255.0 you can only communicate with 1.2.3.0 through 1.2.3.255.

I'd recommend reading...

• This reply was modified 5 years, 7 months ago by Mr. Brian Gale.

Thanks for posting back especially including the solution.

Good luck with the disasters.  Hopefully you do not have too many.

MAY have a solution to that:

https://bindujanga.blogspot.com/2016/03/sql-server-connectivity-issue.html

It isn't specific to SQL 2017, but may be something to look into.

To quote the article:

Windows server Event Log has many SChannel errors as below:

The...

I am thinking you are using the -o parameter and not the -i one (or possibly both), right?  -i is for an input file, -o is for output file.  Well,...

When you say multi-subnet, I am thinking that is a multi-VLAN setup, correct?

Communication across VLANs may require additional configuration to allow the communication.

If it is really multi-subnet, I am assuming...

My advice - try it and find out.

Having the site not secure when accessing it locally is likely because you are connecting to "https://localhost/reports_ssrs", right?  Connecting by server name should...

You can use a SSL certificate and HTTPS (ie port 443) with SSRS no problem.  SSC actually has a good tutorial on this:

https://www.sqlservercentral.com/articles/configure-ssrs-with-an-ssl-certificate

In that tutorial it explains how to use...