Test your SQL server connectivity

Click Start > Settings > Control Panel.

Double-click Administrative Tools.

Double-click Data Sources (ODBC).

• The ODBC Data Source Administrator opens

Click the System DSN tab.

Click Add.

• The Create New Data Source window opens

Scroll to the Microsoft SQL Server entry and click it.

Click Finish.

• The Create a New Data Source to SQL Server window opens

Enter the following field information:

• Name : Test
• Description : Test
• Server : <SQLServer>\<SQLInstance> or select from drop-down menu

Click Next.

If using Windows authentication, select the Windows NT® authentication option. If using SQL authentication, select the Microsoft SQL Server authentication option.

If using SQL authentication, type the user name and password used by the server to access the Microsoft SQL Server.

Click Next.

• The ODBC attempts at this point to connect to the Microsoft SQL Server
• If the connection fails, an error message appears

If the connection succeeds, select the Change Default Database to check box.

problem in uploading messages from outlook to yahoo IMAP server - the server modifies and corrupts message header

lately I was trying to upload my old email *.pst files to Yahoo mail using Outlook 2010 in order to make a backup there in case of a problem happens with my HDD, but the problem I faced is that for certain messages I kept seeing them getting corrupted each time I upload them to the server, after googling out the problem for almost a day and trying to decrypt my traffic with Wireshark to see exactly what is happening I found nothing valuable,

As Outlook doesn't allow you to edit message header, I was fortunate that I was able find an excellent program that can retrieve the message from the server then store it as .eml, the program name is IMAPSize. so I tried saving the message then edit it with text editor, and I could see where exactly the problem is by comparing the corrupted message with correct one. so I edited the header, saved the message then opened it in Outlook, then clicked "move" then chose the destination folder and Voila!!! message uploaded correctly.

The reason why this is happening is still a mystery as It happened before on different IMAP server, so definitely it is a bug either in Outlook or IMAP.