kal3003

try this -> in IIS Authentication methods remove Integrated windows authintication and use anonymose access use user: IUSER

in windows 2003 you have to Allow php extension go to IIS -> web services extenstions then add php extenstion and allow it

convert it to text , in MSSQL Varchar have limitation its only 255

i mean 'CHAUDHRY\SUPER$'

add that user to MSSQL users security -> users

try this : $sqlquery="SELECT convert(varchar,DateReceived,103) FROM MyTable"; $results= mssql_query($sqlquery); 103 -> dd/mm/yy 101 -> mm/dd/yyyy and so on you can find all formats in MSSQL help , search for convert

send more information about the error dude , enable php error_reporting then send the error