VS for Db Prof - Units Tests & Deploying Dbs

[Craig_dt]

Hi,

Trying to get to grips with VS for Db Prof (2008).

I'm trying to deploy a db as part of running unit tests.

Deploying onto SQL Express using Windows Authentication.

The unit tests fail, and the details are a deployment failure in MSBuild
class.

I suspect the issue is (as so often is the case) permissions based. So a
starting question is what security context does VS run under when running its
tests (and deploying) (I can deply the database project fine, and I can run
the SQL unit tests fine so long as I do not deploy as part of the tests).

I don't have any agents/controllers setup for tests, and the environemtn is
not on a domain account, but in a self contained environment.

My account has local admin privileges (I'm getting to grips with this tool
and I'll sort out accoutnts/privileges *once* the basic deploy/test cycle is
up and running).

Thanks for any help :)