BCS / BDC Full Tutorial
for some reasons all posts work upside down - make a step, see the error, fix. so lets go from start to end. you have an sql table and you want it in your sharepoint as a list or for search. OOTB you can do it with SQL, WCF, or .net assembly. with some code you can make it work with almost anything, but some1 has done it already for you: http://lightningtools.com/products/bcs-meta-man-2010-and-2013/ . they also have an extension for VS2010 (only), very nice. STEP 1: have a sharepoint farm, web, site collection and web. well i am kinda counting on you here, create youself all that until you have a web with the ability to create lists. STEP 2: have an external content source. with permissions. in our case its gonna be an sql table. and so you need a user that will have permissions to walk around in your data, and it needs to be the same one that will get permission in the bcs, and he should have permissions to your site. you should give permissions according to the action...