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

Advertisements

4 Responses to “0xC0002A21 – SSO Configuration Failed”

  1. Digambar Says:

    thanks a ton!

  2. maddcoder Says:

    Thanks that helped –
    Instead of deleting – SSODB, i just had to detach and re attach.

  3. Omer Says:

    Wa wa Dr saab – bilkul sahi.. aap to hamaray hi kaam aye..

  4. Anonymous Says:

    Thanks a lot brother.
    The above resolution helped me resolve the issue.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: