SqlRS DefaultConfiguration
{
InstanceName = "SSRS"
DatabaseServerName = $env:COMPUTERNAME
DatabaseInstanceName = $AllNodes.InstanceName
ReportServerVirtualDirectory = $AllNodes.VirtualDirectory
ReportsVirtualDirectory = $AllNodes.ReportsVirtualDirectory
ReportServerReservedUrl = @("http://+:80", "https://+:443")
ReportsReservedUrl = @("http://+:80", "https://+:443")
DependsOn = "[SqlRSSetup]InstallReportingServices"
}
SqlRS ConfigureReportingServiceInstance
{
InstanceName = "SSRS"
DatabaseServerName = $env:COMPUTERNAME
DatabaseInstanceName = $AllNodes.InstanceName
DependsOn = "[SqlRSSetup]InstallReportingServices"
}
USE master
go
DECLARE @OriginalSID varchar(32);
DECLARE @ccount tinyint;
DECLARE @FormattedSID varchar(500);
DECLARE @username varchar(500) = 'SVC_TRN_User';
SELECT @OriginalSID = LOWER(REPLACE (CONVERT(VARCHAR(1000), SUSER_SID (@username), 1), '0x', ''));
SET @FormattedSID = @OriginalSID
SET @ccount = 1
WHILE @ccount < 33
BEGIN
SET @FormattedSID = '"0x' + SUBSTRING(@OriginalSID,@ccount,2) + '",'
SET @ccount = @ccount + 2
print @FormattedSID
END