I'm getting an "Unspecified Error" when I try authenticate to our Analysis Server using Microsoft Excel Pivot Table Services. It works fine when I am authenitcated within the domain (when I'm at work) but when I am working from home (external of the domain) I cannot connect. I've tried mutliple versions of microsoft excel, as well as making sure MDAC and Pivot Table Services (8,0) are installed correctly.
From what I understand, the only authentication broker available in Analysis service is Active Directory. We tried using domain prefix's on the login (i.e domain\user domain/user and the @ symbol) but no luck so far.
Some MDX can be placed within a view structure and passed to the linked server, generating an ouput for Excel to connect to.
This would avoid the need for Windows authenticated accounts from externally,
With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
Why is this different from all of the other step by step guides? Because I make a living as a DBA and not as a writer and I lived through this experience.
Defining the name:
When I talk to people they say different names on this subject stuff l…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied?
You can use SQL Server Initialize from Backup…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed