0xC0002A21 – SSO Configuration Failed

 

I was trying to configure BizTalk Server 2009 with SQL Server 2008 SP1, SSO configuration throws the following error:

(0xC0002A21) An error occurred while attempting to access the SSO database.  (SSO)
SQL: 0x00000FDC: Cannot open database "SSODB" requested by the login. The login failed. Login failed for user…

One odd reason of this exception is an old SSO database file in the database folder

‘C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA’

This prevents the creation of SSO DB because a database file already exists at the same path. To resolve, just delete the old SSODB.mdf and SSODB.ldf files