500pnts!!!!! - SQL Server Deployment & Security

Hi there

SQL amateur here so should be an easy 500 pnts

I've posted a similar question a while back ( http://www.experts-exchange.com/Programming/Programming_Languages/C_Sharp/Q_21598256.html?query=Could+Not+Find+Stored+Procedure&clearTAFilter=true )

I am having similar issues when deploying our dev database server and web app to our test environment. We deploy via the following process.

1) Generate SQL Script on DEV box
2) Create New Database on TEST  box, run generated script on TEST box
3) Create a user or user group on our AD server - eg TEST1
4) Add TEST1 to TEST db and grant access to the user/group as db_owner
5) Install our Web App

When I log into a remote machine as TEST1 or a user within the GROUP and run a simple test

        mcnSQL = new SqlConnection();
        mcnSQL.ConnectionString = "integrated security=SSPI;data source=" + sqlServer + ";persist security info=False;";
        mcnSQL.Open();

        SqlCommand oSqlCommand = new SqlCommand("dbo.spfSPTest", mcnSQL);
        oSqlCommand.CommandType = CommandType.StoredProcedure;
        SqlDataReader oReader = oSqlCommand.ExecuteReader();

Which throw an exception 'Could Find Store Procedure dbo.spfSPTest'

This app is run via IIS which is configured with anonomous access disabled, I also have impersonation set to true in web.config and have checked the user correctly comes through as SPF/TEST1

I've read up in various sites that the issue lies with the dbo as that user would be the logged in user at the time the script was executed. But I can't find any real explanation why or any standard practices to deploy SQL databases.

One other thing to note is that after several hours of tweaking permissions, adding/removing/re-adding the users or group it eventually will start working but have no idea how or why!

TIA and let me know if you want more info or the database script.

Cheers