HI i have to automate my report using sub

1.I have configured SMTP server in the configuration settings

2. I have created subscitption using my report,But i here i will found one error.

Please find the 

failed to send email report ,The transport failed to connect to the server

and can u please help me out for this

when i check in the loge files it will show this error below

No DSN present in configuration file, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;

• Edited by Ychinnari Friday, February 06, 2015 3:00 PM

Hi Chinnari,

Please check below url.

https://social.microsoft.com/Forums/en-US/a64b79b7-19f4-40c0-96bc-81b95766ec6d/failure-sending-mail-the-transport-failed-to-connect-to-the-server?forum=crm

Regards,

Hi Ychinnari,

According to your description, the subscription failed with the error No DSN present in configuration file, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ; .

In Reporting Services, DSN property contains a connection to the report server database, when you setup a report server database in RSCM, DSN property will be added in configuration file. In your scenario, please check if you have set up the connection to a report server database. Please refer to this article: Reporting Services 2008 Configuration Mistake. If the Report Server database you are connecting to exists in another server, you should also grant the user db_owner role on master and MSDB database. Please refer to the last reply of this link: Problems Configuring Reporting Services to use a database on another server.

If you have any question, please feel free to ask.

Best regards,
Qiuyun Yu

I have change the settings as u suggested but still not able to send the mail .

its shows me the same error mesg

<Header>
  <Product>Microsoft SQL Server Reporting Services Version 2009.0100.1600.01 ((KJ_RTM).100402-1539 )</Product>
  <Locale>English (United States)</Locale>
  <TimeZone>W. Europe Standard Time</TimeZone>
  <Path>C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVEREPORT\Reporting Services\Logfiles\ReportServerService__02_10_2015_03_44_06.log</Path>
  <SystemName>WEGDACM1</SystemName>
  <OSName>Microsoft Windows NT 6.1.7601 Service Pack 1</OSName>
  <OSVersion>6.1.7601</OSVersion>
  <ProcessID>10420</ProcessID>
  <Virtualization>Hypervisor</Virtualization>
</Header>
rshost!rshost!28d0!02/10/2015-03:44:06:: i INFO: Currently registered url http://+:80/ReportServer_MSSQLSERVEREPORT/ on endpoint 2
rshost!rshost!28d0!02/10/2015-03:44:06:: e ERROR: Failed to register url=http://+:80/Reports/ for endpoint 3, error=b7.
rshost!rshost!28d0!02/10/2015-03:44:06:: w WARN: Endpoint 3 is enabled but no url is registered for vdir=/Reports, pdir=C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVEREPORT\Reporting Services\ReportManager.
servicecontroller!DefaultDomain!28f4!02/10/2015-03:44:06:: e ERROR: Error creating HTTP endpoint. System.Runtime.InteropServices.COMException (0x800700B7): Cannot create a file when that file already exists. (Exception from HRESULT: 0x800700B7)
   at Microsoft.ReportingServices.HostingInterfaces.IRsUnmanagedCallback.CreateHttpEndpoint(RsAppDomainType application, String[] urlPrefixes, Int32 cPrefixes, String[] hosts, Int32 cHosts, Boolean wildCardPresent, String virtualDirectory, String filePath, Int32 authType, Int32 logonMethod, String authDomain, String authRealm, Boolean authPersist, Int32 extendedProtectionLevel, Int32 extendedProtectionScenario, Boolean enabled)
   at Microsoft.ReportingServices.Library.ServiceAppDomainController.SetWebConfiguration(RunningApplication rsApplication, Boolean enabled, String folder)
