Relay Error Using Database Mail

SQL 2005 SP1
Windows Server 2003 SP1
Exchange 2000
I am getting this error sending a Maintenance Plans report to an email
recipient. It only happens sending to an external email address.
The mail could not be sent to the recipients because of the mail server
failure. (Sending Mail using Account 2 (2007-02-06T08:01:25). Exception
Message: Cannot send mails to mail server. (Mailbox unavailable. The server
response was: 5.7.1 Unable to relay for myaddress@.domain.com).
)
This is an issue correct-able at your SMTP server; it has nothing to do with
database mail (unless you have a more open internal SMTP server available,
that you could use instead).
A
"John Oberlin" <JohnOberlin@.discussions.microsoft.com> wrote in message
news:A35C82BD-00DA-414F-8071-2DD5F11EF010@.microsoft.com...
> SQL 2005 SP1
> Windows Server 2003 SP1
> Exchange 2000
> I am getting this error sending a Maintenance Plans report to an email
> recipient. It only happens sending to an external email address.
> The mail could not be sent to the recipients because of the mail server
> failure. (Sending Mail using Account 2 (2007-02-06T08:01:25). Exception
> Message: Cannot send mails to mail server. (Mailbox unavailable. The
> server
> response was: 5.7.1 Unable to relay for myaddress@.domain.com).
> )
|||Thanks for the reply. So what do I have to do on Exchange to correct this?
|||Well, you could open up external SMTP relay from the IP address of your SQL
Server(s). I am not an Exchange administrator. So for more specific
details, if you don't get a quick enough response here, you'll ghave better
luck in an Exchange newsgroup.
If you have a simple SMTP server running on an IIS box somewhere inside your
network, that you can use for this, I can help with specific instructions
there. Database Mail does not require Exchange, and depending on your
requirements, you may not want to mix the two.
A
"John Oberlin" <JohnOberlin@.discussions.microsoft.com> wrote in message
news:D989979C-3692-4C0D-9BA9-87523863ED45@.microsoft.com...
> Thanks for the reply. So what do I have to do on Exchange to correct
> this?
sql

Relay Error Using Database Mail

SQL 2005 SP1
Windows Server 2003 SP1
Exchange 2000
I am getting this error sending a Maintenance Plans report to an email
recipient. It only happens sending to an external email address.
The mail could not be sent to the recipients because of the mail server
failure. (Sending Mail using Account 2 (2007-02-06T08:01:25). Exception
Message: Cannot send mails to mail server. (Mailbox unavailable. The server
response was: 5.7.1 Unable to relay for myaddress@.domain.com).
)This is an issue correct-able at your SMTP server; it has nothing to do with
database mail (unless you have a more open internal SMTP server available,
that you could use instead).
A
"John Oberlin" <JohnOberlin@.discussions.microsoft.com> wrote in message
news:A35C82BD-00DA-414F-8071-2DD5F11EF010@.microsoft.com...
> SQL 2005 SP1
> Windows Server 2003 SP1
> Exchange 2000
> I am getting this error sending a Maintenance Plans report to an email
> recipient. It only happens sending to an external email address.
> The mail could not be sent to the recipients because of the mail server
> failure. (Sending Mail using Account 2 (2007-02-06T08:01:25). Exception
> Message: Cannot send mails to mail server. (Mailbox unavailable. The
> server
> response was: 5.7.1 Unable to relay for myaddress@.domain.com).
> )|||Thanks for the reply. So what do I have to do on Exchange to correct this?|||Well, you could open up external SMTP relay from the IP address of your SQL
Server(s). I am not an Exchange administrator. So for more specific
details, if you don't get a quick enough response here, you'll ghave better
luck in an Exchange newsgroup.
If you have a simple SMTP server running on an IIS box somewhere inside your
network, that you can use for this, I can help with specific instructions
there. Database Mail does not require Exchange, and depending on your
requirements, you may not want to mix the two.
A
"John Oberlin" <JohnOberlin@.discussions.microsoft.com> wrote in message
news:D989979C-3692-4C0D-9BA9-87523863ED45@.microsoft.com...
> Thanks for the reply. So what do I have to do on Exchange to correct
> this?

Relay Error Using Database Mail

