Showing posts with label logs. Show all posts
Showing posts with label logs. Show all posts

Wednesday, March 28, 2012

Reporting Services 2005 on a separate server

I recently installed an instance of SQL Server 2005 on a server that didn't have IIS. I received an error notification in the install logs that some components of SQL Server would not work. This lead me to wonder if Reporting Services 2005 truly can be installed on a separate server and run efficiently, so I pose the question to anyone out there who has had success doing so. Does IIS need to be installed on a server running an instance of SQL Server 2005 even if Reporting Services is not installed and is intended to be installed on a separate server? Any installation recommendations in installing RS 2005 on a separate server?Hi, some short answers, I hope they are suffiecient to your questions:

RS needs IIS to run. SQL Server 2005 does not.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Tuesday, February 21, 2012

Reporting Log Problem

Every so often I find reporting services logs (C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\LogFiles) in excess of 33 mb. For example
there are 135 log files from today with the name similar to
ReportServerService__05_19_2005_09_11_25.log and are all between 33 and 34 mb
in size. I only use reporting services for MOM 2005 reporting. What are
these logs for and can they be deleted without causing problems?
Thank you,
KevinThis is a known issue (Bug #: 304241 -
http://support.microsoft.com/kb/885286/) and is fixed in Reporting Services
SP2
http://www.microsoft.com/downloads/details.aspx?FamilyID=502C0D89-1308-4662-8F58-CEC55EF1235B&displaylang=en
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:7E421675-8157-49BC-9557-CE04152CD77C@.microsoft.com...
> Every so often I find reporting services logs (C:\Program Files\Microsoft
> SQL
> Server\MSSQL\Reporting Services\LogFiles) in excess of 33 mb. For example
> there are 135 log files from today with the name similar to
> ReportServerService__05_19_2005_09_11_25.log and are all between 33 and 34
> mb
> in size. I only use reporting services for MOM 2005 reporting. What are
> these logs for and can they be deleted without causing problems?
> Thank you,
> Kevin|||thank you! Can I delete these logs?
"Jasper Smith" wrote:
> This is a known issue (Bug #: 304241 -
> http://support.microsoft.com/kb/885286/) and is fixed in Reporting Services
> SP2
> http://www.microsoft.com/downloads/details.aspx?FamilyID=502C0D89-1308-4662-8F58-CEC55EF1235B&displaylang=en
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Kevin" <Kevin@.discussions.microsoft.com> wrote in message
> news:7E421675-8157-49BC-9557-CE04152CD77C@.microsoft.com...
> > Every so often I find reporting services logs (C:\Program Files\Microsoft
> > SQL
> > Server\MSSQL\Reporting Services\LogFiles) in excess of 33 mb. For example
> > there are 135 log files from today with the name similar to
> > ReportServerService__05_19_2005_09_11_25.log and are all between 33 and 34
> > mb
> > in size. I only use reporting services for MOM 2005 reporting. What are
> > these logs for and can they be deleted without causing problems?
> >
> > Thank you,
> >
> > Kevin
>
>|||Yes, technically the logs can be deleted w/out affecting RS.
--
Adrian M.
MCP
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:3FB18D84-1D41-483E-AA2D-FDB9A0519FC9@.microsoft.com...
> thank you! Can I delete these logs?
> "Jasper Smith" wrote:
>> This is a known issue (Bug #: 304241 -
>> http://support.microsoft.com/kb/885286/) and is fixed in Reporting
>> Services
>> SP2
>> http://www.microsoft.com/downloads/details.aspx?FamilyID=502C0D89-1308-4662-8F58-CEC55EF1235B&displaylang=en
>> --
>> HTH
>> Jasper Smith (SQL Server MVP)
>> http://www.sqldbatips.com
>> I support PASS - the definitive, global
>> community for SQL Server professionals -
>> http://www.sqlpass.org
>> "Kevin" <Kevin@.discussions.microsoft.com> wrote in message
>> news:7E421675-8157-49BC-9557-CE04152CD77C@.microsoft.com...
>> > Every so often I find reporting services logs (C:\Program
>> > Files\Microsoft
>> > SQL
>> > Server\MSSQL\Reporting Services\LogFiles) in excess of 33 mb. For
>> > example
>> > there are 135 log files from today with the name similar to
>> > ReportServerService__05_19_2005_09_11_25.log and are all between 33 and
>> > 34
>> > mb
>> > in size. I only use reporting services for MOM 2005 reporting. What
>> > are
>> > these logs for and can they be deleted without causing problems?
>> >
>> > Thank you,
>> >
>> > Kevin
>>