The connection type is chosen from the drop down list. SQL Server 2000 OLAP server use a connection type of “Analysis Server 2000” and for later versions of SQL Server OLAP server use “Microsoft Analysis Server 2005”.