Email subscription Issue

We have deployed SSRS 2005 on internet using Forms authentication. every thing works just fine except the email subscription;

when a user who is part of browser role (manage individual subscription) clicks on new subscription his To field is grayed out (unable to modify) and account showing in it is the service account we use to run reporting service.

we need to give users permission to specity To, CC, BCC fields without letting them see other subscriptions.

can you help us configuring this?

Hi Aneel-

You need to go into the rsreportserver.config file located in the ReportServer folder and look for the "<SendEmailToUserAlias>" node. If it is "False", change it to "True" and you'll be able to enter e-mail addresses to send to. You will only get the "To" field, not "Cc" or "Bcc" fields.

Note you may have to restart IIS.

Regards,
Scott

Email

Do you know a tool for email sending that make authentication of user and
password in my server external smtp of my net and that she makes use of
format HTML? thanks!Since you post in a SQL Server group, I assume you want to do this from with
in SQL Server.
SQL Server 2005 has built-in support for SMTP, authentication and HTML. The
feature is called
"Database Mail".
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Diogo Guides" <DiogoGuides@.discussions.microsoft.com> wrote in message
news:A812A9D4-0C51-4443-BF1D-3C64CB0538AC@.microsoft.com...
> Do you know a tool for email sending that make authentication of user and
> password in my server external smtp of my net and that she makes use of
> format HTML? thanks!|||I use the 2000!
"Tibor Karaszi" wrote:

> Since you post in a SQL Server group, I assume you want to do this from wi
thin SQL Server.
> SQL Server 2005 has built-in support for SMTP, authentication and HTML. Th
e feature is called
> "Database Mail".
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Diogo Guides" <DiogoGuides@.discussions.microsoft.com> wrote in message
> news:A812A9D4-0C51-4443-BF1D-3C64CB0538AC@.microsoft.com...
>
>

Email

Do you know a tool for email sending that make authentication of user and
password in my server external smtp of my net and that she makes use of
format HTML? thanks!Since you post in a SQL Server group, I assume you want to do this from within SQL Server.
SQL Server 2005 has built-in support for SMTP, authentication and HTML. The feature is called
"Database Mail".
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Diogo Guides" <DiogoGuides@.discussions.microsoft.com> wrote in message
news:A812A9D4-0C51-4443-BF1D-3C64CB0538AC@.microsoft.com...
> Do you know a tool for email sending that make authentication of user and
> password in my server external smtp of my net and that she makes use of
> format HTML? thanks!|||I use the 2000!
"Tibor Karaszi" wrote:
> Since you post in a SQL Server group, I assume you want to do this from within SQL Server.
> SQL Server 2005 has built-in support for SMTP, authentication and HTML. The feature is called
> "Database Mail".
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Diogo Guides" <DiogoGuides@.discussions.microsoft.com> wrote in message
> news:A812A9D4-0C51-4443-BF1D-3C64CB0538AC@.microsoft.com...
> > Do you know a tool for email sending that make authentication of user and
> > password in my server external smtp of my net and that she makes use of
> > format HTML? thanks!
>
>

EM question....

How to know how the SQL Server is registered (Windows/SQL Authentication) in
Enterprise Manager?
SQL Server 2005.
Thank you,
John
Right-click on the server in EM and then click on Edit SQL Server
Registration Properties.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada tom@.cips.ca
www.pinpub.com
"John Smith" <JohnSmithAl@.hotmail.com> wrote in message
news:uzDPXro%23FHA.2876@.TK2MSFTNGP10.phx.gbl...
> How to know how the SQL Server is registered (Windows/SQL Authentication)
> in
> Enterprise Manager?
> SQL Server 2005.
> Thank you,
> John
>
>
>
>
|||Thank you.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23o5aPto%23FHA.3676@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> Right-click on the server in EM and then click on Edit SQL Server
> Registration Properties.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada tom@.cips.ca
> www.pinpub.com
> "John Smith" <JohnSmithAl@.hotmail.com> wrote in message
> news:uzDPXro%23FHA.2876@.TK2MSFTNGP10.phx.gbl...
Authentication)
>

EM question....

