'Login failed' when unit tests are run as part of the build

• balazsbotond

  SSC Enthusiast

  Points: 119

  More actions

  July 23, 2010 at 3:42 am

  #97241

  I'm trying to integrate database unit tests into the build process of a VS team project. The build runs on a dedicated build server. The unit tests start running but they fail with an exception ('Login failed for user XY').

  I think the problem might be that the password I store in Test > Database Test Configuration > Edit Connection is not stored anywhere in the project configuration files, so it is not copied to the build server during the build. The connection string in the test project's app.config only contains the User Id, and adding the password there does not help either.

  How can I specify the password so that the tests can login successfully on the server too?

  I use Visual Studio 2005 with the Team Edition for Database Professionals add-on and SQL server 2005.