I am trying to run unit tests in Visual Studio on a local database. The unit test project was created by another user locally on his PC and runs there successfully. I cloned his project on my machine, created the database with the same publish profile as him but when I run the tests it fails with the error:
System.Data.SqlClient.SqlException: Login failed for user 'sa'..
I made sure that the unit test project in VS can access on the database by configuring the SQL Server Test Configuration. It means it should have access to my database. For both databases we use the same user name and the same password.