Report to a text file

Hi !
When creating a maintenance plan, I can activate the option "Report to a
text file" available on the last page. How can I enable this option after
the maintenance plan was created ?
Thank you !
HugoDear Hugo,
Thank you for posting here.
We can manually enable the option "Report to a text file" by the steps
below:
1. Right click on the Maintenance Plan that you would like to enable the
option -> Click Modify.
2. In the right panel of the screen, we will find a button named "Reporting
and Logging" (just besides the "Manage Connections" button) on the design
Tab.
3. Click on this button, enable the option "Generate a test file report"
and then specify the location.
4. Click OK to apply the settings.
If anything is unclear regarding above steps, please don't hesitate to let
me know.
Have a nice day!
Best regards,
Adams Qu
MCSE, MCDBA, MCTS
Microsoft Online Support
Microsoft Global Technical Support Center
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
--
| From: "Hugo" <newschrg@.noemail.noemail>
| Subject: Report to a text file
| Date: Mon, 24 Sep 2007 14:08:26 -0400
| Lines: 11
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
| Message-ID: <OfApmXt$HHA.5424@.TK2MSFTNGP05.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: isis.reg03.rtss.qc.ca 142.84.196.21
| Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP05.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:26187
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Hi !
|
| When creating a maintenance plan, I can activate the option "Report to a
| text file" available on the last page. How can I enable this option after
| the maintenance plan was created ?
|
| Thank you !
|
| Hugo
|
|
||||Thank you !
Hugo
"Adams Qu [MSFT]" <v-adamqu@.online.microsoft.com> a écrit dans le message de
news: yU9jbNy$HHA.240@.TK2MSFTNGHUB02.phx.gbl...
> Dear Hugo,
> Thank you for posting here.
> We can manually enable the option "Report to a text file" by the steps
> below:
> 1. Right click on the Maintenance Plan that you would like to enable the
> option -> Click Modify.
> 2. In the right panel of the screen, we will find a button named
> "Reporting
> and Logging" (just besides the "Manage Connections" button) on the design
> Tab.
> 3. Click on this button, enable the option "Generate a test file report"
> and then specify the location.
> 4. Click OK to apply the settings.
> If anything is unclear regarding above steps, please don't hesitate to let
> me know.
> Have a nice day!
> Best regards,
> Adams Qu
> MCSE, MCDBA, MCTS
> Microsoft Online Support
> Microsoft Global Technical Support Center
> Get Secure! - www.microsoft.com/security
> =====================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> --
> | From: "Hugo" <newschrg@.noemail.noemail>
> | Subject: Report to a text file
> | Date: Mon, 24 Sep 2007 14:08:26 -0400
> | Lines: 11
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
> | X-RFC2646: Format=Flowed; Original
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
> | Message-ID: <OfApmXt$HHA.5424@.TK2MSFTNGP05.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.server
> | NNTP-Posting-Host: isis.reg03.rtss.qc.ca 142.84.196.21
> | Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP05.phx.gbl
> | Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:26187
> | X-Tomcat-NG: microsoft.public.sqlserver.server
> |
> | Hi !
> |
> | When creating a maintenance plan, I can activate the option "Report to a
> | text file" available on the last page. How can I enable this option
> after
> | the maintenance plan was created ?
> |
> | Thank you !
> |
> | Hugo
> |
> |
> |
>|||Dear Hugo,
We wanted to see if the information provided was helpful. Please keep us
posted on your progress and let us know if you have any additional
questions or concerns.
We are looking forward to your response.
Have a nice day!
Best regards,
Adams Qu
MCSE, MCDBA, MCTS
Microsoft Online Support
Microsoft Global Technical Support Center
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
| X-Tomcat-ID: 40360268
| References: <OfApmXt$HHA.5424@.TK2MSFTNGP05.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| From: v-adamqu@.online.microsoft.com (Adams Qu [MSFT])
| Organization: Microsoft
| Date: Tue, 25 Sep 2007 03:22:48 GMT
| Subject: RE: Report to a text file
| X-Tomcat-NG: microsoft.public.sqlserver.server
| Message-ID: <yU9jbNy$HHA.240@.TK2MSFTNGHUB02.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| Lines: 53
| Path: TK2MSFTNGHUB02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:26212
| NNTP-Posting-Host: tomcatimport2.phx.gbl 10.201.218.182
|
| Dear Hugo,
|
| Thank you for posting here.
|
| We can manually enable the option "Report to a text file" by the steps
| below:
|
| 1. Right click on the Maintenance Plan that you would like to enable the
| option -> Click Modify.
| 2. In the right panel of the screen, we will find a button named
"Reporting
| and Logging" (just besides the "Manage Connections" button) on the design
| Tab.
| 3. Click on this button, enable the option "Generate a test file report"
| and then specify the location.
| 4. Click OK to apply the settings.
|
| If anything is unclear regarding above steps, please don't hesitate to
let
| me know.
|
| Have a nice day!
|
| Best regards,
|
| Adams Qu
| MCSE, MCDBA, MCTS
| Microsoft Online Support
|
| Microsoft Global Technical Support Center
|
| Get Secure! - www.microsoft.com/security
| =====================================================| When responding to posts, please "Reply to Group" via your newsreader so
| that others may learn and benefit from your issue.
| =====================================================| This posting is provided "AS IS" with no warranties, and confers no
rights.
| --
| | From: "Hugo" <newschrg@.noemail.noemail>
| | Subject: Report to a text file
| | Date: Mon, 24 Sep 2007 14:08:26 -0400
| | Lines: 11
| | X-Priority: 3
| | X-MSMail-Priority: Normal
| | X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
| | X-RFC2646: Format=Flowed; Original
| | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
| | Message-ID: <OfApmXt$HHA.5424@.TK2MSFTNGP05.phx.gbl>
| | Newsgroups: microsoft.public.sqlserver.server
| | NNTP-Posting-Host: isis.reg03.rtss.qc.ca 142.84.196.21
| | Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP05.phx.gbl
| | Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:26187
| | X-Tomcat-NG: microsoft.public.sqlserver.server
| |
| | Hi !
| |
| | When creating a maintenance plan, I can activate the option "Report to
a
| | text file" available on the last page. How can I enable this option
after
| | the maintenance plan was created ?
| |
| | Thank you !
| |
| | Hugo
| |
| |
| |
|
|sql

