Could not initialize database: Failed to login as user 'XXX\ContinuaCI'

Continua CI Discussion
1

Fresh install using SQL Server 2012.  I created a Service account and made it the owner of the DB but I still get the above error.


When I run the service from the console with.

.\Continua.Server.Service.exe -console

It is able to init db.  So it has to do something with credentials.  Any ideas?

2

Solution:

The user for the DB was created under the DB and not at the Server level. Why SQL Server thinks I want to add a login to a db that can’t login to the server itself is beyond me. But that was the problem.

Database login did exist but SQLServer login did NOT exist.