From the course: SQL Server Analysis Services

Unlock the full course today

Join today to access over 24,600 courses taught by industry experts.

Create a data source to SQL Server

Create a data source to SQL Server - SQL Server Tutorial

From the course: SQL Server Analysis Services

Start my 1-month free trial Buy for my team

Create a data source to SQL Server

“

- [Instructor] So here in our new Analysis Services project, the first thing that we want to do is connect to the data source that we want to analyze. So we're going to go ahead and create a new data source. So to do that I'm going to select Data sources and right click and say that I want to import from a data source and the data source that I want to connect to, I'll go to Database and select SQL Server database and say Connect. The server name is localhost. I'm not going to type the database name, 'cause I want to select it. So here in our SQL Server database window, we do want to impersonate the account. Within Analysis Services, the only way to connect is to use a Windows ID. So we are going to impersonate the service account to connect to it. I'm going to go ahead and say Connect. You will always get this box about encryption support. Since we are running locally, it is fine that it is unencrypted. We're going to…

Contents