SQL 2005 SP1
Windows Server 2003 SP1
Exchange 2000
I am getting this error sending a Maintenance Plans report to an email
recipient. It only happens sending to an external email address.
The mail could not be sent to the recipients because of the mail server
failure. (Sending Mail using Account 2 (2007-02-06T08:01:25). Exception
Message: Cannot send mails to mail server. (Mailbox unavailable. The server
response was: 5.7.1 Unable to relay for myaddress@.domain.com).
)This is an issue correct-able at your SMTP server; it has nothing to do with
database mail (unless you have a more open internal SMTP server available,
that you could use instead).
A
"John Oberlin" <JohnOberlin@.discussions.microsoft.com> wrote in message
news:A35C82BD-00DA-414F-8071-2DD5F11EF010@.microsoft.com...
> SQL 2005 SP1
> Windows Server 2003 SP1
> Exchange 2000
> I am getting this error sending a Maintenance Plans report to an email
> recipient. It only happens sending to an external email address.
> The mail could not be sent to the recipients because of the mail server
> failure. (Sending Mail using Account 2 (2007-02-06T08:01:25). Exception
> Message: Cannot send mails to mail server. (Mailbox unavailable. The
> server
> response was: 5.7.1 Unable to relay for myaddress@.domain.com).
> )|||Thanks for the reply. So what do I have to do on Exchange to correct this?|||Well, you could open up external SMTP relay from the IP address of your SQL
Server(s). I am not an Exchange administrator. So for more specific
details, if you don't get a quick enough response here, you'll ghave better
luck in an Exchange newsgroup.
If you have a simple SMTP server running on an IIS box somewhere inside your
network, that you can use for this, I can help with specific instructions
there. Database Mail does not require Exchange, and depending on your
requirements, you may not want to mix the two.
A
"John Oberlin" <JohnOberlin@.discussions.microsoft.com> wrote in message
news:D989979C-3692-4C0D-9BA9-87523863ED45@.microsoft.com...
> Thanks for the reply. So what do I have to do on Exchange to correct
> this?

Relative Dates

When attempting to use the 'relative dates' functionality of the Report Builder component, I'm getting an error that states "The report may not be valid or the server could not process the data" then in the detail section it says that the field I'm using (an obvious date field) is being interpreted as an integer. If I use an absolute date, it works just fine, just errors out when I use a relative date.

My questions...has anyone else come accross this error? Is it a known issue? Is there a way around it that anyone knows of? I suspect it's a glitch in this new product but really need to know for sure.

Any references to MS topics on this would be hugely appreciated as well.

Thanks...Ooogy

I’m not aware of any known issues like the one you describe. Can you
give more precise repro steps?

Relationships between Report and SubReport

Hi,
Is there any way to establish a relationship between multiple datasets
generated at the report level?
For example is it possible to run two queries and reference the columns to
do in memory joins? The client we are working for has a poor data structure
and unfortunately our hands are tied so we need to work with multiple
queries across datasets.
Thanks for any info!
RonThe way you do this is with subreports. There is no way to join in memory
datasets.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"RSH" <way_beyond_oops@.yahoo.com> wrote in message
news:u%23Fc%23e04HHA.5316@.TK2MSFTNGP04.phx.gbl...
> Hi,
> Is there any way to establish a relationship between multiple datasets
> generated at the report level?
> For example is it possible to run two queries and reference the columns to
> do in memory joins? The client we are working for has a poor data
> structure and unfortunately our hands are tied so we need to work with
> multiple queries across datasets.
> Thanks for any info!
> Ron
>

Re-installing RS 2000 report designer

I am somewhat of an RS newbie -- many months ago I installed RS (using sql
v2K, VS 2005) and created a handful of projects - nothing crazy, but they
worked. Recently I needed to get in there and either edit an existing or
create a new one, but I am unable to do so. In VS, start page, if I hit my
project, it fails w/this error:
The application for projetc 'D:\Projects\....\Project Name.rptproj' is not
installed.
Make sure the application for the project type (.rptproj) is installed.
I have tried everything - I even removed and reinstalled VS. Still get the
same error, nothing works.
In VS, New Project, Business Intelligence Projects is no longer available.
Also, all reports are available/visible via Report Manager. I just can't
get into VS to access/edit them, or to create new ones.
I've done a little surfing, have seen indication that I may need to
re-install the report designer. Is that correct, and if so, how do I do that?
Any advice at all really is appreciated.
-- LynnCan anybody tell me how to uninstall/reinstall RS 2000 report designer?
-- Lynn
"Lynn" wrote:
> I am somewhat of an RS newbie -- many months ago I installed RS (using sql
> v2K, VS 2005) and created a handful of projects - nothing crazy, but they
> worked. Recently I needed to get in there and either edit an existing or
> create a new one, but I am unable to do so. In VS, start page, if I hit my
> project, it fails w/this error:
> The application for projetc 'D:\Projects\....\Project Name.rptproj' is not
> installed.
> Make sure the application for the project type (.rptproj) is installed.
> I have tried everything - I even removed and reinstalled VS. Still get the
> same error, nothing works.
> In VS, New Project, Business Intelligence Projects is no longer available.
> Also, all reports are available/visible via Report Manager. I just can't
> get into VS to access/edit them, or to create new ones.
> I've done a little surfing, have seen indication that I may need to
> re-install the report designer. Is that correct, and if so, how do I do that?
> Any advice at all really is appreciated.
> -- Lynn

