[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
Create a New Data Source

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
Tips
Troubleshooting
Tuning

Create a New Data Source



Applies to:  SQL Server 2008 RC 0.


Before creating a cube, we need to also create a Data Source object or use an existing one.

Let's use the Data Source Wizard to create a new Data Source object.


1. On the solution explorer window, make a right click on the Data Sources folder and select the "New Data Source" menu item.





2. The previous step just opened the Data Source Wizard.  Click Next on the dialog below.





3. On the page "Select how to define the connection", click on  the New button.


 

4. On the Connection Manager dialog box, select the "Native OLE DB\SQL Server Native Client 10.0" in the Provider drop down.  For server name type "(local)".  In the "Selec or enter a database name:" drop down, select "AdventureWorkDW".

 




5.  Click on the "Test Connection" button for testing purposes.





6. Click Ok on the dialog above. Click Ok on the Connection Manager screen.  Back on the "Select how to define the connection" page, make sure the connection you just created is selected, and click Next.





7. On the Impersonation Information page, change the Windows Credentials that Analysis Services will use to "Use the service account", then click Next.






8. On the Completing the Wizard page, click on the Finish button.








 

 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.