Analysis Services Security - OLAP version 8

• Ronnie Jones

  Hall of Fame

  Points: 3377

  More actions

  September 22, 2005 at 4:34 pm

  #111781

  Hello All,

  I have an Analysis Server running under SQL Server 2k. My users access the cubes via Excel and use an older version of the Microsoft OLE DB Provider for OLAP Services. When they connect to the server using that version, they have access to cubes that they have not been given permission. But if they user Microsoft OLE DB Provider for OLAP Services 8, they only see the cubes that they have permission.

  I have no idea where to go to fix this. Has anybody experienced anything like this before or even something similar?

  Let me know if you need me to provide additional information.

  Thanks for your help.

  Ronnie

• mdaniel

  SSCarpal Tunnel

  Points: 4616

  More actions

  September 23, 2005 at 3:01 pm

  #592793

  There is a registry key to restrict the version of the client. This was instroduced on SP3.

  The key is: ConnectPre80SP3Clients

  Check this:

  http://support.microsoft.com/?kbid=905615

  After this, you have to assure that every user has the Olap Provider updated, ideally the same sp as the server.