Assuming you have the SQL Server addons installed (per phil.o, above), your SQL query has a problem:
$tsql = "SELECT EmailAddress,Password
FROM Customer_Detail
WHERE EmailAddress=$username AND Password=$password ";
Both $username and $password are strings. They must be surrounded by single quotes for SQL:
$tsql = "SELECT EmailAddress,Password
FROM Customer_Detail
WHERE EmailAddress='$username' AND Password='$password'";
But, again, make sure you have MS SQL Serve functionality installed. PHP usually comes with MySQL as a standard component (look up LAMP);