I would like to see the very first error, but it looks like you are in the wrong database or have incorrect permissions for some strange reason.
Do you have access to SQL Server Management Studio? If so, login to your database, using the credentials provided, and click New Query. (If not, login as host and select host|sql. You can run these examples, but not fix the problems easily.)
select db_name()
Click execute. What database is returned? If this is not the correct database, then you should assign the default database to the user.
Connection|Security|Logins, right click user, properties. Under general, select the default database.
Under User mapping, .select the database, then scroll down the roles and ensure db_owner is selected. Select ok.
To verify the user has db_owner execute this
exec sp_helprolemember
This proper SQL setup must be working before installing DNN.
As far as automating installation, simply drop smithcart into the ~\Install\Modules folder before installing DNN. When DNN is installed (or manually using domain\install.aspx?mode=install) any zip files (modules) will be installed automatically.