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