How to know how the SQL Server is registered (Windows/SQL Authentication) in
Enterprise Manager?
SQL Server 2005.
Thank you,
JohnRight-click on the server in EM and then click on Edit SQL Server
Registration Properties.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada tom@.cips.ca
www.pinpub.com
"John Smith" <JohnSmithAl@.hotmail.com> wrote in message
news:uzDPXro%23FHA.2876@.TK2MSFTNGP10.phx.gbl...
> How to know how the SQL Server is registered (Windows/SQL Authentication)
> in
> Enterprise Manager?
> SQL Server 2005.
> Thank you,
> John
>
>
>
>|||Thank you.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23o5aPto%23FHA.3676@.tk2msftngp13.phx.gbl...
> Right-click on the server in EM and then click on Edit SQL Server
> Registration Properties.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada tom@.cips.ca
> www.pinpub.com
> "John Smith" <JohnSmithAl@.hotmail.com> wrote in message
> news:uzDPXro%23FHA.2876@.TK2MSFTNGP10.phx.gbl...
> > How to know how the SQL Server is registered (Windows/SQL
Authentication)
> > in
> > Enterprise Manager?
> >
> > SQL Server 2005.
> >
> > Thank you,
> >
> > John
> >
> >
> >
> >
> >
> >
> >
>

EM question....

How to know how the SQL Server is registered (Windows/SQL Authentication) in
Enterprise Manager?
SQL Server 2005.
Thank you,
JohnRight-click on the server in EM and then click on Edit SQL Server
Registration Properties.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada tom@.cips.ca
www.pinpub.com
"John Smith" <JohnSmithAl@.hotmail.com> wrote in message
news:uzDPXro%23FHA.2876@.TK2MSFTNGP10.phx.gbl...
> How to know how the SQL Server is registered (Windows/SQL Authentication)
> in
> Enterprise Manager?
> SQL Server 2005.
> Thank you,
> John
>
>
>
>|||Thank you.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23o5aPto%23FHA.3676@.tk2msftngp13.phx.gbl...
> Right-click on the server in EM and then click on Edit SQL Server
> Registration Properties.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada tom@.cips.ca
> www.pinpub.com
> "John Smith" <JohnSmithAl@.hotmail.com> wrote in message
> news:uzDPXro%23FHA.2876@.TK2MSFTNGP10.phx.gbl...
Authentication)[vbcol=seagreen]
>

Editing USers in Enterprise Manager

Help!
We use application scripts to set up and modify users in
SQL. We are using SQL and Windows authentication. Very
occasionally, a script will fail and I will have to go in
and modify a user account directly from EM. I have done
this many times over the last 18 months and never had an
issue with it. I use the SQL Server Login Properties
dialogue box accessed from Security/Logins in EM.
Today, after I had made my changes and clicked okay, I was
immediately prompted with the "Confirm Password Change"
box. I double and triple checked (by re-executing the
task) that I had NOT in fact changed the password; I still
get the warning box. Even when I enter the CORRECT
password for the user, SQL EM warns me that the passwords
do not match and refuses to update the user account.
When I deliberately change the password and confirm the
change at the prompt, then EM accepts the changes and
proceeds.
What's going on? I tested this on three identically
configured servers and had the same results each time.
I am running:
1. SQL Server 2000 (SP3, with the latest security patch
released in July)
2. Windows 2000 Server (SP4, with the latest security
patches release in July)
3. I tested and found the problem with both Developer
Edition and Enterprise edition SQL Server.
The work-around that I have found was to go into the
Logins section for the database and make the updates
there. Note, however, that I cannot edit certain server-
wide roles in that section.
Regards,
Hugh ScottFIX: You Are Prompted for Password Confirmation After You Change a Standard
SQL Server Login
http://support.microsoft.com/?kbid=826161
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Hugh Scott" <hugh.scott@.exel.com> wrote in message
news:05e901c365ce$7ef1a5a0$a101280a@.phx.gbl...
Help!
We use application scripts to set up and modify users in
SQL. We are using SQL and Windows authentication. Very
occasionally, a script will fail and I will have to go in
and modify a user account directly from EM. I have done
this many times over the last 18 months and never had an
issue with it. I use the SQL Server Login Properties
dialogue box accessed from Security/Logins in EM.
Today, after I had made my changes and clicked okay, I was
immediately prompted with the "Confirm Password Change"
box. I double and triple checked (by re-executing the
task) that I had NOT in fact changed the password; I still
get the warning box. Even when I enter the CORRECT
password for the user, SQL EM warns me that the passwords
do not match and refuses to update the user account.
When I deliberately change the password and confirm the
change at the prompt, then EM accepts the changes and
proceeds.
What's going on? I tested this on three identically
configured servers and had the same results each time.
I am running:
1. SQL Server 2000 (SP3, with the latest security patch
released in July)
2. Windows 2000 Server (SP4, with the latest security
patches release in July)
3. I tested and found the problem with both Developer
Edition and Enterprise edition SQL Server.
The work-around that I have found was to go into the
Logins section for the database and make the updates
there. Note, however, that I cannot edit certain server-
wide roles in that section.
Regards,
Hugh Scott