Hello Adam, I quickly skimmed through your issue and now want to blame your connections string, so let's try this: Provider=MSOLAP;Integrated Security=SSPI;Persist Security Info=False;Data Source=our_alias I do not like the Impersonation Level=Impersonate; by the way I am thinking it is necessary to add the Initial Catalog=YourDataBase; portionArthur My Blog

We are moving our ETL Packages from SQL 2008R2 to SQL 2012 - but were having issues with alias. We connect to external sources, and then store the data in a SQL Server Database. The last step in the ETL is to "Reprocess" the cubes. When using the following Data Sources connection string for the sql agent based job on sqlserver 2012: Data Source=our_alias;User ID=test\service-user;Provider=MSOLAP.5;Integrated Security=SSPI;Impersonation Level=Impersonate; We get the error message: Executed as user: test\service-user. Microsoft (R) SQL Server Execute Package Utility Version 11.0.2100.60 for 32-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 4:52:34 PM Error: 2012-08-22 16:59:09.28 Code: 0x00000000 Source: Rebuild Dimensions Analysis Services Processing Task Description: A connection cannot be made. Ensure that the server is running. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 4:52:34 PM Finished: 4:59:09 PM Elapsed: 394.589 seconds. The package execution failed. The step failed. But, the job will succeed if I change the datasource to the actual hostname of the sqlserver: Data Source=actual_hostname;User ID=test\service-user;Provider=MSOLAP.5;Integrated Security=SSPI;Impersonation Level=Impersonate; *Note: This only applies to the step that "pokes" the cube to refresh, not the SQL Server RDB - which works with our alias. Some notes related to our configuration and my testing: -The RDB and SSAS database and the ETL Packages all live on the same server, and were using the default server - no named instances. -SQL Server Browser service is running as user test\service-user -Tracing with SQL Server Profiler on the analysis db shows that there is an attempt to login to the analysis database as user anonymous as opposed to the expected test\service-user -Aliases seems to work for connection to the RDB, but only fails when we attempt to connect to the SSAS database. -We used the tool CliConfg.exe to create SQL Server alias, and even made host entries. Worked fine in SQL2008R2 - does not work in 2012. I hope I mad our issue clear, and thanks for any help.Adam Talesky

Hello Adam, I quickly skimmed through your issue and now want to blame your connections string, so let's try this: Provider=MSOLAP;Integrated Security=SSPI;Persist Security Info=False;Data Source=our_alias I do not like the Impersonation Level=Impersonate; by the way I am thinking it is necessary to add the Initial Catalog=YourDataBase; portionArthur My Blog

Thanks, will give it a shot now....Adam Talesky

The issue is still there, from my DBA: Thank you for your response Arthur. Adding the Initial Catalog=YourDataBase did not correct the issue - still getting the same error: Executed as user: TEST\test-service. Microsoft (R) SQL Server Execute Package Utility Version 11.0.2100.60 for 32-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 10:24:22 AM Error: 2012-08-31 10:31:03.24 Code: 0x00000000 Source: Rebuild Dimensions Analysis Services Processing Task Description: A connection cannot be made. Ensure that the server is running. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 10:24:22 AM Finished: 10:31:03 AM Elapsed: 400.767 seconds. The package execution failed. The step failed. I did not remove the Impersonation Level=Impersonate as I think we built the job assuming this level of access, so I didi not want to introduce another variable to the issue. So in summary the job still runs successful if I add the hostname instead of the alias in the connection string (datasources) with or without the initial catalog in the connection string.Adam Talesky

Adam, I am thinking you may want to contact Microsft PSS if you have budget/contarct otherwise submit a Connect item.Arthur My Blog

Thank you for your quick response, I am waiting on the DBA's to give this a shot - they don't want us lowly developers making configuration changes :) Adam Talesky