Jul 23, 2015 at 5:54 PM
Edited Jul 23, 2015 at 5:54 PM
When trying to use the ASSP.CurrentCommandIsDiscover function I am getting an error on connection that says:
Execution of the managed stored procedure CurrentCommandISDiscover failed with the following error: Exception has been thrown by the target of an invocation. A connection cannot be made. Ensure that the server is running. No connection could be made because
the target machine actively refused it.
Using sql server 2012
Permission set to unrestricted
Impersonation: tried default, service Account, and specific user.
Here is an example of how I am using it.
CREATE DYNAMIC SET CURRENTCUBE.[Accounts On Promotion] AS
Head([Account].[Account Number].[Account Number].Members,0),
NONEMPTY([Account].[Account Number].[Account Number]
,[Measures].[Account Promo Count]
,Display_Folder = 'Account Promo Sets';