Error when sending scheduled report

We are using SQL Server 2005 SP2. We have setup the RS smtp configuration
and we we have created scheduled reports, but we get an error when the
report is emailed. If I understand correctly, the account name/password
that is used for authentication is the account name used for the SQL Server
Reporting Services service. I have edit the rsreportserver.config file and
changed the SMTPAuthenticate to 2. The SMTP server is configured to point
to an external SMTP server.
The error we receive is: Failure sending mail: The message could not be sent
to the SMTP server. The transport error code was 0x80040217. The server
response was not available.Make sure that you don't have an antivirus/firewall blocking port 25 because
it sounds like your report server is not able to innitiate a connection to
the mail server. You can also try telnetting your smtp server from your
report server on port 25 by typing "telnet smtpservername 25" at the comand
prompt on the report server. If that commnad times out then you have a
netwroking problem whether it be a physical problem, a routing problem or a
firewall problem.
"Tim Kelley" <tkelley@.company.com> wrote in message
news:uESIb0ljHHA.4936@.TK2MSFTNGP03.phx.gbl...
> We are using SQL Server 2005 SP2. We have setup the RS smtp configuration
> and we we have created scheduled reports, but we get an error when the
> report is emailed. If I understand correctly, the account name/password
> that is used for authentication is the account name used for the SQL
> Server Reporting Services service. I have edit the rsreportserver.config
> file and changed the SMTPAuthenticate to 2. The SMTP server is configured
> to point to an external SMTP server.
> The error we receive is: Failure sending mail: The message could not be
> sent to the SMTP server. The transport error code was 0x80040217. The
> server response was not available.
>|||I was able to connect to the smtp server from our RS server. Any other
ideas?
Could it be an authentication issue?
Thanks,
Tim
"TJ Davis" <TJDavis@.sagu.edu> wrote in message
news:eumMVKmjHHA.4248@.TK2MSFTNGP06.phx.gbl...
> Make sure that you don't have an antivirus/firewall blocking port 25
> because it sounds like your report server is not able to innitiate a
> connection to the mail server. You can also try telnetting your smtp
> server from your report server on port 25 by typing "telnet smtpservername
> 25" at the comand prompt on the report server. If that commnad times out
> then you have a netwroking problem whether it be a physical problem, a
> routing problem or a firewall problem.
> "Tim Kelley" <tkelley@.company.com> wrote in message
> news:uESIb0ljHHA.4936@.TK2MSFTNGP03.phx.gbl...
>> We are using SQL Server 2005 SP2. We have setup the RS smtp
>> configuration and we we have created scheduled reports, but we get an
>> error when the report is emailed. If I understand correctly, the account
>> name/password that is used for authentication is the account name used
>> for the SQL Server Reporting Services service. I have edit the
>> rsreportserver.config file and changed the SMTPAuthenticate to 2. The
>> SMTP server is configured to point to an external SMTP server.
>> The error we receive is: Failure sending mail: The message could not be
>> sent to the SMTP server. The transport error code was 0x80040217. The
>> server response was not available.
>

Error using configurations files

I wanted to add all my configurations/vairbles in a config file, so I’d tried to use the Package Configuration Organizer, to create and enable package configurations…

If I want the config to contain information regarding on of my connection manageres, the package fails during test, with the following msg:

Information: 0x40016041 at OrcaleToSQLServer: The package is attempting to configure from the XML file "BDK_LABasedataDTS_config.dtsConfig".

SSIS package "OrcaleToSQLServer.dtsx" starting.

Information: 0x4004300A at Transfer data from Oracle To SQL server, DTS.Pipeline: Validation phase is beginning.

Error: 0xC0202009 at OrcaleToSQLServer, Connection manager "XXXXX.xxxx": An OLE DB error has occurred. Error code: 0x80040E21.

An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040E21 Description: "Der opstod en eller flere fejl ved en OLE DB-handling p? flere trin. Kontroller alle OLE DB-statusv?rdier. Handlingen blev ikke udf?rt.".

Error: 0xC020801C at Transfer data from Oracle To SQL server, OLE DB Source to Orcale [1]: The AcquireConnection method call to the connection manager "LASYS.lakig" failed with error code 0xC0202009.

Error: 0xC0047017 at Transfer data from Oracle To SQL server, DTS.Pipeline: component "OLE DB Source to Orcale" (1) failed validation and returned error code 0xC020801C.

Error: 0xC004700C at Transfer data from Oracle To SQL server, DTS.Pipeline: One or more component failed validation.

Error: 0xC0024107 at Transfer data from Oracle To SQL server: There were errors during task validation.

SSIS package "OrcaleToSQLServer.dtsx" finished: Failure.

Translation Danish line:

Der opstod en eller flere fejl ved en OLE DB-handling p? flere trin. Kontroller alle OLE DB-statusv?rdier. Handlingen blev ikke udf?rt -> One or more errors regarding a OLE DB-action on serveral steps. Check all OLE DB-statevalues… the action was not carried out..

See if there's anything here for you:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=142282&SiteID=1|||

Thanx...

I got it working, by ading a password to the connection string... and by disregarding all properties for at that connection manager, and just sticking to the connection string...

Your link was most helpful, thx.

Error using configurations files

I wanted to add all my configurations/vairbles in a config file, so I’d tried to use the Package Configuration Organizer, to create and enable package configurations…

If I want the config to contain information regarding on of my connection manageres, the package fails during test, with the following msg:

Information: 0x40016041 at OrcaleToSQLServer: The package is attempting to configure from the XML file "BDK_LABasedataDTS_config.dtsConfig".

