How do I retrieve external data from MS SQL from a Wordpress Blog?
Wordpress runs on PHP and so you need to use a PHP provider for SQL Server. See Accessing SQL Server Databases with PHP.
If you host Wordpress on Linux, you need FreeTDS, see PHP mssql Requirements.