• Main
  • Blog
  • Who We Are
    • Jeremy Anderson
    • Amy Babinchak
    • Steve Banks
    • Cliff Galiher
    • Brian Higgins
    • Eriq Neale
    • Edwin Sarmiento
    • David Shackelford
  • Store
    • Webinar Archives
  • Support
  • Forum
  • FAQ
  • My Third Tier
  • Datto

Archive for April 2009 – Page 3

Apr
9

Troubleshooting Delayed Message Delivery in Exchange

by Eriq

As more and more anti-spam solutions start doing “interesting” things with SMTP and mail delivery, there is an increased chance of users reporting that mail messages to certain domains are delayed. Unlike a full non-delivery report (NDR) which will list the SMTP error codes for easy identification of the reason for the rejection, a delayed delivery report could be the result of an Internet connection issue, spam filter, offline server, or any number of other causes. The remainder of this post details how to track down possible causes for Internet delivery issues.

First, start with Exchange System Manager. After you open Exchange System Manager, expand Servers, expand the server, then select Queues.

Viewing the SMTP queues in ESM

Viewing the SMTP queues in ESM

Look for the connector with the domain that you are having trouble sending to. In the image above, it’s the last queue in the list. We can tell from ESM that there is a problem with this queue because it shows to be in a Retry status under the State column. And when you select the queue, look under Additional Queue Information at the bottom of the screen and you’ll see the result of the last connection attempt. In this case, we can see that the connection was dropped by the remote host. So, in this case, we were able to connect to the remote mail host, which rules out internet connectivity issues, and now we need to see why the remote host is dropping the connection. Before we can do that, we need a couple of other pieces of information.

If you double-click on the connector for the problematic domain, you will get the Find Messages window to open. Click on the Find Now button to see all the messages that are stuck in the queue:

Using Find Messages to view the hung messages in the queue

Using Find Messages to view the hung messages in the queue

In this example, we can see two messages that have been sent by the Administrator account are waiting in a Retry state in the queue. Now, we need one more piece of information, so double-click one of the messages.

Looking for the recipient in the hung message

Looking for the recipient in the hung message

If you look in the Recipients block, you can see the e-mail address of the recipient for this message. Remember that for later.

Next, we want to look in the SMTP logs to see if the remote server sent a valid SMTP code before it dropped the connection. Usually, when a remote host drops a connection, the SMTP service on the Exchange server does not log the code sent by the remote host before the connection is dropped, but we might get lucky. So, let’s open the LogFiles folder and see what the SMTP logs have to say. Open the start menu and enter the path to the LogFiles folder, usually C:\WINDOWS\system32\LogFiles

Opening the LogFiles folder

Opening the LogFiles folder

Now, if SMTP logging has been enabled on your server, you will have an SMTPSVC1 or similarly-named folder inside of the LogFiles folder.

SMTPSVC1 folder missing from LogFiles

SMTPSVC1 folder missing from LogFiles

In this example, we can see that the SMTP service has not had logging enabled. No worries, we can quickly and easily enable logging for our testing. Go back into ESM, expand Protocols under the server, expand SMTP, right-click on the Default SMTP Virtual Server, and select Properties.

Opening the properties of the Default SMTP Virtual Server

Opening the properties of the Default SMTP Virtual Server

Once you open the Properties, turn on the Enable Logging checkbox, then select Microsoft IIS Log File Format from the Active Log Format drop-down menu.

Enable the Microsoft IIS Log format logging

Enable the Microsoft IIS Log format logging

Close the Properties window and stop and restart the SMTP service on the server. You will probably need to force the connection again after you restart the SMTP service to ensure that SMTP makes another delivery attempt on the messages. Back in the Queues node, right-click on the problematic SMTP connector and select Force Connection.

Forcing teh SMTP connector to retry a connection

Forcing the SMTP connector to retry a connection

After the connection attempts and fails, you can go into the SMTPSVC1 folder that now appears under the LogFiles folder and open the log file to review the connection. If you already had logging enabled, you can force the connection attempt and then open the most recent SMTP log file to look for the connection data.

Here is the pertinent information from the log file in this example:

