appSettings from web.config cannot be referenced in emailed report subscription

Server Software:

SQL Server 2000 (all sp's up to date)

SSRS 2000 (all sp's up to date)

We have an error when a report subscription is sent via email.

Our report definitions reference a key in the web.config file so that we can have a single location to reference our department's name in all reports. Our department name changes frequently as our company is bought and sold and it is difficult to manually update 700+ reports.

In report designer we have a text field with the following value expression:

=System.Configuration.ConfigurationSettings.appSettings("Department").ToString()

Our web.config looks like this:

<?xml version="1.0" encoding="utf-8" ?>

<configuration>

....extra settings truncated for brevity...

<appSettings>

<add key="Department" value="Report created by: Corporate Reporting and Analysis" />

</appSettings>

</configuration>

The reports work perfectly in every aspect accept when they are schedules to be emailed. When the email recipient receives the email (not matter what format, mhtl, pdf, etc...) the department string value is replaced with: #Error

Is this a bug with the report schedule and deilvery component? ..or is there a permission problem when accessing: System.Configuration.ConfigurationSettings.appSettings("Department").ToString() ?

Any help would be greatly appreciated.

Thank you

Well, I believe I solved the issue:

The report scheduling service is located in another folder:

C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\bin\ReportingServicesService.exe

...and its configuration file is called:

ReportingServicesService.exe.config

All we had to do was modify this config file to match our web.config appSettings and "Presto!" it worked.

<configuration>

....extra settings truncated for brevity...

<appSettings>

<add key="Department" value="Report created by: Corporate Reporting and Analysis" />

</appSettings>

</configuration>

Also, remember to restart the "ReportServer" service after updating the ReportingServicesService.exe.config file in order to immediately reset the changes.

application failed. when clicked on the sqlexpr.exe file.

Hello

I have the sql server 2005 express edition. the software stops during the setup and gives me a "failed" message. All other software of express edition are working fine. I am getting the problem only when I am dealing with sql server 2005 express edition. I made sure to deleate all the old version of sql server. uninstalled all the sql server files which were in my computer prior to download the new one. However I am still in troulbe.

As someone suggested that one should uninstale the sqlmsi file so I did that too. Still samething. Any help please......

Hi,

The event log should give you a clue what happened, eventually during the initial startup of the service.

Make sure that the SQL Server Service could start up properly. In the near püast a often and common error was that the rights provided within the SQL Server service was not priviledged to aquire the sufficient permissions for starting. So either make sure that you are using a account for starting the service which is priviledged to start as a service. Normally, Local System should be enough to start (commonly used), a (for me) better way is (if you have a domain context) is to use a domain account.

Some of the advantages are:

-There is much more security granularity over a domain account than over a system account
-If you later need network ressources you won′t get them with a Local System Account and have to switch to a domain account.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||Thank you very much sir thanks a lot its working now. :) i appreciated your support

Anyone Use Live Vault?

Hi Everyone,
I'm investigating a software called Live Vault (http://www.livevault.com)
whose purpose is to continuously monitor and record changes in a SQL Server
database, at the database file level, and periodically send these changes to
a remote server where they're applied to matching files. In essence, it's
kind of up-to-the-minute backup of the database.
I am unsure about how this software is going to perform and/or affect the
database and I'm very interested in hearing from anyone who has experience
with this software.
Any information, thoughts and opinions regarding this tool is greatly
appreciated.
Lou
Hi
They do not state on their case studies exactly what OS's and Database
products are supported. Not a word about SQL Server on their site.
Ask the vendor if they have certified their product for SQL Server.
And don't forget, picking up the bits off disk, shipping them over a
connection, does induce performance limitations, and if your data were to go
corrupt on the local drive, the corruption is faithfully copied to them.
A service like this does not eliminate the need for regular Database and Log
dumps.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Louis Marchand" <lmarch@.safetrans.com> wrote in message
news:eooNWKQTFHA.4056@.TK2MSFTNGP15.phx.gbl...
> Hi Everyone,
> I'm investigating a software called Live Vault (http://www.livevault.com)
> whose purpose is to continuously monitor and record changes in a SQL
> Server
> database, at the database file level, and periodically send these changes
> to
> a remote server where they're applied to matching files. In essence, it's
> kind of up-to-the-minute backup of the database.
> I am unsure about how this software is going to perform and/or affect the
> database and I'm very interested in hearing from anyone who has experience
> with this software.
> Any information, thoughts and opinions regarding this tool is greatly
> appreciated.
> Lou
>
|||Mike,
Thank you very much for your input.
I do nightly full database backups and hourly transaction log backups during
business hours every day and copy these backups onto tape each night. This
leaves a potential one-day data loss in case of catastrophic failure.
Management sees Live Vault as a way to have an "up-to-the-minute" database
backup. Our systems group has had success using Live Vault to restore basic
user files e.g. Word documents or PDF documents, that sort of thing.
However, I am very suspicious of a product that monitors live SQL Server
data files. It sounds wonderful in theory but I've always been very leary
of the kind of bit level monitoring that's required.
I am really hoping someone on the newsgroup is using or has used the product
and could give a first hand account of their experiences. If there's anyone
out there reading this, I'd love to hear your honest assessment of the
product, any problems you've had and the support you received from Live
Vault addressing problems.
Best regards,
Lou
Louis Marchand
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:etHYsWZTFHA.1384@.TK2MSFTNGP09.phx.gbl...
> Hi
> They do not state on their case studies exactly what OS's and Database
> products are supported. Not a word about SQL Server on their site.
> Ask the vendor if they have certified their product for SQL Server.
> And don't forget, picking up the bits off disk, shipping them over a
> connection, does induce performance limitations, and if your data were to
go
> corrupt on the local drive, the corruption is faithfully copied to them.
> A service like this does not eliminate the need for regular Database and
Log[vbcol=seagreen]
> dumps.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Louis Marchand" <lmarch@.safetrans.com> wrote in message
> news:eooNWKQTFHA.4056@.TK2MSFTNGP15.phx.gbl...
(http://www.livevault.com)[vbcol=seagreen]
changes[vbcol=seagreen]
it's[vbcol=seagreen]
the[vbcol=seagreen]
experience
>

Anyone Use Live Vault?

Hi Everyone,
I'm investigating a software called Live Vault (http://www.livevault.com)
whose purpose is to continuously monitor and record changes in a SQL Server
database, at the database file level, and periodically send these changes to
a remote server where they're applied to matching files. In essence, it's
kind of up-to-the-minute backup of the database.
I am unsure about how this software is going to perform and/or affect the
database and I'm very interested in hearing from anyone who has experience
with this software.
Any information, thoughts and opinions regarding this tool is greatly
appreciated.
LouHi
They do not state on their case studies exactly what OS's and Database
products are supported. Not a word about SQL Server on their site.
Ask the vendor if they have certified their product for SQL Server.
And don't forget, picking up the bits off disk, shipping them over a
connection, does induce performance limitations, and if your data were to go
corrupt on the local drive, the corruption is faithfully copied to them.
A service like this does not eliminate the need for regular Database and Log
dumps.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Louis Marchand" <lmarch@.safetrans.com> wrote in message
news:eooNWKQTFHA.4056@.TK2MSFTNGP15.phx.gbl...
> Hi Everyone,
> I'm investigating a software called Live Vault (http://www.livevault.com)
> whose purpose is to continuously monitor and record changes in a SQL
> Server
> database, at the database file level, and periodically send these changes
> to
> a remote server where they're applied to matching files. In essence, it's
> kind of up-to-the-minute backup of the database.
> I am unsure about how this software is going to perform and/or affect the
> database and I'm very interested in hearing from anyone who has experience
> with this software.
> Any information, thoughts and opinions regarding this tool is greatly
> appreciated.
> Lou
>|||Mike,
Thank you very much for your input.
I do nightly full database backups and hourly transaction log backups during
business hours every day and copy these backups onto tape each night. This
leaves a potential one-day data loss in case of catastrophic failure.
Management sees Live Vault as a way to have an "up-to-the-minute" database
backup. Our systems group has had success using Live Vault to restore basic
user files e.g. Word documents or PDF documents, that sort of thing.
However, I am very suspicious of a product that monitors live SQL Server
data files. It sounds wonderful in theory but I've always been very leary
of the kind of bit level monitoring that's required.
I am really hoping someone on the newsgroup is using or has used the product
and could give a first hand account of their experiences. If there's anyone
out there reading this, I'd love to hear your honest assessment of the
product, any problems you've had and the support you received from Live
Vault addressing problems.
Best regards,
Lou
Louis Marchand
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:etHYsWZTFHA.1384@.TK2MSFTNGP09.phx.gbl...
> Hi
> They do not state on their case studies exactly what OS's and Database
> products are supported. Not a word about SQL Server on their site.
> Ask the vendor if they have certified their product for SQL Server.
> And don't forget, picking up the bits off disk, shipping them over a
> connection, does induce performance limitations, and if your data were to
go
> corrupt on the local drive, the corruption is faithfully copied to them.
> A service like this does not eliminate the need for regular Database and
Log
> dumps.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Louis Marchand" <lmarch@.safetrans.com> wrote in message
> news:eooNWKQTFHA.4056@.TK2MSFTNGP15.phx.gbl...
> > Hi Everyone,
> > I'm investigating a software called Live Vault
(http://www.livevault.com)
> > whose purpose is to continuously monitor and record changes in a SQL
> > Server
> > database, at the database file level, and periodically send these
changes
> > to
> > a remote server where they're applied to matching files. In essence,
it's
> > kind of up-to-the-minute backup of the database.
> >
> > I am unsure about how this software is going to perform and/or affect
the
> > database and I'm very interested in hearing from anyone who has
experience
> > with this software.
> >
> > Any information, thoughts and opinions regarding this tool is greatly
> > appreciated.
> > Lou
> >
> >
>

Anyone Use Live Vault?

Hi Everyone,
I'm investigating a software called Live Vault (http://www.livevault.com)
whose purpose is to continuously monitor and record changes in a SQL Server
database, at the database file level, and periodically send these changes to
a remote server where they're applied to matching files. In essence, it's
kind of up-to-the-minute backup of the database.
I am unsure about how this software is going to perform and/or affect the
database and I'm very interested in hearing from anyone who has experience
with this software.
Any information, thoughts and opinions regarding this tool is greatly
appreciated.
LouHi
They do not state on their case studies exactly what OS's and Database
products are supported. Not a word about SQL Server on their site.
Ask the vendor if they have certified their product for SQL Server.
And don't forget, picking up the bits off disk, shipping them over a
connection, does induce performance limitations, and if your data were to go
corrupt on the local drive, the corruption is faithfully copied to them.
A service like this does not eliminate the need for regular Database and Log
dumps.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Louis Marchand" <lmarch@.safetrans.com> wrote in message
news:eooNWKQTFHA.4056@.TK2MSFTNGP15.phx.gbl...
> Hi Everyone,
> I'm investigating a software called Live Vault (http://www.livevault.com)
> whose purpose is to continuously monitor and record changes in a SQL
> Server
> database, at the database file level, and periodically send these changes
> to
> a remote server where they're applied to matching files. In essence, it's
> kind of up-to-the-minute backup of the database.
> I am unsure about how this software is going to perform and/or affect the
> database and I'm very interested in hearing from anyone who has experience
> with this software.
> Any information, thoughts and opinions regarding this tool is greatly
> appreciated.
> Lou
>|||Mike,
Thank you very much for your input.
I do nightly full database backups and hourly transaction log backups during
business hours every day and copy these backups onto tape each night. This
leaves a potential one-day data loss in case of catastrophic failure.
Management sees Live Vault as a way to have an "up-to-the-minute" database
backup. Our systems group has had success using Live Vault to restore basic
user files e.g. Word documents or PDF documents, that sort of thing.
However, I am very suspicious of a product that monitors live SQL Server
data files. It sounds wonderful in theory but I've always been very leary
of the kind of bit level monitoring that's required.
I am really hoping someone on the newsgroup is using or has used the product
and could give a first hand account of their experiences. If there's anyone
out there reading this, I'd love to hear your honest assessment of the
product, any problems you've had and the support you received from Live
Vault addressing problems.
Best regards,
Lou
Louis Marchand
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:etHYsWZTFHA.1384@.TK2MSFTNGP09.phx.gbl...
> Hi
> They do not state on their case studies exactly what OS's and Database
> products are supported. Not a word about SQL Server on their site.
> Ask the vendor if they have certified their product for SQL Server.
> And don't forget, picking up the bits off disk, shipping them over a
> connection, does induce performance limitations, and if your data were to
go
> corrupt on the local drive, the corruption is faithfully copied to them.
> A service like this does not eliminate the need for regular Database and
Log
> dumps.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Louis Marchand" <lmarch@.safetrans.com> wrote in message
> news:eooNWKQTFHA.4056@.TK2MSFTNGP15.phx.gbl...
(http://www.livevault.com)[vbcol=seagreen]
changes[vbcol=seagreen]
it's[vbcol=seagreen]
the[vbcol=seagreen]
experience[vbcol=seagreen]
>