Browsing Cubes on a Remote SSIS

Posted on 2009-02-15
Last Modified: 2016-02-13
1- Server:
SSIS runs runs on a remote (production) machine that is part of a workgroup (no domain). SQL Server 2005 Enterprise (with SP2)

2- Client:
Users also use Excel (or desktop-based cube browsers like NovaView by Panorama) to connect to remote SSIS using Integrated Security i.e. logging in with same local username/password that is running SSIS on remote machine.
Since SSIS runs in a workgroup, any local user with same login and password authenticates itself on SSIS server.

The problem is with password synchronization. On the production machine, passwords are changed regularly for security reasons and this breaks the connection of Excel/Desktop-based cube browsers. SSIS does not allow SQL Authentication for such applications.

I was thinking of a solution whereby all cube browser requests go through a single gateway application and that application authenticates itself against SSIS (similar to what IIS does for web clients). But I don't know how to go about it, any custom solutions available? Anybody here have any idea?
Question by:aatif786
    LVL 22

    Expert Comment

    I suggest you to read a book about BI tools.
    Your questions is related with SSAS and not SSIS.
    Re-think in your question and return with more feedback.

    Author Comment

    Sorry about that. Yes I actually meant SSAS (SQL Server Analysis Services). I will re-assign it to appropriate group.
    LVL 22

    Accepted Solution

    I can send you a book...
    And in my blog I have a link to a SQL Server 2008 book.

    Author Closing Comment

    Question posted with wrong wordings (SSIS instead of SSAS) that basically confused the readers (experts)

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    This is my first ever Article on EE or elsewhere; therefore, please bear with me if I have some discrepancies in my writing. I read many articles and questions related to "how to pass values to SSIS packages at run-time?"  Hence, this common ques…
    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now