https://github.com/Microsoft/Reporting-Services/tree/master/CustomSecuritySample

Reporting Services Custom Security Sample for Power BI Report Server and SQL Reporting Services 2017

Synopsis

Custom Authentication in SSRS and Power BI Report Server

What Changed?

public void GetUserInfo(IRSRequestContext requestContext, out IIdentity userIdentity, out IntPtr userId)
    {
        userIdentity = null;
        if (requestContext.User != null)
        {
            userIdentity = requestContext.User;
        }
        
        // initialize a pointer to the current user id to zero
        userId = IntPtr.Zero;
   }

Implementation

Step 1: Creating the UserAccounts Database

• To create the UserAccounts database
• Open SQL Server Management Studio, and then connect to your local instance of SQL Server.
• Locate the Createuserstore.sql SQL script file. The script file is contained within the sample project files.
• Run the query to create the UserAccounts database.
• Exit SQL Server Management Studio.

Step 2: Building the Sample

• Open a Microsoft Visual Studio prompt and point to .Net Framework 4.0.
• Use the change directory command (CD) to change the current directory of the command prompt window to the folder where the project is saved.
• At the command prompt, run the following command to generate the key file: sn -k SampleKey.snk .

• Open CustomSecuritySample.sln in Microsoft Visual Studio.
• In Solution Explorer, select the CustomSecuritySample project.
• Look at the CustomSecuritySample project's references. If you do not see Microsoft.ReportingServices.Interfaces.dll, then complete the following steps:
• On the Project menu, click Add Reference. The Add References dialog box opens.
• Click the .NET tab.
• Click Browse, and find Microsoft.ReportingServices.Interfaces on your local drive. By default, the assembly is in the <install>\ReportServer\bin directory. Click OK. The selected reference is added to your project.
• On the Build menu, click Build Solution.

Step 3: Deployment and Configuration

• Copy the Logon.aspx page to the <install>\ReportServer directory.
• Copy Microsoft.Samples.ReportingServices.CustomSecurity.dll and Microsoft.Samples.ReportingServices.CustomSecurity.pdb to the <install>\ReportServer\bin directory.
• Copy Microsoft.Samples.ReportingServices.CustomSecurity.dll and Microsoft.Samples.ReportingServices.CustomSecurity.pdb to the <install>\Portal directory.
• Copy Microsoft.Samples.ReportingServices.CustomSecurity.dll and Microsoft.Samples.ReportingServices.CustomSecurity.pdb to the <install>\PowerBI directory. (This only needs to be done for Power BI Report Server.)

• To modify the RSReportServer.config file.
  
• Open the RSReportServer.config file with Visual Studio or a simple text editor such as Notepad. RSReportServer.config is located in the <install>\ReportServer directory.
  
• Locate the <AuthenticationTypes> element and modify the settings as follows:
  

  <Authentication>
   <AuthenticationTypes> 
    <Custom/>
   </AuthenticationTypes>
   <RSWindowsExtendedProtectionLevel>Off</RSWindowsExtendedProtectionLevel>
   <RSWindowsExtendedProtectionScenario>Proxy</RSWindowsExtendedProtectionScenario>
   <EnableAuthPersistence>true</EnableAuthPersistence>
  </Authentication>

• Locate the <Security> and <Authentication> elements, within the <Extensions> element, and modify the settings as follows:
  

  <Security>
   <Extension Name="Forms" Type="Microsoft.Samples.ReportingServices.CustomSecurity.Authorization, Microsoft.Samples.ReportingServices.CustomSecurity" >
   <Configuration>
    <AdminConfiguration>
     <UserName>username</UserName>
    </AdminConfiguration>
   </Configuration>
   </Extension>
  </Security>

  <Authentication>
   <Extension Name="Forms" Type="Microsoft.Samples.ReportingServices.CustomSecurity.AuthenticationExtension,Microsoft.Samples.ReportingServices.CustomSecurity" />
  </Authentication> 

• You will need to add a code group for your custom security extension that grants FullTrust permission for your extension. You do this by adding the code group to the RSSrvPolicy.config file.
  
• Open the RSSrvPolicy.config file located in the <install>\ReportServer directory.
  
