From the course: SQL Server Analysis Services
Join today to access over 24,600 courses taught by industry experts.
Review of how to test the model in SQL Server Management Studio - SQL Server Tutorial
From the course: SQL Server Analysis Services
Review of how to test the model in SQL Server Management Studio
- [Instructor] To validate and test the deployment, we're going to take a look at the deployed model within SQL Server Management Studio. To connect to the deployed model, we need to make sure that we are connected using analysis services. And the server name will be the name of the server specified in the project. I could use the actual name of the server here or localhost would work as well. Now authentication is always going to be Windows authentication if you have deployed to an on-premise server. If you have deployed to Azure Active Directory your security that you're going to probably need here is Universal with MFA. I'm going to go ahead and say connect and take a look at our sample projects database. So clicking on the database allows us to see all the tables that are deployed. Let's take a look at the data within them by creating a query. We're going to select New Query. Now notice after we've selected New…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.