CODEWITHSUNDEEP
sqlsql-serverssastabular
NebNerlo
NebNerlo

Reputation: 93

Deploying SSAS Tabular Model in a multi Domain environment

Using SQL Server 2016 Standard, VS 2015, SSAS Tabular model created with an Integrated Work space level 1200

We have a multi Domain environment, I moved the Model files over and ran the SSAS deployment wizard success, and can access the model on SSMS while on the box(Remote Desktop/VM)

How can I get it so I can develop (SSRS/power BI/Excel/web app) on my local machine, when I attempt to connect SSMS it Caches my windows user and I cant change it to match the credentials on the box(VM)

Whats the easiest authentication setup for tabular in a multi domain environment

Thank you

Upvotes: 0

Views: 491

Answers (1)

Lucky
Lucky

Reputation: 4493

You must obviously be adding a DataSource to your report already. If you go to the DataSource properties there is a credentials tab on the left. Here to you can specify to use a username and password. You can specify the domain in the user field. Make sure you click the "Use as Windows credentials" checkbox as well. That aught to do it.

Upvotes: 1

Related Questions