71.n.n.n, OutboundConnectionResponse, z/z/2009, 17:34:33, SMTPSVC1, SERVER, -, 31, 0, 117, 0, 0, -, -, 220 xx.com Microsoft ESMTP MAIL Service, Version: 6.0.3790.3959
71.n.n.n, OutboundConnectionCommand, z/z/2009, 17:34:33, SMTPSVC1, SERVER, -, 31, 0, 4, 0, 0, EHLO, -, yy.com,
71.n.n.n, OutboundConnectionResponse, z/z/2009, 17:34:33, SMTPSVC1, SERVER, -, 62, 0, 45, 0, 0, -, -, 250-xx.com Hello [70.n.n.n.n],
71.n.n.n, OutboundConnectionCommand, z/z/2009, 17:34:33, SMTPSVC1, SERVER, -, 62, 0, 4, 0, 0, MAIL, -, FROM:<
Administrator@yy.com>,
71.n.n.n, OutboundConnectionResponse, z/z/2009, 17:34:33, SMTPSVC1, SERVER, -, 78, 0, 59, 0, 0, -, -, 250 2.1.0 
Administrator@yy.com....Sender OK,
71.n.n.n, OutboundConnectionCommand, z/z/2009, 17:34:33, SMTPSVC1, SERVER, -, 78, 0, 4, 0, 0, RCPT, -, TO:<
mm@xx.com>,
71.n.n.n, OutboundConnectionResponse, z/z/2009, 17:34:44, SMTPSVC1, SERVER, -, 15, 0, 117, 0, 0, -, -, 220 xx.com Microsoft ESMTP MAIL Service, Version: 6.0.3790.3959
71.n.n.n, OutboundConnectionCommand, z/z/2009, 17:34:44, SMTPSVC1, SERVER, -, 15, 0, 4, 0, 0, EHLO, -, yy.com,
71.n.n.n, OutboundConnectionResponse, z/z/2009, 17:34:44, SMTPSVC1, SERVER, -, 47, 0, 45, 0, 0, -, -, 250-xx.com Hello [70.n.n.n.n],
71.n.n.n, OutboundConnectionCommand, z/z/2009, 17:34:44, SMTPSVC1, SERVER, -, 47, 0, 4, 0, 0, MAIL, -, FROM:<
Administrator@yy.com>,
71.n.n.n, OutboundConnectionResponse, z/z/2009, 17:34:44, SMTPSVC1, SERVER, -, 78, 0, 59, 0, 0, -, -, 250 2.1.0 
Administrator@yy.com....Sender OK,
71.n.n.n, OutboundConnectionCommand, z/z/2009, 17:34:44, SMTPSVC1, SERVER, -, 78, 0, 4, 0, 0, RCPT, -, TO:<
mm@xx.com>,

As suspected, the dropped connection from the remote site does not give us a complete SMTP transaction log on our Exchange server. We see the initial connection attempt, the EHLO command our server sends, the MAIL command out server sends, and the RCPT command our server sends. After that, the connection is reset by the other end, and the SMTP process on our server does not capture the information. Not to worry, we can still get that information. How? Telnet.

Open a command prompt on your server. Run the nslookup command. At the nslookup prompt, enter set type=mx and press Enter. Then enter the domain name of the site you are trying to send to and press Enter. You’ll get a response similar to:

Reading the results from the nslookup command

Reading the results from the nslookup command

The key piece of information needed is the mail exchanger, which will be the last item listed in the response. Make note of that server name. Now, in the same command prompt, type telnet mailserver 25, where mailserver is the name of the server you identified from the nslookup command. When the connection is made, type ehlo and press return. You should get a response similar to:

 

Connecting to the remote mail server

Connecting to the remote mail server

Now, type the following commands and press Enter after each one. You will use the FROM address that you got from the Find Now search in the ESM Queues, and you will use the TO address that you got earlier as well.

mail from: sender@domain.com
rcpt to: recipient@domain.com

In our case, we get our answer as soon as we provide the recipient’s address:

Responses from the remote SMTP server

Responses from the remote SMTP server

The remote mail server responds to the rcpt command with a 550 5.7.1 response, indicating that it will not accept the message. In this case, the remote host is using Trend Micro’s Email Reputation service, and that service, for whatever reason, has denied access for the sender to send mail to that recipient.

Unfortunately, because the remote server issues the response and then immediately drops the connection, the sending server never has an opportunity to log the response, so the message goes into a retry state, and the server will continue to try to deliver the message until the timeout value is reached (72 hours by default in Exchange) and then the sender will get an NDR indicating that the message could not be delivered within the timeout window. This doesn’t tell the sender that their message was blocked by a spam filter, and their only real recourse, without our troubleshooting, is to try to contact the recipient some other way and let the receipient know that the sender had problems getting an e-mail through.

