Showing posts with label drop. Show all posts
Showing posts with label drop. Show all posts

Wednesday, March 7, 2012

Cannot subscribe via email

When I go to the subscription page, in the delivered by drop down box, i only get "File Share" as an option. Is there a setting on the report server configuration file that is making the "Email Delivery" option not viewable?

Thanks.

silly question, but did you specify an email server (smtp)?

Also, what version are you using (2000, 2005)?

|||

That is correct, RS will only display the extensions which are configured and ready to use. In order to use the email extension, you need to provide a SMTP server name at least - via the RS configuration tool in RS 2005 or manually editing RsReportServer.config in RS 2000.

Thanks

Tudor

Sunday, February 12, 2012

Cannot restore to database

Drop database and recreated, however cannot restore data. Says Data dump came from Master. If I choose Master, says I must be in single user mode.Hi,
Are you trying to restore the Master database or some user database ? If it
is master u have to
1.. Start Microsoft® SQL ServerT in single-user mode. (use -m in service
manager while starting sql server)
2.. Execute the RESTORE DATABASE statement to restore the master database
backup
3.. Stop and start the SQL Server in Muliuser Mode. (Just Restart MSSQL
Server service)
Thanks
Hari
MCDBA
"bscottparis" <anonymous@.discussions.microsoft.com> wrote in message
news:9D1F49FF-E704-4DE1-BB81-722033F6169E@.microsoft.com...
> Drop database and recreated, however cannot restore data. Says Data dump
came from Master. If I choose Master, says I must be in single user mode.