When deploying a model in Chapter 9, Tuning the Models, we got the following error:
The error states that the access to the HousingAffordabilityData
database is not available to the user NT Authority\SYSTEM
. The only place where the connection information is provided in a solution is in the Data Source Impersonation dialog box. So, we navigate to the Impersonation Information tab and check whether we have selected the Use the service account option, as shown in the following screenshot:
The article at http://msdn.microsoft.com/en-us/library/ms187597.aspx provides more information on each of the preceding options. The service account of the Analysis Services is shown in the following screenshot of the SQL Server Configuration Manager:
We now navigate to the SQL Server Management Studio and check the permission of the user LocalSystem
on the database HousingAffordabilityData
, as shown in the following screenshot:
We can...