I want exact this section style but I am unable to add frame around it. Could you please help me? Here is my code snippet :

documentclass[10pt,a4paper,twoside]report
usepackageblindtext
usepackagetitlesec, blindtext, color
definecolorseccolorRGB41,48,57
newcommandhsphspace8pt
titleformatsection[hang]Largebfseriesthesectionhsptextcolorseccolorhsp0ptLargebfseries

begindocument
 sectionSection Name
 blindtext
enddocument

You can have it with TikZ and explicit option of titlesec:

documentclass[10pt,a4paper,twoside]report
usepackageblindtext
usepackage[explicit]titlesec
usepackagecolor
usepackagetikz
definecolorseccolorRGB41,48,57
newcommandhsphspace8pt
titleformatsection
 [hang]
 Largebfseries
 
 0pt
 tikznode[draw]Largebfseriesthesectionhsptextcolorseccolorhsp#1;
begindocument
sectionSection Name
blindtext
enddocument

With very long section titles (with help from this question):

documentclass[10pt,a4paper,twoside]report
usepackageblindtext
usepackage[explicit]titlesec
usepackagecolor
usepackagetikz
usepackagevarwidth
usepackagecalc
tikzset
 max width/.style args=#1
 execute at begin node=beginvarwidth#1,
 execute at end node=endvarwidth
 

definecolorseccolorRGB41,48,57
newcommandhsphspace8pt
titleformatsection
 [hang]
 Largebfseries
 
 0pt
 tikznode[draw,max width=textwidth-.6666em-.4pt]Largebfseriesthesectionhsptextcolorseccolorhsp#1;
begindocument
sectionSection Name
blindtext
sectionThis is a very long section name that has to be broken into two lines
enddocument

If you want to have "|" instead of "—", as in the attached figure, you can use textbar:

documentclass[10pt,a4paper,twoside]report
usepackageblindtext
usepackage[explicit]titlesec
usepackagecolor
usepackagetikz
usepackagevarwidth
usepackagecalc
tikzset
 max width/.style args=#1
 execute at begin node=beginvarwidth#1,
 execute at end node=endvarwidth
 

definecolorseccolorRGB41,48,57
newcommandhsphspace8pt
titleformatsection
 [hang]
 Largebfseries
 
 0pt
 tikznode[draw,max width=textwidth-.6666em-.4pt]Largebfseriesthesectionhsptextcolorseccolortextbarhsp#1;
begindocument
sectionSection Name
blindtext
enddocument

However, a vertical line like this is much better I think.

documentclass[10pt,a4paper,twoside]report
usepackageblindtext
usepackage[explicit]titlesec
usepackagecolor
usepackagetikz
usepackagevarwidth
usepackagecalc
usetikzlibrarypositioning
tikzset
 max width/.style args=#1
 execute at begin node=beginvarwidth#1,
 execute at end node=endvarwidth
 

definecolorseccolorRGB41,48,57
newcommandhsphspace8pt
titleformatsection
 [hang]
 Largebfseries
 
 0pt
 tikz[font=Largebfseries]node[draw,minimum height=.75cm] (x) thesection;node[minimum height=.75cm,below right=0pt and 0pt of x.north west,draw,max width=textwidth-.6666em-.4pt]hspace.3333emphantomthesectionhspace.3333em#1;
begindocument
sectionSection Name
blindtext
sectionThis is a very long section name that has to be broken into two lines
enddocument

A solution with a simple tabulary:

documentclass[10pt, a4paper,svgnames, twoside]report
usepackage[utf8]inputenc
usepackage[T1]fontenc
usepackage[showframe]geometry
usepackageblindtext
usepackagearray, tabulary
usepackage[explicit]titlesec
usepackageblindtext, xcolor
definecolorseccolorRGB41,48,57
newcommandhsphspace8pt
titleformatsection[block]Largebfseriessffamilysetlengthfboxrule1ptcolorSlateGrey0ptfboxbegintabularydimexprlinewidth-tabcolsep-fboxrule@l!vline width 1.2ptLthesection &#1 endtabulary 

begindocument

setcounterchapter2
 sectionSection Title. Some more more text to have a really very very long section title.
 blindtext
 sectionA much shorter section title
blindtext

enddocument 

This post contains two solutions: a simple one and a more elaborate one.

Simple and crude solution based on fbox

Let's start with a simple solution based on fbox, that is easy to understand. We use textbar for the vertical bar and provide a variant for unnumbered sections (section*):

documentclass[10pt,a4paper,twoside]report
usepackagexcolor
usepackage[explicit]titlesec
usepackageblindtext

definecolorseccolorRGB41,48,57
newcommandhsphspace8pt

newcommand*sectionFont%
 Largebfseries


% For section
titleformatsection[block]sectionFont0pt%
 fboxthesection hsp textcolorseccolortextbarhsp #1