rshost!rshost!28d0!02/10/2015-03:44:06:: i INFO: Endpoint 4 is disabled and no url is registered vdir=/ReportServer_MSSQLSERVEREPORT/ReportBuilder, pdir=C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVEREPORT\Reporting Services\ReportServer\ReportBuilder.
rshost!rshost!28f4!02/10/2015-03:44:06:: i INFO: Derived memory configuration based on physical memory as 16776696 KB
servicecontroller!DefaultDomain!28f4!02/10/2015-03:44:06:: i INFO: Recycling the service from the default domain
rshost!rshost!28f4!02/10/2015-03:44:17:: i INFO: Application domain type WindowsService statistics: created: 10, unloaded: 10, failed: 0, timed out: 0.
appdomainmanager!DefaultDomain!28f4!02/10/2015-03:44:17:: i INFO: Appdomain:12 WindowsService_10 started.
library!WindowsService_10!28f4!02/10/2015-03:44:17:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: No DSN present in configuration file, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;
servicecontroller!WindowsService_10!28f4!02/10/2015-03:44:17:: e ERROR: Error initializing configuration from the database: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. 
resourceutilities!WindowsService_10!28f4!02/10/2015-03:44:18:: i INFO: Reporting Services starting SKU: Enterprise
servicecontroller!WindowsService_9!28f4!02/10/2015-03:44:18:: i INFO: Service controller exiting.
appdomainmanager!DefaultDomain!28f4!02/10/2015-03:44:18:: i INFO: Appdomain:11 unregistered.
appdomainmanager!DefaultDomain!28f4!02/10/2015-03:44:18:: i INFO: Appdomain:11 WindowsService_9 unloading.
appdomainmanager!DefaultDomain!e24!02/10/2015-03:44:18:: i INFO: AppDomain:11 0 pending unload(s)
library!WindowsService_10!19f0!02/10/2015-03:44:18:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: No DSN present in configuration file, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;
library!WindowsService_10!19f0!02/10/2015-03:44:18:: e ERROR: ServiceStartThread: Exception caught while starting service. Error: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. 
library!WindowsService_10!19f0!02/10/2015-03:44:18:: e ERROR: ServiceStartThread: Attempting to start service again...
library!DefaultDomain!1ca8!02/10/2015-10:55:23:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: No DSN present in configuration file, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;

This is my Logfile can u pls go through it and resolve my issue.

• Edited by Ychinnari Tuesday, February 10, 2015 10:22 AM

Hi,

https://connect.microsoft.com/SQLServer/feedback/details/514292/reporting-services-2008-cannot-create-http-endpoint-with-a-wildcard-ssl-cert

Hope it helps.

I have changed the configuration settings and there it creates the DSN connection in the configuration manager,

But in the Configuration file we will not find any DSN connection ,

and my reportServer database should exist in the same server it self.

still not able to send the email to the respect team

and still is showing the same error like below

-------------------------------------------------------------------

<Configuration>
<Dsn>
</Dsn>
<ConnectionType>Default</ConnectionType>
<LogonUser></LogonUser>
<LogonDomain></LogonDomain>
<LogonCred></LogonCred>

----------------------------------------------------------------------

No DSN present in the configuration file but it is empty, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;

Can you please update this 

it is very urgent basis

Regards

Thanks!

• Edited by Ychinnari Tuesday, February 17, 2015 12:10 PM

Hi Chinnari,

Use below link might be helpful to you.

https://discussitnow.wordpress.com/2009/12/17/scom-report-subscription-%E2%80%9Cfailure-sending-mail-the-transport-failed-to-connect-to-the-server%E2%80%9D/

http://support.citrix.com/article/CTX112216

Hi Chinnari,

Please check below link might be helpful to you..

http://www.sqlservercentral.com/Forums/Topic487264-150-1.aspx

Regards,

You have  to modify the first computer's Delegation records in Active Directory to make it a trusted server. Once that happens, it should allow it to pass on the user's authentication. I don't have domain admin rights to our server so I haven't been able to try it myself, but I have bumped into this same issue a few times.

Edit: Another option may be to allow SQL Server Authentication and create a user account in SQL Server. Then you'll be able to bypass the Kerberos restraints and SQL Server can pass the login.

First check you can able to ping telnet SMTP server with 25 

once done then try to send email from CMD which will you using following link.

http://www.wikihow.com/Send-Email-Using-Telnet

Any query Let me know.

• Edited by Dinesh Vishe 11 minutes ago
• Proposed as answer by Dinesh Vishe 10 minutes ago