Warning: Creating default object from empty value in /home/content/42/8272142/html/wp-content/themes/platform/includes/class.layout.php on line 164

Warning: Creating default object from empty value in /home/content/42/8272142/html/wp-content/themes/platform/includes/class.layout.php on line 167

Warning: Creating default object from empty value in /home/content/42/8272142/html/wp-content/themes/platform/includes/class.layout.php on line 170

Warning: Creating default object from empty value in /home/content/42/8272142/html/wp-content/themes/platform/includes/class.layout.php on line 173

Warning: Creating default object from empty value in /home/content/42/8272142/html/wp-content/themes/platform/includes/class.layout.php on line 176

Warning: Creating default object from empty value in /home/content/42/8272142/html/wp-content/themes/platform/includes/class.layout.php on line 178

Warning: Creating default object from empty value in /home/content/42/8272142/html/wp-content/themes/platform/includes/class.layout.php on line 180

Warning: Creating default object from empty value in /home/content/42/8272142/html/wp-content/themes/platform/includes/class.layout.php on line 202

Warning: Creating default object from empty value in /home/content/42/8272142/html/wp-content/themes/platform/includes/class.layout.php on line 206

Warning: Creating default object from empty value in /home/content/42/8272142/html/wp-content/themes/platform/includes/class.layout.php on line 224

Warning: Creating default object from empty value in /home/content/42/8272142/html/wp-content/themes/platform/includes/class.layout.php on line 225

Warning: Creating default object from empty value in /home/content/42/8272142/html/wp-content/themes/platform/includes/class.layout.php on line 227

Warning: Creating default object from empty value in /home/content/42/8272142/html/wp-content/themes/platform/includes/class.layout.php on line 321

Warning: Creating default object from empty value in /home/content/42/8272142/html/wp-content/themes/platform/includes/class.layout.php on line 321

Warning: Creating default object from empty value in /home/content/42/8272142/html/wp-content/themes/platform/includes/class.layout.php on line 321

Warning: Creating default object from empty value in /home/content/42/8272142/html/wp-content/themes/platform/includes/class.layout.php on line 321

Warning: Creating default object from empty value in /home/content/42/8272142/html/wp-content/themes/platform/admin/class.options.metapanel.php on line 56

Warning: Creating default object from empty value in /home/content/42/8272142/html/wp-content/themes/platform/admin/class.options.metapanel.php on line 56

Warning: Creating default object from empty value in /home/content/42/8272142/html/wp-content/themes/platform/admin/class.options.metapanel.php on line 56

Warning: Creating default object from empty value in /home/content/42/8272142/html/wp-content/themes/platform/admin/class.options.metapanel.php on line 49
How to Define a Data Source in SQL Server 2008 | Data Enthusiast

This is the second of 4 tasks under Lesson 1: Defining a Data Source View within an Analysis Services Project on Microsoft TechNet. We have tried to make their lessons even better by adding screen shots for you.

Summary:

After you create an Analysis Services project, you generally start working with the project by defining one or more data sources that the project will use. When you define a data source, you are defining the connection string information that will be used to connect to the data source. For more information, see Defining a Data Source Using the Data Source Wizard (Analysis Services).

In the following task, you define the AdventureWorksDW2008 (click on the link to download)sample database as the data source for the Analysis Services Tutorial project. While this database is located on your local computer for the purposes of this tutorial, source databases are frequently hosted on one or more remote computers.

* Please make sure you start by opening Analysis Services by clicking on Start, point to All Programs, point to Microsoft SQL Server 2008, and then click SQL Server Business Intelligence Development Studio

To define a new data source
  1. In Solution Explorer, right-click Data Sources, and then click New Data Source.How to Defining a Data Source in SQL Server 2008 step 1
  2. On the Welcome to the Data Source Wizard page, click Next to open the Select how to define the connection page.
  3. On the Select how to define the connection page, you can define a data source based on a new connection, based on an existing connection, or based on a previously defined data source object. In this tutorial, you define a data source based on a new connection. Verify that Create a data source based on an existing or new connection is selected and then click New. image
  4. In the Connection Manager dialog box, you define connection properties for the data source. In the Provider list, verify that Native OLE DBSQL Server Native Client 10.0 is selected.image Analysis Services also supports other providers, which are displayed in the Provider list.
  5. In the Server name text box, type localhost.To connect to a named instance on your local computer, type localhost<instance name>. To connect to the specific computer instead of the local computer, type the computer name or IP address.image
  6. Verify that Use Windows Authentication is selected. In the Select or enter a database name list, select AdventureWorksDW2008.image
  7. Click Test Connection to test the connection to the database.How to Defining a Data Source in SQL Server 2008 step 7
  8. Click OK, and then click OK again.image
  9. Click Next.image
  10. On the Impersonation Information page of the wizard, you define the security credentials for Analysis Services to use to connect to the data source. Impersonation affects the Windows account used to connect to the data source when Windows Authentication is selected. Analysis Services does not support impersonation for processing OLAP objects. Select Use the service account, and then click Next.image
  11. On the Completing the Wizard page, type the name Adventure Works DW image
  12. Click Finish to create the new data source. image
Tagged with:
 
  • llc

    this post is very usefull thx!

  • It’s not that I want to duplicate your internet site, but I really like the design. Could you tell me which theme are you using? Or was it tailor made?

    • Look at the very bottom of the blog. You’ll see the theme info you need there 🙂

  • Leola Kincer

    Glad to find this information. I have been searching in Google for long time.

  • Mee Lucks

    Hey great site and I enjoyed it!

  • Susan Rojas

    Thanks for another awesome post. Keep rocking.

About The Author

Joshua Burkhow

Joshua is an experienced analytics professional with focus on areas such as Analytics, Big Data, Business Intelligence, Data Science and Statistics. He has more than 13 years experience in Business Intelligence & Data Warehousing, Analtyics, IT Management, Software Engineering and Supply Chain Performance Management with Fortune 500 companies. He has specializations in building Analytics organizations, Mobile Reporting, Performance Management, and Business Analysis.

Set your Twitter account name in your settings to use the TwitterBar Section.
%d bloggers like this: