Our database security standards require only dbo and guest users be in the
master database.
However, Reporting Services creates a user (rs2000) in the master database.
Is it possible to remove this user from the master database without affecting
functionality? If not, does anyone have suggestions for tightening down
security on this user?If RS created this it is how you installed it. I do not have any additional
users added to master database.
Only suggestion I could make is to try deleting it and if it causes a
problem put it back. All I know is, it is not a standard part of the install
(that I can see).
One caveat, my RS 2000 has been upgraded to RS 2005.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"cltdba" <cltdba@.discussions.microsoft.com> wrote in message
news:F4DE0DDD-3971-495B-B885-6338671BE79C@.microsoft.com...
> Our database security standards require only dbo and guest users be in the
> master database.
> However, Reporting Services creates a user (rs2000) in the master
> database.
> Is it possible to remove this user from the master database without
> affecting
> functionality? If not, does anyone have suggestions for tightening down
> security on this user?|||Thank you for the info. If I read your reply correctly;
The original install was RS 2000 (since upgraded to RS 2005).
During original install, no user (i.e. rs2000) was created in the master DB.
Are these true statements?
"Bruce L-C [MVP]" wrote:
> If RS created this it is how you installed it. I do not have any additional
> users added to master database.
> Only suggestion I could make is to try deleting it and if it causes a
> problem put it back. All I know is, it is not a standard part of the install
> (that I can see).
> One caveat, my RS 2000 has been upgraded to RS 2005.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "cltdba" <cltdba@.discussions.microsoft.com> wrote in message
> news:F4DE0DDD-3971-495B-B885-6338671BE79C@.microsoft.com...
> > Our database security standards require only dbo and guest users be in the
> > master database.
> >
> > However, Reporting Services creates a user (rs2000) in the master
> > database.
> > Is it possible to remove this user from the master database without
> > affecting
> > functionality? If not, does anyone have suggestions for tightening down
> > security on this user?
>
>|||I don't think a user was created at that time. I never looked previously so
I wouldn't know. What I can say is that in my situation (a 2000 upgraded to
2005) that there is no special user. I have dbo and guest in master and that
is it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"cltdba" <cltdba@.discussions.microsoft.com> wrote in message
news:2CB87B13-7B80-4205-A06B-8BDDA367B801@.microsoft.com...
> Thank you for the info. If I read your reply correctly;
> The original install was RS 2000 (since upgraded to RS 2005).
> During original install, no user (i.e. rs2000) was created in the master
> DB.
> Are these true statements?
>
> "Bruce L-C [MVP]" wrote:
>> If RS created this it is how you installed it. I do not have any
>> additional
>> users added to master database.
>> Only suggestion I could make is to try deleting it and if it causes a
>> problem put it back. All I know is, it is not a standard part of the
>> install
>> (that I can see).
>> One caveat, my RS 2000 has been upgraded to RS 2005.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "cltdba" <cltdba@.discussions.microsoft.com> wrote in message
>> news:F4DE0DDD-3971-495B-B885-6338671BE79C@.microsoft.com...
>> > Our database security standards require only dbo and guest users be in
>> > the
>> > master database.
>> >
>> > However, Reporting Services creates a user (rs2000) in the master
>> > database.
>> > Is it possible to remove this user from the master database without
>> > affecting
>> > functionality? If not, does anyone have suggestions for tightening
>> > down
>> > security on this user?
>>
Showing posts with label creates. Show all posts
Showing posts with label creates. Show all posts
Wednesday, March 21, 2012
Saturday, February 25, 2012
RS creates Active Sessions too easily
Problem: Can't run a script to test reports over night without running out
of memory because too many Active Sessions are being generated.
We have a Reporting Service test utiltiy that we are trying to run over
night. It gathers up all the possible parameter combinations and runs all of
these. The trouble is the number of Active Sessions increases by one for
each report and eventually the server fails. We added the ability to
generate a script when the test utility runs.
The .rss is compiled and ran against a single rs instance, still a new
session for every report render.
This is the same report getting rendered over and over, just with different
parameters.
Running the same report with the same parameters doesn't generate new Active
Sessions.
Running the reports from the RS Manager, I can change the parameters and not
get an additional Active Session, but when I switch reports and switch back
I get a new Active Session, once for the new report and once again when I
switch back to the report I was just on.
My guess is that this relates to the Web Service keeping my info in Session
State, and releasing it after 10 minutes.
Anyone with any ideas what I should do? I'd like to keep my session state
to 10 minutes, this same machine is used during the day by QA.
Here's my .rss code:
Dim ParentPath As String = "/" + ReportDir
Public Sub Main()
RunReport("myReport", "c:\temp\run1.pdf", "a,b,c", "1,2,3")
RunReport("myReport", "c:\temp\run2.pdf", "a,b,c", "4,5,6")
RunReport("myReport", "c:\temp\run3.pdf", "a,b,c", "4,5,6")
End Sub
Public Sub RunReport(ByVal reportName As String, ByVal FileName As String,
ByVal ParamNames As String, ByVal ParamValues As String)
Dim objReportResult As Byte()
Dim encoding As String
Dim mimeType As String
Dim rptParamsUsed As ParameterValue()
Dim warnings As Warning()
Dim streamIDs As String()
Dim fs As FileStream
Dim Names As String()
Dim Values As String()
Dim rptParamValues As ParameterValue()
Dim Counter As Integer
If ParamNames Is Nothing Then
rptParamValues = Nothing
Else
Names = ParamNames.Split(",")
Values = ParamValues.Split(",")
ReDim rptParamValues(Names.Length - 1)
For Counter = 0 To Names.Length - 1
rptParamValues(Counter) = New ParameterValue()
rptParamValues(Counter).Name = Names(Counter)
rptParamValues(Counter).Value = Values(Counter)
Next Counter
End If
Try
objReportResult = rs.Render(ParentPath + "/" + reportName, "PDF", Nothing,
Nothing, rptParamValues, Nothing, Nothing, encoding, mimeType,
rptParamsUsed, warnings, streamIDs)
fs = new FileStream(FileName, FileMode.OpenOrCreate)
fs.Write(objReportResult, 0, objReportResult.Length)
fs.Close()
Catch e As Exception
Console.WriteLine(e.Message)
End Try
End Sub
Here's the documentation on MSRS 2005 Web Service Active Sessions:
Active Sessions
Number of active sessions. This counter provides a cumulative count of all
browser sessions generated from report subscriptions, whether they are still
active or not.
The counter is decremented as session records are removed. By default,
sessions are removed after ten minutes no activity.
Steve MunLeeuwEntered support incident, need to provide stack trace of error. Will do
tomorrow. Took about an hour to get the support incident set up...fun :)
"Steve MunLeeuw" <smunson@.clearwire.net> wrote in message
news:OhBp4jf1GHA.1040@.TK2MSFTNGP06.phx.gbl...
> Problem: Can't run a script to test reports over night without running
> out of memory because too many Active Sessions are being generated.
> We have a Reporting Service test utiltiy that we are trying to run over
> night. It gathers up all the possible parameter combinations and runs all
> of these. The trouble is the number of Active Sessions increases by one
> for each report and eventually the server fails. We added the ability to
> generate a script when the test utility runs.
> The .rss is compiled and ran against a single rs instance, still a new
> session for every report render.
> This is the same report getting rendered over and over, just with
> different parameters.
> Running the same report with the same parameters doesn't generate new
> Active Sessions.
> Running the reports from the RS Manager, I can change the parameters and
> not get an additional Active Session, but when I switch reports and switch
> back I get a new Active Session, once for the new report and once again
> when I switch back to the report I was just on.
> My guess is that this relates to the Web Service keeping my info in
> Session State, and releasing it after 10 minutes.
> Anyone with any ideas what I should do? I'd like to keep my session state
> to 10 minutes, this same machine is used during the day by QA.
> Here's my .rss code:
> Dim ParentPath As String = "/" + ReportDir
> Public Sub Main()
> RunReport("myReport", "c:\temp\run1.pdf", "a,b,c", "1,2,3")
> RunReport("myReport", "c:\temp\run2.pdf", "a,b,c", "4,5,6")
> RunReport("myReport", "c:\temp\run3.pdf", "a,b,c", "4,5,6")
> End Sub
>
> Public Sub RunReport(ByVal reportName As String, ByVal FileName As String,
> ByVal ParamNames As String, ByVal ParamValues As String)
> Dim objReportResult As Byte()
> Dim encoding As String
> Dim mimeType As String
> Dim rptParamsUsed As ParameterValue()
> Dim warnings As Warning()
> Dim streamIDs As String()
> Dim fs As FileStream
> Dim Names As String()
> Dim Values As String()
> Dim rptParamValues As ParameterValue()
> Dim Counter As Integer
> If ParamNames Is Nothing Then
> rptParamValues = Nothing
> Else
> Names = ParamNames.Split(",")
> Values = ParamValues.Split(",")
> ReDim rptParamValues(Names.Length - 1)
> For Counter = 0 To Names.Length - 1
> rptParamValues(Counter) = New ParameterValue()
> rptParamValues(Counter).Name = Names(Counter)
> rptParamValues(Counter).Value = Values(Counter)
> Next Counter
> End If
>
> Try
> objReportResult = rs.Render(ParentPath + "/" + reportName, "PDF", Nothing,
> Nothing, rptParamValues, Nothing, Nothing, encoding, mimeType,
> rptParamsUsed, warnings, streamIDs)
> fs = new FileStream(FileName, FileMode.OpenOrCreate)
> fs.Write(objReportResult, 0, objReportResult.Length)
> fs.Close()
> Catch e As Exception
> Console.WriteLine(e.Message)
> End Try
> End Sub
>
> Here's the documentation on MSRS 2005 Web Service Active Sessions:
> Active Sessions
>
> Number of active sessions. This counter provides a cumulative count of all
> browser sessions generated from report subscriptions, whether they are
> still active or not.
> The counter is decremented as session records are removed. By default,
> sessions are removed after ten minutes no activity.
> Steve MunLeeuw
>
of memory because too many Active Sessions are being generated.
We have a Reporting Service test utiltiy that we are trying to run over
night. It gathers up all the possible parameter combinations and runs all of
these. The trouble is the number of Active Sessions increases by one for
each report and eventually the server fails. We added the ability to
generate a script when the test utility runs.
The .rss is compiled and ran against a single rs instance, still a new
session for every report render.
This is the same report getting rendered over and over, just with different
parameters.
Running the same report with the same parameters doesn't generate new Active
Sessions.
Running the reports from the RS Manager, I can change the parameters and not
get an additional Active Session, but when I switch reports and switch back
I get a new Active Session, once for the new report and once again when I
switch back to the report I was just on.
My guess is that this relates to the Web Service keeping my info in Session
State, and releasing it after 10 minutes.
Anyone with any ideas what I should do? I'd like to keep my session state
to 10 minutes, this same machine is used during the day by QA.
Here's my .rss code:
Dim ParentPath As String = "/" + ReportDir
Public Sub Main()
RunReport("myReport", "c:\temp\run1.pdf", "a,b,c", "1,2,3")
RunReport("myReport", "c:\temp\run2.pdf", "a,b,c", "4,5,6")
RunReport("myReport", "c:\temp\run3.pdf", "a,b,c", "4,5,6")
End Sub
Public Sub RunReport(ByVal reportName As String, ByVal FileName As String,
ByVal ParamNames As String, ByVal ParamValues As String)
Dim objReportResult As Byte()
Dim encoding As String
Dim mimeType As String
Dim rptParamsUsed As ParameterValue()
Dim warnings As Warning()
Dim streamIDs As String()
Dim fs As FileStream
Dim Names As String()
Dim Values As String()
Dim rptParamValues As ParameterValue()
Dim Counter As Integer
If ParamNames Is Nothing Then
rptParamValues = Nothing
Else
Names = ParamNames.Split(",")
Values = ParamValues.Split(",")
ReDim rptParamValues(Names.Length - 1)
For Counter = 0 To Names.Length - 1
rptParamValues(Counter) = New ParameterValue()
rptParamValues(Counter).Name = Names(Counter)
rptParamValues(Counter).Value = Values(Counter)
Next Counter
End If
Try
objReportResult = rs.Render(ParentPath + "/" + reportName, "PDF", Nothing,
Nothing, rptParamValues, Nothing, Nothing, encoding, mimeType,
rptParamsUsed, warnings, streamIDs)
fs = new FileStream(FileName, FileMode.OpenOrCreate)
fs.Write(objReportResult, 0, objReportResult.Length)
fs.Close()
Catch e As Exception
Console.WriteLine(e.Message)
End Try
End Sub
Here's the documentation on MSRS 2005 Web Service Active Sessions:
Active Sessions
Number of active sessions. This counter provides a cumulative count of all
browser sessions generated from report subscriptions, whether they are still
active or not.
The counter is decremented as session records are removed. By default,
sessions are removed after ten minutes no activity.
Steve MunLeeuwEntered support incident, need to provide stack trace of error. Will do
tomorrow. Took about an hour to get the support incident set up...fun :)
"Steve MunLeeuw" <smunson@.clearwire.net> wrote in message
news:OhBp4jf1GHA.1040@.TK2MSFTNGP06.phx.gbl...
> Problem: Can't run a script to test reports over night without running
> out of memory because too many Active Sessions are being generated.
> We have a Reporting Service test utiltiy that we are trying to run over
> night. It gathers up all the possible parameter combinations and runs all
> of these. The trouble is the number of Active Sessions increases by one
> for each report and eventually the server fails. We added the ability to
> generate a script when the test utility runs.
> The .rss is compiled and ran against a single rs instance, still a new
> session for every report render.
> This is the same report getting rendered over and over, just with
> different parameters.
> Running the same report with the same parameters doesn't generate new
> Active Sessions.
> Running the reports from the RS Manager, I can change the parameters and
> not get an additional Active Session, but when I switch reports and switch
> back I get a new Active Session, once for the new report and once again
> when I switch back to the report I was just on.
> My guess is that this relates to the Web Service keeping my info in
> Session State, and releasing it after 10 minutes.
> Anyone with any ideas what I should do? I'd like to keep my session state
> to 10 minutes, this same machine is used during the day by QA.
> Here's my .rss code:
> Dim ParentPath As String = "/" + ReportDir
> Public Sub Main()
> RunReport("myReport", "c:\temp\run1.pdf", "a,b,c", "1,2,3")
> RunReport("myReport", "c:\temp\run2.pdf", "a,b,c", "4,5,6")
> RunReport("myReport", "c:\temp\run3.pdf", "a,b,c", "4,5,6")
> End Sub
>
> Public Sub RunReport(ByVal reportName As String, ByVal FileName As String,
> ByVal ParamNames As String, ByVal ParamValues As String)
> Dim objReportResult As Byte()
> Dim encoding As String
> Dim mimeType As String
> Dim rptParamsUsed As ParameterValue()
> Dim warnings As Warning()
> Dim streamIDs As String()
> Dim fs As FileStream
> Dim Names As String()
> Dim Values As String()
> Dim rptParamValues As ParameterValue()
> Dim Counter As Integer
> If ParamNames Is Nothing Then
> rptParamValues = Nothing
> Else
> Names = ParamNames.Split(",")
> Values = ParamValues.Split(",")
> ReDim rptParamValues(Names.Length - 1)
> For Counter = 0 To Names.Length - 1
> rptParamValues(Counter) = New ParameterValue()
> rptParamValues(Counter).Name = Names(Counter)
> rptParamValues(Counter).Value = Values(Counter)
> Next Counter
> End If
>
> Try
> objReportResult = rs.Render(ParentPath + "/" + reportName, "PDF", Nothing,
> Nothing, rptParamValues, Nothing, Nothing, encoding, mimeType,
> rptParamsUsed, warnings, streamIDs)
> fs = new FileStream(FileName, FileMode.OpenOrCreate)
> fs.Write(objReportResult, 0, objReportResult.Length)
> fs.Close()
> Catch e As Exception
> Console.WriteLine(e.Message)
> End Try
> End Sub
>
> Here's the documentation on MSRS 2005 Web Service Active Sessions:
> Active Sessions
>
> Number of active sessions. This counter provides a cumulative count of all
> browser sessions generated from report subscriptions, whether they are
> still active or not.
> The counter is decremented as session records are removed. By default,
> sessions are removed after ten minutes no activity.
> Steve MunLeeuw
>
Subscribe to:
Posts (Atom)