Smtp Test
Jul 11, 2006hi,
would you know how to know if a connection can be established to an smtp server without even issuing any smtp command? i want to be able to do this using ssis, script component. thanks.
ADVERTISEMENT
Default SMTP Virtual Server Node In IIS Not Visible Even After Installing SMTP For IIS
Apr 10, 2007Hi,
I have RS 2000 running on windows 2003 server. I want user to subscribe to reports and receive reports via email. Initially SMTP was not installed for IIS 6.0, so I installed it and the right way (I had done it on different machine before and was succefull in that) but on this particular machines ...I don't see "Default SMTP Virtual Server" node when I open IIS manager.
This is the third day I am working on this issue ..please help me out guys,
prashant
Local Smtp Configure With Remote Smtp
Dec 24, 2005Hello dear
i am using windows 2003 server where i have installed smtp server
now i want to configure with remote stmp so i can send an email to any domain.
So pls tell me how it will be done.
Thanks
DB Engine :: Replicate A Master Test Database To 100 Test Environments?
Oct 12, 2015We are setting up a test lab environment with 100 machines. We want one master testing db that gets replicated to each to run scripted application tests nightly.
My goal is to minimize the amount of work to move this thing to each of the 100 test machines. I am wondering if we need to even have the sql local and invest in a monster db server with 100 copies of the db we restore and each test machine point to their own db on that server, or if I should use db mirroring or something to get the master test db to each of those machines instead.
Unit Testing For SSIS - To Test Or Not To Test?
Oct 17, 2006Now that we have a good programming model in SSIS - the question is whether to write automated unit tests for your packages, and would it generally be a good idea for packages?
Also - if yes to write tests - then where to find more informations regarding How to accomplish that?
How To Test SSis Package And What Are The Things I Need To Test It ?
Nov 27, 2007
hi every one,
i need to test SSIS pacakge which will import data from different database where record count is around 5 millions.
iam planning to test it through c# code as well as manually also.
SSIS source : consist of 7 tables
SSIS destination :consist of 7 tables
Using c# code iam trying to run ssis package through batch file.
i am putting expected rowcount, column count in an excel file and comparing same with destination tables by writing query implementing ADO.Net concept.
am i going right way ,can any one suggest best and productive way to test the ssis package .
what are the other things i need to test it.
do any one can add test cases to it.
S.No
Test Case
1
Verify all the tables have been imported.
2
Verify all the rows in each table have been imported.
3
Verify all the columns specified in source query for each table have been imported
4
Verify all the data has been received without any truncation for each column.
5
Verify the schema at source and destination
6
Verify the time taken /speed for data transfer
7
Fields truncated due to difference in length of the field at destination.
Regards
Arif shareef
SQL 2012 :: Restore DB From Prod To Test - How To Restore Users In Test
Jun 25, 2015I need to restore test DB from production backup but once it is restored I would need all the permissions of sql logins and windows AD account intact in test Db as it was before.
View 4 Replies View RelatedRs.exe And SMTP
Mar 6, 2007Hi
I'm trying to send email from my rss script. It seems that the script cannot create an SmtpClient instance because of SmtpPermission problems, but I just can't find where I need to enable the SmtpPermission. I've tried many things, including web.config and rssrvpolicy.config.
Here's a code sample:
Public Sub Main
Dim smtpClient As New System.Net.Mail.SmtpClient
End Sub
and here's the output when I execute the above script under rs.exe against my local report server
Unhandled exception:
Request for the permission of type 'System.Net.Mail.SmtpPermission, System, Version=2.0.0.0, Culture=neutral,PublicKeyToken=b77a5c561934e089' failed.
Any ideas?
Many thanks
Tony
SQL And SMTP Mail
Jun 13, 2001Does anyone have any step by step instructions for how to send smtp mail from SQL?
I guess I can use xp_cmdshell to run a vb script or something but I have no clue besides that as to what's involved.
Hope someone can help.
Deirdre
Smtp Mail
Feb 25, 2001Has anyone ever set up sql mail through smtp. I am trying to automate my server and not having to much success as i cannot use exchange for company reasons. I understand that i am able to set this up through outlook and not outlook express.
this is what i have tried to do:
1. Remove any MAPI application (Full Outlook or Microsoft Messaging from control panel). It is important that there are no mapi profiles on the server.
2. Logon to the SQL server using the SQLService account
3. Check that Outlook Express is the default Mail client (done from IE/tools/Internet Options/Programs)
4. Check that there is a mail account configured, pointing to an SMTP server, say aklexch1 (just put bogus stuff in for the POP server)
5. test that you can send a message (ignoring the receive errors) from Outlook Express to your @advantagegroup.co.nz address
Only after step 5 is working should you start testing from SQL
6. In SQL Mail config you will not see any profiles in the list but just type 'Default'
7. Create an SQL Operator with an @advantagegroup.co.nz address and click the test button
nb:i am setting this up on an win2000 server.
SMTP & SQL Server
Jul 6, 1998I wish to send e-mail from my SQL Server, however, I do NOT want to use Exchange or MS Mail. I am looking for a very simple SMTP component that I can call from SQL.
What are my options?
Thanks in advance,
-JohnN
SMTP Notifications
Sep 24, 2007Hi
How to Create SMTP Notifications using SQL Server 2000.
Thanks & Regards
-Raj
Raj.
Sql Mail Smtp Problem
Jan 25, 2001I am using a unix terminal via sendmail (which i assume is compliant), I have set up mail client in outlook express called SQLService. My main issue is that no mapi profile can be located on the server and sql server agent is recieving login failed attempts when I a attempt to start it! any ideas
------------
Damien Harris at 1/25/01 7:29:49 PM
Can anyone adivise me with setting up mail in SQL 7. Unfortunatly I am unable to use the usual mail client for security reasons, thus I am attempting to use a mail account through express specifying a smtp address. I keep recieving Mapi and logon errors when starting mail and service manager.
Can anyone help! thanks
--------------------------------------------------------------------------------
Big SMTP MAIL Problems
Jan 29, 2001Has anyone got deatils on how to go about setting up sql through an smtp client. I am unable to configure the automation service through outlook express as I understand that it is not supported. I am using a unix terminal via sendmail (which i assume is compliant), I have set up mail client in outlook express called SQLService (service account) and an exchange account. My main issue is that no mapi profile can be located in SQL mail and sql server agent is recieving login failed attempts when I attempt to start it! Can anyone adivise me with setting up mail in SQL 7
I keep recieving Mapi and logon errors when starting mail and service manager. I have also tried using a internet mail account which has not worked either. I have been told that sql mail should have a default mail client that I have specified as the SQL service account. Any feedback or advise in this area would be extremley helpful as I am stumped at the moment.
Mail Using SMTP Server
Jan 19, 2005Have anyone been able to set up mail using a SMTP server successfully?
Is it necessary to have a mailbox for outgoing mail on the SMTP server?
Thanks
Lystra
SMTP Error On SQL 2005
Dec 10, 2007Has anybody seen this error.
the SMTP somehow seems to work, but the SQL server is not able to send out notifications for jobs.
Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2007-12-10T08:41:06). Exception Message: Could not connect to mail server. (No connection could be made because the target machine actively refused it).
)
I have searched a whole lot of web and nothing nothing nothing.
Any help is welcome
Regards
Paresh Motiwala
The SMTP Server In Xp_smtp_sendmail
Sep 23, 2005Just trying out xp_smtp_sendmail for the first time.I get the error:Error: connecting to server smarthostOK, so I don't have the server parameter for SMTP server set upcorrectly.I don't even know what an SMTP Server is! Is this an e-mail providerthat provides SMTP functionality, or an application I need to install?
View 4 Replies View RelatedSpecifying A Username And Password For SMTP
Nov 9, 2005How do I specify the SMTP username and password for reporting services? It seems like I can specify one for SQLmail, but not reporting services? How the heck is anyone going to use the email feature of reporting services without being able to specify smtp credentials or making their mail server an open relay for spam??
View 16 Replies View RelatedSMTP Notifications In SQL Server 2000
Sep 24, 2007Hi
How to create SMTP notifications using SQL Server 2000?
could you please gimme some usefull URLs.
Thanks & Regards
Sending An E-mail Via SMTP In SQL Server
Jul 20, 2005Hello,Does anyone know how I can set SQL Server up so that after it hascompleted a backup sucessfully it will send the completion report toan e-mail address via SMTP.Unfortunatly we cannot install MS OUTLOOK Express or similar.Is this possible?Many thanks in advance,Allan Martin
View 2 Replies View RelatedSSIS SMTP Connection Manager
Dec 3, 2006I plan to send a email from SSIS package after performing a task.
In order to do that, I need to incoporate my account Name and Password in SMTP connection Manager in order to connect to SMTP server in Yahoo.
How can I do that ?
Using IS For Email Notification With Gmail Smtp
Nov 12, 2007
Hi,
I want to setup a SMTP using gmail. How to configure it, it says,
In your email client software, under Outgoing mail, set the SMTP server to smtp.gmail.com.
Set the your username is yourgooglemailname@gmail.com and make sure "Use username and password" is checked.
Also check off "TLS" under "Use secure connection."
I tried to do this in code:
Dim htmlMessage As MailMessage
Dim mySmtpClient As SmtpClient
htmlMessage = New MailMessage(From, SendTo, Subject, Body)
htmlMessage.IsBodyHtml = IsBodyHTML
mySmtpClient = New SmtpClient(Server)
Dim myCred As New System.Net.NetworkCredential("myemail@gmail.com", "mypassword") 'CredentialCache
mySmtpClient.UseDefaultCredentials = False 'Credentials = System.Net.CredentialCache.DefaultNetworkCredentials
mySmtpClient.Credentials = myCred
mySmtpClient.Send(htmlMessage)
however, i cannot do the turning off of TLS in code. I'm often prompted with this error once i run:
The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.7.0 Must issue a STARTTLS command first
Anyone who knows how to do this?
cherriesh
Generate A Email Using Smtp Server (was Help With Query....)
Jan 21, 2005Help with query: I currently cannot be alerted by SQL Mail so I would like to take the script that was generated by SQL server and using the store procedure sp_sqlsmtpmail to generate a email using smtp server to alert me. The store procedure does work. I would like to know if this is possible.
Thanks
Lystra
-- Script generated on 1/21/2005 10:04 AM
-- By: MAMSIsa
-- Server: (local)
IF (EXISTS (SELECT name FROM msdb.dbo.sysalerts WHERE name = N'Demo: Full tempdb'))
---- Delete the alert with the same name.
EXECUTE msdb.dbo.sp_delete_alert @name = N'Demo: Full tempdb'
BEGIN
EXECUTE msdb.dbo.sp_add_alert @name = N'Demo: Full tempdb', @message_id = 9002, @severity = 0, @enabled = 1, @delay_between_responses = 10, @include_event_description_in = 5, @database_name = N'tempdb', @category_name = N'[Uncategorized]'
Then
Exec sp_sqlsmtpmail
@vcTo = 'lwilliams@Huc.com',
@vcBody ='Check out problem Immediataly.',
@vcSubject ='DOCSITE01FDK - Full Tempdb Log'
END
Cdonts Send Mail T-SQL - IIS SMTP Setup
Feb 22, 2006hello,
I would like to send mail from sql server using CDONTS.
I have the sql code for this and it works for internal addresses.
I get an error/warning saying that it cannot relay for external addresses when I try an outside domain.
Is there settings in IIS for the SMTP service that I can change to allow it to relay to the external domains?
I have everything running on the SQL Server, and I do not have access to the exchange server.
Thanks
SSIS Dynamic SMTP Mail Server
Sep 13, 2006SSIS dynamic SMTP mail server
Hi All,
I'm trying to make my SEND MAIL TASK in SSIS dynamic, by retrieving SMTP Server name (amongst other email message information) from a table.
I've got an SP that is getting the information into package variable's, and when I don't try and have a dynamic server name (i.e. I use a specified SMTP server in my SMPT Server connection), then the email get sent off.
I'm trying to use an expression to build alter the send mail to use the server name I have in a user variable.
I've tried using the expression for the property:
SmtpConnection set to: RTRIM( @[User::MailServer])
I also tried without the RTRIM - I only added it because the error messages seem to include a full 'string' length, and there doesn't seem to be a 'varchar' data type for SSIS variables.
so:
a> Is SMTPConnection the property I need to be setting? None of the others seem correct
b> If SMTPConnection IS the property I need, does the value give the SMTP Server Name, or just the Name of the connection from the Connection Manager's?
Thanks
Part-Answer to:
b> The SMPTConnection property sets the name of the CONNECTION to be used. That Connection needs to set the name of the server. So n ow, the question becomes, how do I configure that from SQL (I know how to use package configurations from XML files).
Subscription Problem With Local SMTP Server
Oct 17, 2007
Hello,
I am trying to create standard subscriptions using local SMTP server. When i create a subscription with no parameters, the reports and delivered via email. If I try to subscibe to a report with parameters and setting the parameter values , the subscription fails. The Data Source credentials are stored., The same report without parameters is delivered.
Here is the log.
ReportingServicesService!library!10!10/17/2007-12:10:07:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
ReportingServicesService!emailextension!10!10/17/2007-12:10:07:: Error sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'DS1'. ---> System.InvalidOperationException: ExecuteReader: CommandText property has not been initialized
at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.DataExtensions.SqlCommandWrapperExtension.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery()
Please help !!
SQL 2000 Reporting Services And SMTP Server
Oct 23, 2007
Hi,
When i try to send an email from SQL 2000 reporting services, i get error "The underlying connection was closed: Unable to connect to the remote server" . In a different environment the same settings is working.
The only difference is that in first case, SMTP server and SQL 2000 reporting server are in different domain. But i have tested SMTP server connectivity from the reportserver using DOS command. It works good.
Please help me
Regards,
Shakeela
SMTP Authentication In Send Mail Task
Apr 28, 2006Hi
I am new to the SSIS package and was trying to figure out how to use SMTP authetication with a 'Send Mail Task' Our company's server requries SMTP authentication for mail. The Send Mail task only allows for Windows authentication.
What can I do to get the SMTP authentication to work for the Send Mail Task?
Regards,
James Robb
Why Do I Get The Following SMTP Email Error In A SSIS Package
Mar 2, 2007I am running a SSIS package under a trusted account and I am running into a problem when I am executing a email task. The error is an operation timeout which was reported in the log. I am using windows authentication on the connection manager. Other email task configured the exact same way run correctly in the same run. Also when I execute task from BIDS the email is sent. Is there a bug in SSIS which would cause this behavior or some kind of exchange server configuration issue? Any help would be appreciated. Thanks, Greg
View 5 Replies View RelatedHow Do I Use A Secure Non-windows Smtp Server With Ssis?
May 17, 2006my package requires a send mail task and i must use a secure non-windows smtp server. can someone please tell me how to configure the smtp connection manager so i can do this? thanks.
View 6 Replies View RelatedRsreportserver.config Smtp Password Settings
Dec 22, 2005
Hi,
I wanted to know if there was any way of setting the SMTPAuthenticate in the RSReportServer.config file, so i could connect to a remote SMTP with username and password ?
I am using window 2003 system where smtp is not installed and i don't want to installed it.
If there is another way to change only in Rsreportserver.config file except pick up directory.
thanks in advance
Ashok kumar yadav
SMTP Connection Manager Connections Aren't Shared?
Sep 29, 2006Dear all,
I'm seeing that SMTP Connection Manager connections aren't shared between .dtsx.
Why not?
Let me know
TIA
How To Send Email Using Asp.net 2.0 And How To Find The Smtp Mail Server Name?
Dec 19, 2006How to send email using asp.net 2.0 and how to find the smtp mail server name?
View 1 Replies View Related