Re-installing Report Server

I had to uninstall Report Server and Report Designer on are
SQL server machine because of bandwidth concerns. Instead, Im installing
Report Server and Report Designer on a different member server. However the
Report databases remain after the uninstall on the SQL server machine. Is
this ok for these databases to remain? Will the new install try and create a
separate set of databases? I've already run RSkeymgmnt utility and saved the
key file. Is there a different procedure to follow in reinstalling on a
different server? By the way no work was done on the first installation, so
these databases really contain no important data.
MarkIf you don't need the databases, you can delete them. You only needed to
save the key file if you were planning to reuse the old database.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mark C" <MarkC@.discussions.microsoft.com> wrote in message
news:E80AE112-31C1-4FA0-BFF5-5A6595C339C8@.microsoft.com...
>I had to uninstall Report Server and Report Designer on are
> SQL server machine because of bandwidth concerns. Instead, Im installing
> Report Server and Report Designer on a different member server. However
> the
> Report databases remain after the uninstall on the SQL server machine. Is
> this ok for these databases to remain? Will the new install try and create
> a
> separate set of databases? I've already run RSkeymgmnt utility and saved
> the
> key file. Is there a different procedure to follow in reinstalling on a
> different server? By the way no work was done on the first installation,
> so
> these databases really contain no important data.
> Marksql

Reinstall problem with Report Services

I have been playing with my Standard version of SQL Server with no problems. Now I wanted to start exploring Reporting Services, however whenever I tried to connect to the instance through the Management Studio, it would fail. I did notice that the folder in IIS was not present so I am thinking it was something I failed to do in the initial setup.

I have uninstalled everything, but when it gets to Reporting Services, I get an error message "The setup failed to read IISMiniMap table. Error Code -2147024893." I did a search on various newsgroups and forums and found a message about installing and running some Microsoft Cleanup utility. I did this, but I am still getting the error message and then the uninstall rolls everything back.

What do I need to do here, short of doing a total reformat of the harddrive and just reinstall everything?

Thanks for the information.

To add to this problem, I uninstalled all that I could with my original instance of SQL Server (minus Reporting Services). Now I have reinstalled a new instance that also created a new instance of Reporting Services. However when I go to IIS, it says that the Report Server is stopped and I cannot restart it. I get the error "The request is not supported".

What is up with this?

Reindexing can cause slowness?

I have a database that I recently reindexed (all tables) and users are
complaining of slow report performance. What could cause this? Is it updating
statistics some how? Or rebuilding the cache?
I ran the same complaint reports on the same database on another server that
was not reindexed and the reports ran just fine.
Auto update and auto create statistics are checked in the above databases.
Thank you in advance.
--
Message posted via http://www.sqlmonster.comDid you check (and compare!) execution plans on each server?
A
"fnadal via SQLMonster.com" <u10790@.uwe> wrote in message
news:7d53e85ad059a@.uwe...
>I have a database that I recently reindexed (all tables) and users are
> complaining of slow report performance. What could cause this? Is it
> updating
> statistics some how? Or rebuilding the cache?
> I ran the same complaint reports on the same database on another server
> that
> was not reindexed and the reports ran just fine.
> Auto update and auto create statistics are checked in the above databases.
> Thank you in advance.
> --
> Message posted via http://www.sqlmonster.com
>|||I was able to get statistics on the query on the database that completes the
query, I'm still waiting for the query to complete on the problem database...
I'll post when finished.
Aaron Bertrand [SQL Server MVP] wrote:
>Did you check (and compare!) execution plans on each server?
>A
>>I have a database that I recently reindexed (all tables) and users are
>> complaining of slow report performance. What could cause this? Is it
>[quoted text clipped - 8 lines]
>> Thank you in advance.
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200712/1|||Aaron might be correcting me on this ...
But I was talking to Microsoft SQL Eng. about Indexrebuild. I believe you
have to manually rebuild the statics if you do a rebuild or the statistics go
out of sync with the index information and degrade performance.
Thanks!
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"fnadal via SQLMonster.com" wrote:
> I have a database that I recently reindexed (all tables) and users are
> complaining of slow report performance. What could cause this? Is it updating
> statistics some how? Or rebuilding the cache?
> I ran the same complaint reports on the same database on another server that
> was not reindexed and the reports ran just fine.
> Auto update and auto create statistics are checked in the above databases.
> Thank you in advance.
> --
> Message posted via http://www.sqlmonster.com
>|||If you rebuild an index, the stats are updated automatically.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Mohit K. Gupta" <mohitkgupta@.msn.com> wrote in message
news:23D02E88-B53F-415C-9DF8-571EC80004B4@.microsoft.com...
Aaron might be correcting me on this ...
But I was talking to Microsoft SQL Eng. about Indexrebuild. I believe you
have to manually rebuild the statics if you do a rebuild or the statistics
go
out of sync with the index information and degrade performance.
Thanks!
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"fnadal via SQLMonster.com" wrote:
> I have a database that I recently reindexed (all tables) and users are
> complaining of slow report performance. What could cause this? Is it
> updating
> statistics some how? Or rebuilding the cache?
> I ran the same complaint reports on the same database on another server
> that
> was not reindexed and the reports ran just fine.
> Auto update and auto create statistics are checked in the above databases.
> Thank you in advance.
> --
> Message posted via http://www.sqlmonster.com
>