SSIS package "OrcaleToSQLServer.dtsx" starting.

Information: 0x4004300A at Transfer data from Oracle To SQL server, DTS.Pipeline: Validation phase is beginning.

Error: 0xC0202009 at OrcaleToSQLServer, Connection manager "XXXXX.xxxx": An OLE DB error has occurred. Error code: 0x80040E21.

An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040E21 Description: "Der opstod en eller flere fejl ved en OLE DB-handling p? flere trin. Kontroller alle OLE DB-statusv?rdier. Handlingen blev ikke udf?rt.".

Error: 0xC020801C at Transfer data from Oracle To SQL server, OLE DB Source to Orcale [1]: The AcquireConnection method call to the connection manager "LASYS.lakig" failed with error code 0xC0202009.

Error: 0xC0047017 at Transfer data from Oracle To SQL server, DTS.Pipeline: component "OLE DB Source to Orcale" (1) failed validation and returned error code 0xC020801C.

Error: 0xC004700C at Transfer data from Oracle To SQL server, DTS.Pipeline: One or more component failed validation.

Error: 0xC0024107 at Transfer data from Oracle To SQL server: There were errors during task validation.

SSIS package "OrcaleToSQLServer.dtsx" finished: Failure.

Translation Danish line:

Der opstod en eller flere fejl ved en OLE DB-handling p? flere trin. Kontroller alle OLE DB-statusv?rdier. Handlingen blev ikke udf?rt -> One or more errors regarding a OLE DB-action on serveral steps. Check all OLE DB-statevalues… the action was not carried out..

See if there's anything here for you:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=142282&SiteID=1|||

Thanx...

I got it working, by ading a password to the connection string... and by disregarding all properties for at that connection manager, and just sticking to the connection string...

Your link was most helpful, thx.

Error upon adding configuration (After Katmai uninstall)

Hi guys. This problem is somewhat related to my other problem here. This time, whenever I add a configuration file to a package I get the an error

Constructor on type 'Microsoft.DataWarehouse.Wizards.WizardInitializer' not found (EnvDTE).

All these weird messages came out after I uninstalled Katmai June CTP. I already employed similar solutions suggested by the kind people in the thread of my first problem. I'm just not sure which wizard file and registry key to modify.
It was fixed after I installed July CTP

Error upon adding configuration (After Katmai uninstall)

Hi guys. This problem is somewhat related to my other problem here. This time, whenever I add a configuration file to a package I get the an error

Constructor on type 'Microsoft.DataWarehouse.Wizards.WizardInitializer' not found (EnvDTE).

All these weird messages came out after I uninstalled Katmai June CTP. I already employed similar solutions suggested by the kind people in the thread of my first problem. I'm just not sure which wizard file and registry key to modify.
It was fixed after I installed July CTP

Error trying to open Reporting Configuration Tool

I just installed SQL Server 2005 Express Edition and reporting services (followed the video tutorial). Whenever I try to open the Reporting Configuration Tool, it gives me the following error:

SQL Server 2005 Reporting Configuration Tool has encountered a problem and needs to close. We are sorry for the inconvience.

My only options are to Debug or Close.

I'm not sure why I am getting this error. Can anyone help?

Thanks,

Amanda

mandercruso wrote:

I just installed SQL Server 2005 Express Edition and reporting services (followed the video tutorial). Whenever I try to open the Reporting Configuration Tool, it gives me the following error:

SQL Server 2005 Reporting Configuration Tool has encountered a problem and needs to close. We are sorry for the inconvience.

My only options are to Debug or Close.

I'm not sure why I am getting this error. Can anyone help?

Thanks,

Amanda

I would recommend reinstalling the reporting services components of SQL.

|||

thanks. how can I just reinstall that component? I've uninstalled and reinstalled SQL Server 2005 Express thinking that would solve the problem, but it didn't....|||

Hmmm...If reinstalling the whole kit and kabudle didn't solve it then I would doubt that reinstalling just that component would.

It almost sounds like an operating system conflict. What does it do when you click debug?

|||

it gives me the following error:

an unhandled exception ('System.ComponentModel.Win32Exception') occurred in RSConfigTool.exe [7680].

Then it gives me the possible debuggers to choose from

|||Have you applied SP1 or SP2?

|||

Just downloaded SP2 with Advanced Options. Not sure if it matters but I have SQL Server 2000 on my machine... Visual Studio 2003 and 2005...

|||OK so you have yet to install SP2? Let us know if you still get the error after installing it.

|||

No, I meant, that's what I have originally downloaded and installed.

|||

bump... still having this problem. Does anyone know what's wrong?

error sql server configuration manager

when i open services in the computer management console i get the error message

sql server configuration manager .... error... snap in...restart mmc

Moving to the tools forum.

Mike

|||Moving to the correct forum.

error sql server configuration manager

when i open services in the computer management console i get the error message

sql server configuration manager .... error... snap in...restart mmc

Moving to the tools forum.

Mike

|||Moving to the correct forum.

Error SQL Server 2005 Express Error: 70347(0x112cb) WMI

Que tal. Al iniciar el instalador SQL Server 2005 Express me saca el error "System Configuration Checker cannot be executed due to WMI configuration on te machine..." Si alguien sabe como solucionarlo agradeceria se ayuda. Gracias.

Hi,

This is an English language forum, please translate you questions before you post them. Based on the error message, you have a problem with WMI on your computer, this is a Windows component. You can find information on diagnosing and repairing WMI problems at http://windowsxp.mvps.org/repairwmi.htm.

Mike