Report Server installation is not initialized / Can not activate

Hi folks!
After the installation of Reporting Services i received the following error:
The report server installation is not initialized.
First i just continued with the installation of the Service Packs and after
that I tried to activate it with rsactivate, but this didn't work because of
an other error.
rsactivate -c"C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\RSReportServer.config" -t
Result:
Failure starting the web service:
System.Exception: Unexpected database error (-2147159548) 0x80040154
--> System.Exception: 0x80040154
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.RSActivate.RSActivate.RpcActivateService(Int32
clientType)
at Microsoft.ReportingServices.RSActivate.RSActivate.InstanceMain()
at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
BaseCmdLine instance)
--
System:
Win2000
MDAC 2.8 SP1
SQL Server 2000 SP4, with all the Service Packs for Reporting Services
installed.
I'd appreciate help from Microsoft staff on this topic!
I did everything that came to my mind to fix this:
- reg_iis -i
- MDAC reinstalled
- rskeymgmt -d:
--> Result: Unexpected database error (-2147159548) 0x80040154
- deletet encryption keys manually (in the ReportServer database)
ReportServerLog:
aspnet_wp!crypto!c2c!11/23/2005-10:11:06:: i INFO: Initializing crypto as
user: CUSER\reportuser
aspnet_wp!crypto!c2c!11/23/2005-10:11:06:: i INFO: Exporting public key
aspnet_wp!crypto!c2c!11/23/2005-10:11:06:: w WARN: Web Service not activated
aspnet_wp!crypto!c2c!11/23/2005-10:11:06:: i INFO: Client is a local admin.
Activating web service via RPC.
aspnet_wp!library!c2c!11/23/2005-10:11:06:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the documentation
for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the documentation
for more information. --> System.Runtime.InteropServices.COMException
(0x80004005): -2147159548 --> System.Exception: 0x80040154
at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
Int32 extendedError)
at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID, Int32
clientType)
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
-- End of inner exception stack trace --
aspnet_wp!webserver!c2c!11/23/2005-10:11:08:: e ERROR: Reporting Services
error
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the documentation
for more information. --> System.Runtime.InteropServices.COMException
(0x80004005): -2147159548 --> System.Exception: 0x80040154
at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
Int32 extendedError)
at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID, Int32
clientType)
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
-- End of inner exception stack trace --
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at
Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
storedProcedureName)
at
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String key)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
name)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String name)
at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
source)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path, Boolean validate, Boolean convert, Boolean translate)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
aspnet_wp!crypto!c8c!11/23/2005-10:12:06:: i INFO: Initializing crypto as
user: CUSER\reportuser
aspnet_wp!crypto!c8c!11/23/2005-10:12:06:: i INFO: Exporting public key
aspnet_wp!crypto!c8c!11/23/2005-10:12:06:: w WARN: Web Service not activated
aspnet_wp!crypto!c8c!11/23/2005-10:12:06:: i INFO: Client is not a local
admin. Not attempting activation.
This user is a local admin, so why do I get these errors?
What can i do to activate Reporting Services? Are there some things a can
change manually in the database?
Thx for any help
YaraIt was the MDAC.
The automatic installation of MDAC failed all the time without
prompting an error message, that's why I didn't notice it.
I had to manually check every dll and overwrite older versions. Then
reregister it.
Hope this will help other users.