• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 831
  • Last Modified:

Browsing Cubes on a Remote SSIS

Environment
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.

Problem:
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.

Solution??
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?
0
aatif786
Asked:
aatif786
  • 2
  • 2
1 Solution
 
PedroCGDCommented:
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.
Regards,
Pedro
0
 
aatif786Author Commented:
Sorry about that. Yes I actually meant SSAS (SQL Server Analysis Services). I will re-assign it to appropriate group.
0
 
PedroCGDCommented:
I can send you a book...
And in my blog I have a link to a SQL Server 2008 book.
Pedro

www.pedrocgd.blogspot.com
0
 
aatif786Author Commented:
Question posted with wrong wordings (SSIS instead of SSAS) that basically confused the readers (experts)
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now