• Add the following <CodeGroup> element after the existing code group in the security policy file that has a URL membership of $CodeGen as indicated below and then add an entry as follows to RSSrvPolicy.config. Make sure to change the below path according to your ReportServer installation directory:
  

  <CodeGroup
   class="UnionCodeGroup"
   version="1"
   Name="SecurityExtensionCodeGroup" 
   Description="Code group for the sample security extension"
   PermissionSetName="FullTrust">
  <IMembershipCondition 
   class="UrlMembershipCondition"
   version="1"
   Url="C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\bin\Microsoft.Samples.ReportingServices.CustomSecurity.dll"/>
  </CodeGroup>

• Open the Web.config file in a text editor. By default, the file is in the <install>\ReportServer directory.
  
• Locate the <identity> element and set the Impersonate attribute to false.
  

  <identity impersonate="false" />

• Locate the <authentication> element and change the Mode attribute to Forms. Also, add the following <forms> element as a child of the <authentication> element and set the loginUrl, name, timeout, and path attributes as follows:
  

  <authentication mode="Forms">
   <forms loginUrl="logon.aspx" name="sqlAuthCookie" timeout="60" path="/"></forms>
  </authentication> 

• Add the following <authorization> element directly after the <authentication> element.
  

  <authorization> 
  <deny users="?" />
  </authorization> 

Step 4: Generate Machine Keys

<MachineKey ValidationKey="[YOUR KEY]" DecryptionKey="[YOUR KEY]" Validation="AES" Decryption="AES" />

Step 5: Configure Passthrough cookies

<UI>
   <CustomAuthenticationUI>
      <PassThroughCookies>
         <PassThroughCookie>sqlAuthCookie</PassThroughCookie>
      </PassThroughCookies>
   </CustomAuthenticationUI>
</UI>

SQL Report Server: No DSN present in configuration file

1. Open the Reporting Services Configuration Manager
2. Go to the Database section in the Menu and add a database to be used by the Reporting service
3. On the same page enter the Reporting database credential
4. Go to the web service url and specify the name of a virtual directory and a TCP port to be used. Do not use a port that is already in use, e.g port 80 may be already used by Sharepoint or MIM Portal.
5. Go to the reportmanager url and specify a virtual directory name to be used.

var file1;
            if (document.getElementById("inputFile").files.length > 0) {
                file1 = document.getElementById("inputFile").files[0];


                var reader = new FileReader();
                reader.readAsDataURL(file1);
                var image;
                reader.onloadend = function (e) {
                    var Image64= e.target.result;
                 // post to server
                   

                }
            }

 public class FileInputModel
    {
        public IFormFile FileToUpload { get; set; }
        public string UserId { get; set; }
    }

API Class

For AngularJs :

Jquery

Welcome to the FIK.DAL wiki!

This Library develop  for reducing to write simple query which is need to write frequently, when developing an
application.
A Simple SQL Query Generator Using ADO.NET Provider with SqlClient. Some Developer want's to develop through own query, rather then entity framework. Then it is useful to reduce query generation task.

For Cmd

For PowerShell version of the script

        public static Result POSTFormData(string url, string identifier, string FormData)
        {
            // Setup the POST data
            //string poststring = String.Format("qrCodeData=90320388203195564382");
            Result result = new Result();
            try
            {

                HttpWebRequest httpRequest = (HttpWebRequest)WebRequest.Create(url);

                httpRequest.Method = "POST";
                httpRequest.ContentType = "application/x-www-form-urlencoded";
                httpRequest.Headers.Add("secret", identifier);


                // Convert the post string to a byte array
                byte[] bytedata = System.Text.Encoding.UTF8.GetBytes(FormData);
                httpRequest.ContentLength = bytedata.Length;

                // Create the stream
                Stream requestStream = httpRequest.GetRequestStream();
                requestStream.Write(bytedata, 0, bytedata.Length);
                requestStream.Close();

                // Get the response from remote server
                HttpWebResponse httpWebResponse = (HttpWebResponse)httpRequest.GetResponse();
                Stream responseStream = httpWebResponse.GetResponseStream();

                System.Text.StringBuilder sb = new System.Text.StringBuilder();
                using (StreamReader reader = new StreamReader(responseStream, System.Text.Encoding.UTF8))
                {
                    string line;
                    while ((line = reader.ReadLine()) != null)
                    {
                        sb.Append(line);
                    }
                }

                result.ResultState = true;
                result.JsonString = sb.ToString();

            }
            catch (Exception ex)
            {
                result.ResultState = false;
                result.SqlError = ex.Message;
            }

            return result;
        }



            object theImg = dt.Rows[0]["Picture"];
