[U2] Need detailed instrutions for querying from SQL Server 2005 Management Studio

Looking for help with connecting via OLE DB to query a U2 database from SQL Server 2005 as the tool for sql queries and inserting data into a sql database. If anyone can point me to somewhere that I can obtain detailed instructions for how to troubleshoot a connection, I will really appreciate

[U2] Need help connecting to Universe and querying via SQL Server 2005 Management Studio

I need to run ad-hoc queries against a Universe database from SQL Server 2005. I'm using Management Studio (formerly Query Analyzer). I can connect to Universe via MS Excel and obtain query results, but am struggling with how to query via SQL Server. Do I need to set up the universe database