Important:
This is Step 1 in the Business Connectivity Services On-Premises scenario deployment procedures.

• For a list of all the procedures in order, see Deploy a Business Connectivity Services on-premises solution in SharePoint 2013.

• A fully functional SharePoint 2013 server farm with a Web Application and site collection

• A fully functioning instance of SQL Server 2008 with Service Pack 1 (SP1) and Cumulative Update 2 or SQL Server 2008 R2

• SharePoint Designer 2013

• Outlook 2013 client

• You have an account that has permissions to administer the Business Data Connectivity Service Application

• You have an account that has permissions to administer the Secure Store Service service application

• Download the AdventureWorks sample database from Codeplex downloads for SQL Server. This database must be installed and functioning on your SQL Server

• Create an Active Directory directory Service (AD DS) security group and add the users who will be using this BCS solution, for example create a group that is named AdventureWorksBCSUsers

The AdventureWorks sample database is developed and published by Microsoft. The AdventureWorks sample database is prepopulated with a large quantity of fictitious data from a fictitious company, AdventureWorks Cycles. We are using the AdventureWorks sample database here so we have a concrete example for illustrating the installation and configuration of the on-premises BCS scenario.

Tip:
If you have problems attaching the database file by using the Attach command, in the Attach databases dialog box, and remove the reference to the log file in the bottom pane before you click OK.

How to download and install the AdventureWorks sample database