well the webserver does not need to connect to the SQL server, your script would do that, so cant help you much there with out knowing what language you use.
as for creatting tables, you can download the MS SQL Server Management Studio Express from microsofts website for free, or if you have a full copy of SQL server the CD should have the management software on it.