Reindexing can cause slowness?

I have a database that I recently reindexed (all tables) and users are
complaining of slow report performance. What could cause this? Is it updating
statistics some how? Or rebuilding the cache?
I ran the same complaint reports on the same database on another server that
was not reindexed and the reports ran just fine.
Auto update and auto create statistics are checked in the above databases.
Thank you in advance.
Message posted via http://www.droptable.com
Did you check (and compare!) execution plans on each server?
A
"fnadal via droptable.com" <u10790@.uwe> wrote in message
news:7d53e85ad059a@.uwe...
>I have a database that I recently reindexed (all tables) and users are
> complaining of slow report performance. What could cause this? Is it
> updating
> statistics some how? Or rebuilding the cache?
> I ran the same complaint reports on the same database on another server
> that
> was not reindexed and the reports ran just fine.
> Auto update and auto create statistics are checked in the above databases.
> Thank you in advance.
> --
> Message posted via http://www.droptable.com
>
|||I was able to get statistics on the query on the database that completes the
query, I'm still waiting for the query to complete on the problem database...
I'll post when finished.
Aaron Bertrand [SQL Server MVP] wrote:[vbcol=seagreen]
>Did you check (and compare!) execution plans on each server?
>A
>[quoted text clipped - 8 lines]
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums.aspx/sql-server/200712/1
|||Aaron might be correcting me on this ...
But I was talking to Microsoft SQL Eng. about Indexrebuild. I believe you
have to manually rebuild the statics if you do a rebuild or the statistics go
out of sync with the index information and degrade performance.
Thanks!
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"fnadal via droptable.com" wrote:

> I have a database that I recently reindexed (all tables) and users are
> complaining of slow report performance. What could cause this? Is it updating
> statistics some how? Or rebuilding the cache?
> I ran the same complaint reports on the same database on another server that
> was not reindexed and the reports ran just fine.
> Auto update and auto create statistics are checked in the above databases.
> Thank you in advance.
> --
> Message posted via http://www.droptable.com
>
|||If you rebuild an index, the stats are updated automatically.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Mohit K. Gupta" <mohitkgupta@.msn.com> wrote in message
news:23D02E88-B53F-415C-9DF8-571EC80004B4@.microsoft.com...
Aaron might be correcting me on this ...
But I was talking to Microsoft SQL Eng. about Indexrebuild. I believe you
have to manually rebuild the statics if you do a rebuild or the statistics
go
out of sync with the index information and degrade performance.
Thanks!
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"fnadal via droptable.com" wrote:

> I have a database that I recently reindexed (all tables) and users are
> complaining of slow report performance. What could cause this? Is it
> updating
> statistics some how? Or rebuilding the cache?
> I ran the same complaint reports on the same database on another server
> that
> was not reindexed and the reports ran just fine.
> Auto update and auto create statistics are checked in the above databases.
> Thank you in advance.
> --
> Message posted via http://www.droptable.com
>

Reindexing can cause slowness?