if (!DBNull.Equals(theImg, DBNull.Value) && ((byte[])theImg).Length > 0)
            {
                 pictureBox1.BackgroundImage = new ImageHelper().ByteToImage((byte[])theImg);
}

    public class ImageHelper
    {
        public byte[] ImageToByte(Image imageIn)
        {

            MemoryStream ms = new MemoryStream();
            imageIn.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
            return ms.ToArray();
        }

        public Image ByteToImage(byte[] byteArrayIn)
        {
            MemoryStream ms = new MemoryStream(byteArrayIn);
            Image returnImage = Image.FromStream(ms);
            return returnImage;
        }

        public Image GenerateThumbnailImage(string imgUrl)
        {
            Image imgThumb = null;
            try
            {
                Image image = null;
                if (imgUrl != String.Empty)
                    image = Image.FromFile(imgUrl);

                if (image != null)
                {
                    imgThumb = image.GetThumbnailImage(130, 170, null, new IntPtr());
                    //this.Refresh();
                }
                return imgThumb;
            }
            catch
            {              
                return imgThumb;
            }
        }

    }

DECLARE @sql NVARCHAR(MAX) = N'EXEC ShopMenu_GermanClub.dbo.SP_ReportRM_PO_Challan ww,admin,Y;';

--SELECT name, system_type_name
--    FROM sys.dm_exec_describe_first_result_set(@sql, NULL, 1) AS col


declare @TableName sysname = 'SP_ReportRM_PO_Challan'
declare @Result varchar(max) = 'public class ' + @TableName + '
{'

select @Result = @Result + '
    public ' + ColumnType + NullableSign + ' ' + ColumnName + ' { get; set; }
'
from
(
    select
        replace(col.name, ' ', '_') ColumnName,
       
        case --col.system_type_name
            WHEN (CHARINDEX('nvarchar',system_type_name)>0) then 'string'
            when (system_type_name='bigint') then 'long'
            when (system_type_name='binary') then 'byte[]'
            when (system_type_name='bit') then 'bool'
            when (system_type_name='char') then 'string'
            when (system_type_name='date') then 'DateTime'
            when (system_type_name='datetime') then 'DateTime'
            when (system_type_name='datetime2') then 'DateTime'
            when (system_type_name='datetimeoffset') then 'DateTimeOffset'
            when (CHARINDEX('decimal',system_type_name)>0) then 'decimal'
            when (system_type_name='float') then 'float'
            when (system_type_name='image') then 'byte[]'
            when (system_type_name='int') then 'int'
            when (system_type_name='money') then 'decimal'
            when (system_type_name='nchar') then 'string'
            when (system_type_name='ntext') then 'string'
            when (CHARINDEX('numeric',system_type_name)>0) then 'decimal'
            when (system_type_name='real') then 'double'
            when (system_type_name='smalldatetime') then 'DateTime'
            when (system_type_name='smallint') then 'short'
            when (system_type_name='smallmoney') then 'decimal'
            when (system_type_name='text') THEN 'string'
            when (system_type_name='time') then 'TimeSpan'
            when (system_type_name='timestamp') then 'DateTime'
            when (system_type_name='tinyint') then 'byte'
            when (system_type_name='uniqueidentifier') then 'Guid'
            when (system_type_name='varbinary') then 'byte[]'
            when (system_type_name='varchar') then 'string'
            ELSE ('UNKNOWN_') + col.system_type_name
        end ColumnType,
        case
            when col.is_nullable = 1 and col.name in ('bigint', 'bit', 'date', 'datetime', 'datetime2', 'datetimeoffset', 'decimal', 'float', 'int', 'money', 'numeric', 'real', 'smalldatetime', 'smallint', 'smallmoney', 'time', 'tinyint', 'uniqueidentifier')
            then '?'
            else ''
        end NullableSign
    -- name, system_type_name
    FROM sys.dm_exec_describe_first_result_set(@sql, NULL, 1) AS col

) t
--order by ColumnId

set @Result = @Result  + '
}'

print @Result