I’m afraid that this type of SMTP behavior is only going to become more prominent, meaning that we will likely get called into action to try to figure out why a message never got delivered. So long as we have access to the sending mail server, it’s not that hard to figure out. Just follow these steps to find the SMTP code returned by the receiving mail server, and you can then continue troubleshooting from there.

Categories : Eriq Neale
Apr
9

ISA 2006 in front of SBS 2008 Whitepaper Available

by Third Tier

Post to Twitter Post to Facebook Post to StumbleUpon

Third Tier partner Eriq Neale wrote a whitepaper for Microsoft on how to configure ISA 2006 to run in front of SBS 2008, and that document is now available for download from microsoft.com. If you received ISA 2006 as part of the SBS 2003 Premium Software Assurance make good offer, or if you are wanting to deploy ISA 2006 independently of that offer, this whitepaper will walk you through the process of installing and configuring the ISA 2006 server to publish and protect the SBS 2008 network.

0 Categories : Eriq Neale, ISA, News
Apr
8

eOnCall Features Local Engagement Team

by Third Tier

Post to Twitter Post to Facebook Post to StumbleUpon

Tomorrow’s episodes of eOnCall, which air on the AirTunZ Rock station at 10am and 1pm Central time on Thursdays, features Michael Murphy of the Microsoft Local Engagement team talking about how the Local Engagement team is working to connect local customers and groups with Microsoft partners. If you are a Microsoft partner and you aren’t familiar with the Local Engagement team, listen to both episodes and learn how working with the Local Engagement team could help your business.

Once the podcast versions of the episodes are online, we’ll post the link for the episodes in case you are not able to listen at broadcast time.

0 Categories : Eriq Neale
Apr
8

Eriq Presenting at Technology Wizards Group Meeting

by Third Tier

Post to Twitter Post to Facebook Post to StumbleUpon

Eriq is presenting a session on preparing for SBS 2008 to the Technology Wizards group in Salem, Oregon, Wednesday April 8 at 2pm PDT. The session covers the key differences between SBS 2003 and SBS 2008 that IT Professionals should be aware of when transitioning customers to SBS 2008.

If you’re interested in having any of the Third Tier staff present at your user group meeting, feel free to e-mail us and we’ll see what we can schedule!

0 Categories : Eriq Neale, Events
Apr
7

Roundtable Discussion: Lining Your Pockets With FUD

by amy

Post to Twitter Post to Facebook Post to StumbleUpon

An event occurred last week that made a lot of IT people some money and added to their desire to obtain 15 minutes of minutes of fame – the Conflicker debacle. Between the media and IT professionals, both desperate to survive in a slow economy, (witness lots of publications going online only, regular columnists moving down the ladder to freelance and small IT shops going under in droves) hyping their wares using Fear, Uncertainly and Doubt they managed to scare a lot of small businesses into spending money. But then what happened? Conflicker was a non-starter and those businesses now feel duped. They got played and they know it. Now they distrust the media and IT professionals even more than they did before. How is this good for business? It’s not.

Businesses shouldn’t make IT investment decisions out of fear. To thrive they need to invest in IT because it will further their business objectives. IT should make businesses money not cost them. Business should not have to fear the next Internet disease; they should rest assured that they have made the right decision in hiring a professional IT firm that understands their business and manages the network to avoid the mad scramble. If as an IT firm if your clients don’t view you as a trusted professional, then you are doomed to fail. If as a small business you don’t view your selection of an IT firm as a trusted advisor, then it’s time for a change.

Running a secure network that enhances and enables your business to be better than the competition is possible. It’s not costly because it pays for itself. The technology isn’t scary because you have trust in your IT person. Join us for a roundtable discussion between Dana Epp of Scorpion Software, Susan Bradley of TSH&B, Ben Yarbrough of Calyptix and Amy Babinchak of Harbor Computer Services and Third Tier on April 16th.

Register here: https://www2.gotomeeting.com/register/733132802

1 Categories : Amy Babinchak, Events
Apr
7

Managing SBS 2008: Sharepoint Recording Posted

by amy

Post to Twitter Post to Facebook Post to StumbleUpon