I have a database that I recently reindexed (all tables) and users are
complaining of slow report performance. What could cause this? Is it updatin
g
statistics some how? Or rebuilding the cache?
I ran the same complaint reports on the same database on another server that
was not reindexed and the reports ran just fine.
Auto update and auto create statistics are checked in the above databases.
Thank you in advance.
Message posted via http://www.droptable.comDid you check (and compare!) execution plans on each server?
A
"fnadal via droptable.com" <u10790@.uwe> wrote in message
news:7d53e85ad059a@.uwe...
>I have a database that I recently reindexed (all tables) and users are
> complaining of slow report performance. What could cause this? Is it
> updating
> statistics some how? Or rebuilding the cache?
> I ran the same complaint reports on the same database on another server
> that
> was not reindexed and the reports ran just fine.
> Auto update and auto create statistics are checked in the above databases.
> Thank you in advance.
> --
> Message posted via http://www.droptable.com
>|||I was able to get statistics on the query on the database that completes the
query, I'm still waiting for the query to complete on the problem database..
.
I'll post when finished.
Aaron Bertrand [SQL Server MVP] wrote:[vbcol=seagreen]
>Did you check (and compare!) execution plans on each server?
>A
>
>[quoted text clipped - 8 lines]
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200712/1|||Aaron might be correcting me on this ...
But I was talking to Microsoft SQL Eng. about Indexrebuild. I believe you
have to manually rebuild the statics if you do a rebuild or the statistics g
o
out of sync with the index information and degrade performance.
Thanks!
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"fnadal via droptable.com" wrote:

> I have a database that I recently reindexed (all tables) and users are
> complaining of slow report performance. What could cause this? Is it updat
ing
> statistics some how? Or rebuilding the cache?
> I ran the same complaint reports on the same database on another server th
at
> was not reindexed and the reports ran just fine.
> Auto update and auto create statistics are checked in the above databases.
> Thank you in advance.
> --
> Message posted via http://www.droptable.com
>|||If you rebuild an index, the stats are updated automatically.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Mohit K. Gupta" <mohitkgupta@.msn.com> wrote in message
news:23D02E88-B53F-415C-9DF8-571EC80004B4@.microsoft.com...
Aaron might be correcting me on this ...
But I was talking to Microsoft SQL Eng. about Indexrebuild. I believe you
have to manually rebuild the statics if you do a rebuild or the statistics
go
out of sync with the index information and degrade performance.
Thanks!
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"fnadal via droptable.com" wrote:

> I have a database that I recently reindexed (all tables) and users are
> complaining of slow report performance. What could cause this? Is it
> updating
> statistics some how? Or rebuilding the cache?
> I ran the same complaint reports on the same database on another server
> that
> was not reindexed and the reports ran just fine.
> Auto update and auto create statistics are checked in the above databases.
> Thank you in advance.
> --
> Message posted via http://www.droptable.com
>

Registry read in Reporting Services

Hello. I am trying to get the machine name in a Reporting Services 2000
report. I thought I would put this in the registry and read it from a
function in the custom code. Here is my first attempt:
Public Function GetMachineName
On Error Resume Next
Dim WshShell
Set WshShell = WScript.CreateObject("WScript.Shell")
Return WshShell.RegRead("HKLM\Software\Something\MachineName")
End Function
This gives a build error: Let and set are no longer supported. OK, so I take
out the set on line 3. Then it says "WScript" is not declared. I'm pretty
sure this is valid code. I got it from Windows Script Host 2.0 Documentation.
Does Reporting Services support using the WScript functionality? Thanks in
advance.I tried to do the same thing with SRS 2005 and VS 2005 but I get the error
message listed below.
'Read reg key value
my.computer.registry.GetValue(myPath, "RegKeyName", Nothing)
Error: Unhandled exception: Request for permission of type
'System.Security.Permissions.RegistryPermission
To get around this, you can do one of two things:
1. Use "Reg Query" command to read the registry and set a variable to the
the computer name
2. Use an HTA front end which will use VBScript to read the machine name and
then use the /v to pass the machine name variable from either step above.
I have an HTA front end for this very same issue so send me an email if you
want a copy.
Hope this helps!
Rafael
"Justin30519" <Justin30519@.discussions.microsoft.com> wrote in message
news:81784CFA-B08F-4CCE-85F3-C855EE8CFC7D@.microsoft.com...
> Hello. I am trying to get the machine name in a Reporting Services 2000
> report. I thought I would put this in the registry and read it from a
> function in the custom code. Here is my first attempt:
> Public Function GetMachineName
> On Error Resume Next
> Dim WshShell
> Set WshShell = WScript.CreateObject("WScript.Shell")
> Return WshShell.RegRead("HKLM\Software\Something\MachineName")
> End Function
> This gives a build error: Let and set are no longer supported. OK, so I
> take
> out the set on line 3. Then it says "WScript" is not declared. I'm pretty
> sure this is valid code. I got it from Windows Script Host 2.0
> Documentation.
> Does Reporting Services support using the WScript functionality? Thanks in
> advance.