% For section*
titleformatname=section, numberless[block]sectionFont0pt%
 fbox#1

begindocument
chapterSome chapter

sectionSection title

Foo bar.

section*Unnumbered section

blindtext
enddocument

More elaborate solution using TikZ

If you want finer control than what fbox allows (fboxsep and fboxrule), using a tikzpicture environment for the frame is a good alternative. Here is an example of what one can do this way. It implements a similar design as in JouleV's solution but tries to do a cleaner positioning in order to ensure that the baseline of the section number is always aligned with the baseline of the first line of the section tile. Since we have all the power of TikZ at hand, we also add a few bells and whistles that are just a few keywords away: rounded corners, drop shadow and a background fill of the title box.

(With a bit more hacking, it should even be possible to detect when the section title takes several lines, and only in this case use vertical centering for the section number!)

documentclass[a4paper]report
usepackagelmodern
usepackage[T1]fontenc
usepackage[utf8]inputenc
usepackagexcolor
usepackage[explicit]titlesec
usepackageetoolbox
usepackagevarwidth
usepackagecalc
usepackageblindtext

usepackagetikz
% Uncomment the following line if you use babel and have a recent enough TikZ:
% usetikzlibrarybabel
usetikzlibrarybackgrounds
usetikzlibrarycalc
usetikzlibraryfit
usetikzlibraryshadows

% Essentially taken from <https://tex.stackexchange.com/a/482926/73317>
tikzset
 max width/.style args=#1
 execute at begin node=beginvarwidth[t]#1,
 execute at end node=endvarwidth
 


% Colors used for decorated section titles
definecolorsectionDecoRuleColorRGB70,10,10
colorletsectionDecoBgColoryellow!10

% Horizontal spacing used for decorated section titles
newlengthsectionDecoHsp
setlengthsectionDecoHsp8pt

newcommand*sectionDecoRuleWidth0.4pt

% Boolean flag indicating whether we are working with a section or a section*
newtogglesectionDecoIsNumberedSec

makeatletter

% High-level command for section decorations. Two variants: one for section
% and one for section*.
newcommand*sectionDecoration%
 @ifstar%
 togglefalsesectionDecoIsNumberedSec%
 @sectionDecoration@nil % @nil passed instead of the section number
 %
 toggletruesectionDecoIsNumberedSec%
 @sectionDecoration
 %


% #1: the section number (@nil if we are working for a section*)
% #2: the section title
newcommand*@sectionDecoration[2]%
 begintikzpicture
 % The section number
 iftogglesectionDecoIsNumberedSec% case of section
 node[inner xsep=sectionDecoHsp, inner ysep=0, outer sep=0,
 anchor=base west]
 (section number) at (0,0)
 strut #1;
 % case of section*
 node[inner sep=0, outer sep=0, anchor=base west]
 (section number) at (0,0)
 strut;
 

 % The section title (which may occupy several lines)
 path let p1 = ($(section number.east)-(section number.west)$),
 n1 = linewidth - veclen(p1) - 2sectionDecoHsp in
 node[inner xsep=sectionDecoHsp, inner ysep=0, outer sep=0,
 anchor=base west, max width=n1]
 (section title) at (section number.base east)
 strut #2% Useful for testing: rulen11pt%
 strut;

 beginscope[on background layer]
 % The frame around section number + title
 node[inner sep=0, outer sep=0, draw, line width=sectionDecoRuleWidth,
 rounded corners,
 fit=([xshift=0.5pgflinewidth]section number.north west)
 ([xshift=-0.5pgflinewidth]section title.south east),
 color=sectionDecoRuleColor, fill=sectionDecoBgColor, drop shadow]
 (frame) ;

 % The vertical line between section number and section title
 iftogglesectionDecoIsNumberedSec% case of section
 draw[color=sectionDecoRuleColor, line width=sectionDecoRuleWidth,
 line cap=butt]
 ([yshift=-0.5pgflinewidth]section title.north west) --
 ([yshift=0.5pgflinewidth]section title.south west);
 % no such line in the case of section*
 
 endscope

 % Display key points (only useful for debugging)
 % beginscope[overlay]
 % path[radius=1pt, fill=red] (section number.north west) circle 
 % (section number.north east) circle ;
 % node[draw,circle,green, inner sep=1.6pt] at (section title.north west) ;
 % endscope
 endtikzpicture%


makeatother

newcommand*sectionTitleFontLargebfseries

% For section
titleformatsection[block]sectionTitleFont0pt%
 sectionDecorationthesection#1

% For section*
titleformatname=section, numberless[block]sectionTitleFont0pt%
 sectionDecoration*#1

begindocument
chapterSome chapter

sectionA short section title

sectionA very very very very very very very very very very
 very very very very very very very very very very
 long section title

Foo bar.

section*An unnumbered section

blindtext
enddocument