The recording for the March Managing SBS 2008: Sharepoint with Chad Gross has been posted. Chad covered Sharepoint from a real world small business point of view complete with suggestions on where the demonstrated feature would be valued by your customer.

This recording and all previous are available on the Store tab of our website. http://www.thirdtier.net/store

0 Categories : Chad Gross, SharePoint, Webinar
Apr
6

Changing a SQL Server 2000 login

by edwin
WARNING: This is not a recommended approach. Use at your own risk


While SQL Server 2005 has the ALTER LOGIN statement to change the properties of a SQL Server login account, SQL Server 2000 does not have such a command. Unfortunately, there are cases where you need to simply rename the login due to a misspelled name or a change management policy. The proper way to do it in SQL Server 2000 is to create the new login, map the permissions and roles of the existing login that you wish to change to this new login and, then, drop the old login. I wouldn't want to go thru that if I only have to rename the login. The only simpler way to do it is to modify the system tables. As I've said, it is not recommended to modify the system tables and/or objects directly so bear in mind that doing this would be at your own risk. This would also require that you torn on allowing ad hoc updates to system tables and turning it off afterwards


sp_CONFIGURE 'ALLOW UPDATES', 1
GO
RECONFIGURE WITH OVERRIDE
GO

UPDATE db..sysusers
SET name='newLogin'
WHERE
name='oldLogin'

UPDATE master..sysxlogins
SET name='newLogin'
WHERE
name='oldLogin'

sp_CONFIGURE 'ALLOW UPDATES', 0
GO
RECONFIGURE WITH OVERRIDE
GO

A similar stored procedure is described here

Categories : Edwin Sarmiento
Apr
2

Fixing Orphaned Database Users in SQL Server 2005

by edwin
I see this on almost all SQL Server instances I work on - existing user in a database with dbo permissions yet they could not access anything in the database. This is because SQL Server doesn't really look at the user or login name but rather the SID values (I've talked about this in here). Maybe they restored a database back from a development server to the production server without synchronizing the logins. If this was SQL Server 2000, you'd probably end up dropping logins, recreating the logins using the script provided by Microsoft in this KB article and recreate the database users. Unfortunately, this is not a straight-forward task. Good thing Microsoft has provided the sp_change_users_login stored procedure to fix orphaned users. Using the UPDATE_ONE parameter will 're-map' an orphaned database user to an existing SQL Server login with the same name. That in itself will spare you the trouble of going thru the process mentioned above (although you will still have to worry about orphaned database users that own schemas which is very much common among databases that have been upgraded from SQL Server 7.0 and 2000). Below is a syntax for 're-mapping' an orphaned database user to an existing SQL Server login

EXEC sp_change_users_login 'UPDATE_ONE','user','user'
GO


You still need to run the stored procedure with the REPORT parameter to return a list of orphaned database user

EXEC sp_change_users_login 'Report'
Categories : Edwin Sarmiento
Apr
1

Eriq to Present Session on Foundation at SMB Summit

by Third Tier

Post to Twitter Post to Facebook Post to StumbleUpon

While making a major product announcement on April 1st might not be the best move, the announcement of the new Windows Server 2008 Foundation operating system by Microsoft today is a legitmate product announcement. And Third Tier is proud to announce, again without any April 1st tomfoolery, that Eriq Neale will be presenting a session on Server 2008 Foundation at the SMB Summit conference in Dallas the weekend of May 15-17. 

The Server 2008 Foundation product will be an interesting addition to the SMB product offering from Microsoft, but there are some specific limitations on the product that will impact how it can be used in a small business. During his presentation, Eriq will be covering the basics of the Foundation product, its design limitations, and examples of how Foundation server can be used in both stand-alone implementations and as an additional server in an existing SBS or other Windows network.

If you want to learn how Foundation server may fit into the set of offerings you have for your clients, make plans to attend this session at the SMB Summit conference in May. If you haven’t already registered to attend, you can register on-line today. For additional information about Server 2008 Foundation, see http://www.microsoft.com/windowsfoundationserver.

1 Categories : Eriq Neale, Events, SMB Summit
« Previous Page

Search

Support

Third Tier provides advanced support services to IT Professionals. Learn about what we do at http://www.thirdtier.net or click on the support icon below to chat with one of our support representatives.

Third Tier
Copyright © 2012 All Rights Reserved
iThemes Builder by iThemes
Powered by WordPress