I followed the steps but when i add Format=tabular and try to click on test connection i get the following error
Test connection failed because of an error in initializing provider. Internal error: An unexpected exception occured.
Internal error: An unexpected exception occured.
XML parsing failed at line 1, column 515: Unexpected end of input.
.
I am using SQL Server 2005 SP3.
Thanks