Bruce Ng's software development blog
An archive of solutions of programming problems I have faced in my career
From SQL Management Studio, select the table you want to generate schema, right click and select “Script table as…”, then “CREATE to”, then “New query window”
The management studio will generate a create statement to recreate the table, copy the code for your purpose.
Stackoverflow question/answer: http://stackoverflow.com/questions/20723623/application-cannot-open-sql-connection-when-on-iis
You can either give permission to the app pool from within SQL Server.
Or create a SQL Server user/pass, update the connection string to use User/Pass instead of Integrated Security