We have a SQL Agent job that runs daily that sends emais out to our drivers with their schedules for the next day.  For 85% of drivers, the emails are not getting out of the SQL server. The other 15% send without error.  I checked the logs and see this error:     The mail could not be sent to the recipients because of the mail   server failure. (Sending Mail using Account 3 (2020-03-22T16:00:06).   Exception Message: Cannot send mails to mail server. (Failure sending   mail.).  )   Does anyone have any idea what's wrong, or how to get a more detailed error?   This problem started after we migrated the server to a new datacenter.   We are running SQL Server 2014 on a Windows Server 2008 R2 host.
122492
SQL Sever 2016 with the latest updates. Running on WS2012R2. Following error message is received:     The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 5 (2017-04-14T21:34:10). Exception Message: Cannot send mails to mail server. (The operation has timed out.).  )   I have tried several ways of setting up Database Mail, a mixture of precreated scripts and following the interface in SSMS.   I have also tried two different mail server credentials (Google and a Web Hosting Company), and both fail with the same error.  The Web Hosting Credentials are used on a PHP Script on another Server which works perfectly fine.  What should I check to get this working?
102523
Problem definition  Our database server needs to be transferred to an other datacenter. It runs on Microsoft SQL Server 2012 Enterprise (64-bit) and contains two databases of about 2TB and 1TB.  Having little to no downtime for this would be ideal.  Workload  Those databases are used for a .NET website and are constantly getting updated.   Having it not available over the weekend would be acceptable though. The currently in use DB would remain the only one in use until the switch over to the new one.  That switch would ideally be made just by changing DNS entries to point to the new DB server while making sure the DB is not being updated.  Also, time taken by this operation does not really matter as long as the switch from one server to the other (downtime) is kept low.  Approaches considered   Backup and restore  This has been done in the past but involved a high downtime even though it was done through an internal network, so more efficiently than through Internet Log shipping  As far as I understand, this approach would minimize downtime by configuring a master/slave and transferring  an exact copy of the master DB to its slave being read only. As mentioned above, no access to the slave would be necessary and we just need a way to have a replica of the master DB without data corruption.   It also seems to be quite efficient in terms of resources utilization and wouldn't impact to much the master performance.   I might be wrong about this approach so feel free to correct me. Database mirroring  I'm not too aware of that approach but it seems like a valid option. No need to have real time sync and performance of the master is quite important so asynchronous would be the way to go if this approach were to be chosen. Other options?  That server runs directly on bare metal hardware so lower level solutions are unfortunately not an option. Maybe there is a better way to get this done?   Constraints  As described, those databases are quite big to the point they are hard to maintain but that's an other problem.  The versions of SQL Server will be the same (Microsoft SQL Server 2012 Enterprise 64-bit).  It will have to be transferred over network between two datacenters so most probably over Internet. Having disks sent from one site to the other for an initial sync is unfortunately not an option. Having some sort of security for the transfer would be ideal but we will do the best of this situation.  That should give a quite good overview of our needs for this task and hopefully some of you had to face that situation before.
32527
We run an e-mail server for a few customers, and we've recently run into a bit of a conundrum.  We had a user who sent an e-mail to an incorrect e-mail address. The incorrectly specified domain unfortunately existed. It did not have MX records, and the A record of the domain went to a server which did not speak SMTP. Therefore, the e-mail server attempted delivery and did not succeed because no e-mail server was running.  For that reason, our e-mail server, entirely in accordance with the SMTP RFC, attempted re-delivery over the course of five days and finally gave up and sent a notice to the sender after 5 days of unsuccessful delivery.   says:     Retries continue until the message is transmitted or the sender gives up; the give-up time generally needs to be at least 4-5 days.   Therefore, the mail server in its default configuration, in this case has operated in accordance with the RFC, meaning that a user specifying the wrong e-mail address in this case would not receive notice of that except five days later.  At this point, my boss has asked whether it would be possible to reduce the give-up time to something shorter, say 1 day. His reasoning is that it is better that the user be notified earlier of non-delivery, and that the user may attempt re-delivery at a later date, or delivery through an alternate channel. It sounds like a reasonable thing to do, but in general I'm wary of performing any kind of configuration changes which contradict what's in the RFC.  Is there any non-obvious reason why it would be a bad idea to reduce the give-up time to 24 hours, beyond just saying "the RFC says otherwise"?  Also, what do the bigger e-mail providers out there (the Googles, Microsofts, AOLs and Yahoos) do in this scenario?
18323
I'm not sure if I'm googling for the wrong thing but I can't find an answer. We're running SQL 2014. The SQL Server and SQL Agent processes are both running under Domain Managed Service Accounts.  When SQL was installed NT SERVICE\MSSQLSERVER, NT SERVICE\SQLSERVERAGENT, NT SERVICE\SQLWriter, NT SERVICE\Winmgmt are all setup as SysAdmins.  If I am running SQL and SQL Agent as a Domain user, do I still need these NT Service accounts, and/or do they need to be SysAdmin?
113448
SQL Server 2016 CU2 (Enterprise) here and one of my users has requested that we get R-Services installed.  I followed what appeared to be very simple instructions from this page    When I got to the part about using the simple test  exec sp_execute_external_script  @language =N'R',   @script=N'OutputDataSet&lt;-InputDataSet',     @input_data_1 =N'select 1 as hello'   with result sets (([hello] int not null));   go     it failed with     Msg 39021, Level 16, State 1, Line 6 Unable to launch runtime for 'R'   script. Please check the configuration of the 'R' runtime. Msg 39019,   Level 16, State 1, Line 6 An external script error occurred:  Unable   to launch the runtime. ErrorCode 0x80070057: 87(The parameter is   incorrect.). Msg 11536, Level 16, State 1, Line 6 EXECUTE statement   failed because its WITH RESULT SETS clause specified 1 result set(s),   but the statement only sent 0 result set(s) at run time.   So, I started my internet searching for known problems regarding R-Services and found this article -    I made sure that R-Services had been brought up to date with the Sql Server version (2016, CU2). I read where long file names in the rlauncher.config file might cause problems, so I redirected my WORKING_DIRECTORY to C:\TEMP\R_SERVICES.  However, I left the RHOME and MPI_HOME configuration entries untouched and still using long file names. I made sure the Windows group SQLRUserGroup had full authority to that working directory folder.   After every configuration change, I restarted both SQL Server and SQL Server Launchpad.  However, every time I try to run the sample T-SQL test for R-Services, it fails and I see this entry in the rlauncher.log file     [Error] Session creation failed with: Failed with 2 to get security   for C:\TEMP\R_SERV~1\MSSQLSERVER01   I'm reaching out for help from others that might know what the problem is or any additional troubleshooting links.
8939
This is a  about avoiding outgoing mail being classified as spam.   Also related:                    I'm wondering how to prevent my emails from my site being marked as spam? I'm using sendmail.  I'm trying to send emails through my ruby-on-rails application. The mails are all written in swedish (if that does make a difference?). I don't know why they keep getting marked as spam.  Are there any things that I can do to minimize the risk?
14000
I've been having trouble getting my server to send email and I haven't for the life of me figured out how to fix it. If anyone could give me some simple pointers, that would be muchly appreciated!  May 19 15:36:03 ubuntu-12 sm-mta[2484]: s4JFa3jp002484: from=&lt;www-data@ubuntu-12.04-     production&gt;, size=412, class=0, nrcpts=1, msgid=&lt;201405191535.s4JFZw4c002483@ubuntu-12.04-  production&gt;, proto=ESMTP, daemon=MTA-v4, relay=ip6-localhost [127.0.0.1] May 19 15:36:03 ubuntu-12 sendmail[2483]: s4JFZw4c002483: to=myname@mycompany.com, ctladdr=www-data (33/33), delay=00:00:05, xdelay=00:00:05, mailer=relay, pri=30123, relay=[127.0.0.1] [127.0.0.1], dsn=2.0.0, stat=Sent (s4JFa3jp002484 Message accepted for delivery) May 19 15:36:03 ubuntu-12 sm-mta[2487]: s4JFa3jp002484: to=&lt;myname@mycompany.com&gt;, ctladdr=&lt;www-data@ubuntu-12.04-production&gt; (33/33), delay=00:00:00, xdelay=00:00:00, mailer=esmtp, pri=120412, relay=mailserver.mycompany.com. [213.171.216.115], dsn=5.0.0, stat=Service unavaila$ May 19 15:36:03 ubuntu-12 sm-mta[2487]: s4JFa3jp002484: s4JFa3jp002487: DSN: Service unavailable May 19 15:36:03 ubuntu-12 sm-mta[2487]: s4JFa3jp002487: to=&lt;www-data@ubuntu-12.04-production&gt;, delay=00:00:00, xdelay=00:00:00, mailer=local, pri=30000, dsn=2.0.0, stat=Sent
121565
I'm trying to send an email in Java but when I read the body of the email in Outlook, it's gotten rid of all my linebreaks. I'm putting \n at the ends of the lines but is there something special I need to do other than that? The receivers are always going to be using Outlook.   I found a page on microsoft.com that says there's a 'Remove line breaks' "feature" in Outlook so does this mean there's no solution to get around that other than un-checking that setting?  Thanks
65509
I would like to say that i have gone through some of the sql blog and MSDN BOL, but still there is some confusion in mind like.   The limitation of SQL Server 2012 Express is 10 GB. It is the limitation of instance based or per database based? No. of connections for SQL Server 2012 Express: the number of connections is limited or unlimited.  If I shall use Server version of OS then what can be the max concurrent user connections. The limitation comes from DB level or OS level. If I shall use Windows Server 2012 R2 with SQL Server 2012 Express SP1 then what will be the max concurrent connections? How many databases can we keep under the hood of single SQL Server instance.   Any help or suggestion would be appreciated
72814
I would like to create an Outlook rule that stops me from sending out emails that have more than ten email addresses in the "To:" line. Is this even possible? I'm using Outlook 2010 on Windows 7 64-bit.  My reasoning: I send out a distribution letter to a large number of addresses. I usually send this email to myself with the distribution list addresses in the "BCC:" line. Every once in a while I mess up and accidentally put the distribution list addresses on the "To:" line instead. This is a problem because then each email recipient will see all the addresses on the list. I want Outlook to stop me from doing this, or at least warn me before I send it out.  I also welcome suggestions on how to get around this problem.
106739
I am trying to send an email via GMail's SMTP server from a PHP page, but I get this error:     authentication failure [SMTP: SMTP server does no support authentication (code: 250, response: mx.google.com at your service, [98.117.99.235] SIZE 35651584 8BITMIME STARTTLS ENHANCEDSTATUSCODES PIPELINING)]   Can anyone help?  Here is my code:  &lt;?php require_once "Mail.php";  $from = "Sandra Sender &lt;sender@example.com&gt;"; $to = "Ramona Recipient &lt;ramona@microsoft.com&gt;"; $subject = "Hi!"; $body = "Hi,\n\nHow are you?";  $host = "smtp.gmail.com"; $port = "587"; $username = "testtest@gmail.com"; $password = "testtest";  $headers = array ('From' =&gt; $from,   'To' =&gt; $to,   'Subject' =&gt; $subject); $smtp = Mail::factory('smtp',   array ('host' =&gt; $host,     'port' =&gt; $port,     'auth' =&gt; true,     'username' =&gt; $username,     'password' =&gt; $password));  $mail = $smtp-&gt;send($to, $headers, $body);  if (PEAR::isError($mail)) {   echo("&lt;p&gt;" . $mail-&gt;getMessage() . "&lt;/p&gt;");  } else {   echo("&lt;p&gt;Message successfully sent!&lt;/p&gt;");  } ?&gt;
102541
When I install SQL Server into the root of my drive, for example D:\, I get an error when I run a database deployer from a third party piece of software.  But when I move my SQL Server instance to D:\SQL\ (move it to a folder within the drive) then installation works perfectly.  My question doesn't regard the database deployer but more into the reason why SQL would have an issue with being installed into the root of a drive. Is this bad practice? Why shouldn't I install SQL Server to the root of my drive?
84025
I work for an educational services company based in India. We've around one million students enrolled as users. We're frequently facing the problem of our bulk mailers regarding upcoming exams, new product launches and promotions going into spam mail folders of the students. Is the problem in the headlines? Or where else? what can we do to reduce this number?   This is killing us, we cannot have an impossibly large precentage of mails not being opened..Please help.
112270
When attempting to connect to a SQL Server 2008 Instance using Management Studio, I get the following error:     Login failed. The login is from an   untrusted domain and cannot be used   with Windows authentication.   (Microsoft SQL Server, Error: 18452)   I can login using SQL Authentication without problem.  I've been getting this error all of a sudden.  I have Mixed Mode Authentication turned on.    Does anyone have any experience with this?  Additional Info: 64-bit version of SQL Enterprise Edition On Windows 2003 Server
83663
I have a requirement where, we need to send an Email on the status of failed Bulk Data Load jobs. But I am not sure the Object Name or how to refer those jobs programatically in my APex code. When I use 'AsyncApexJob', it's referring to Scheduled Apex Jobs. But I want the reference of Bulk Data Load Jobs. (Bulk Data Load jobs will be submitted by Mule ESB process using Salesforce Connectors.) Any info on this helps. Thanks.
90407
I have a server which uses Postfix as the mail system. The issue I am having is I am not able to send or recieve email. If I send an email I get an instant reply from the server which says:  Subject:    test Sent:   16/05/2011 19:08  The following recipient(s) could not be reached:  'myemail@mydomain.com' on 16/05/2011 19:08 452 4.3.1 Insufficient system storage   I have check the following:  Disk space, there are gigabytes of free space on all partitions. Mailbox quotas, there are no quota,s set on any mailbox.  I cleared all the mail logs and rebooted the server but I still cannot send email. does anyone have any pointers for me to look at next.  I have looked at the main.cf file and here are the results:  virtual_mailbox_domains = $virtual_mailbox_maps, hash:/var/spool/postfix/plesk/virtual_domains virtual_alias_maps = $virtual_maps, hash:/var/spool/postfix/plesk/virtual virtual_mailbox_maps = hash:/var/spool/postfix/plesk/vmailbox transport_maps = hash:/var/spool/postfix/plesk/transport smtpd_tls_cert_file = /etc/postfix/postfix_default.pem smtpd_tls_key_file = $smtpd_tls_cert_file smtpd_tls_security_level = may smtpd_use_tls = yes smtp_tls_security_level = may smtp_use_tls = no smtpd_sender_restrictions = check_sender_access hash:/var/spool/postfix/plesk/blacklists, permit_sasl_authenticated, check_client_access pcre:/var/spool/postfix/plesk/non_auth.re smtp_send_xforward_command = yes smtpd_authorized_xforward_hosts = 127.0.0.0/8 smtpd_sasl_auth_enable = yes smtpd_recipient_restrictions = permit_mynetworks, check_client_access pcre:/var/spool/postfix/plesk/no_relay.re, permit_sasl_authenticated, reject_unauth_destination virtual_mailbox_base = /var/qmail/mailnames virtual_uid_maps = static:110 virtual_gid_maps = static:31 virtual_transport = plesk_virtual plesk_virtual_destination_recipient_limit = 1 smtpd_client_restrictions =  myhostname = mydomain.com message_size_limit = 2048000000
28203
Hi I've stumbled into the administration of a Legacy SQL 2000 server that has had next to no maintenance for the past 8 years (and is very slow).  As I have only been doing DBA / PT for the past 2 years (I'm primarily a Developer) I don't have allot of experience on 2000.  Can anyone point me in the direction of some maintenance, tuning scripts.  Just figured I'd ask first before I reinvent the wheel for something I will rarely use.  Thanks Guys / Girls !