views:

14

answers:

0

I'm trying to integrate database unit tests into the build process (Visual Studio 2005, TFS, VS for Database Professionals, MS SQL Server 2005). The build is running on a dedicated build server. When the tests (that work perfectly locally) start running on the server, I get a "login failed" error because the database password I save in Test->Database Test Configuration...->Edit Connection is only stored locally. I can't find it in any of the project configuration files so I'm pretty sure it is not copied to the build server when sources are gathered. How can I set the password on the server? Should I look into the build .proj file?