I have decided that, as I come across errors in what I do related to BizTalk, I will document how I overcame these errors.

 

So in fix the error lesson 1, we had a problem running config frame work on BizTalk 2006.

 

The error was very vague:  ERROR: 0x80070002 : The system cannot find the file specified.

 

The detailed log did not offer any help other than:  Error code: (0xC0002A21) or (0x80004005)

 

[04:27:15 PM Warning SSOServerCfg] (ssoconfigobj2.cpp:1626) 0xC0002A21 (-1073731039)

[04:27:15 PM Info SSOServerCfg] (ssoconfigobj2.cpp:5125) Returning error description: <Exception Message="Failed to create the SQL database 'SSODB' on SQL Server 'ormpoc01' (with SSO Administrator account 'DOMAIN\SSO Administrators')." Source="SSO" HelpID=""><Exception Message="(0xC0002A21) An error occurred while attempting to access the SSO database.

" Source="SSO" HelpID=""><Exception Message="An error occurred while attempting to access the SSO database. See the event log (on computer 'ORMPOC02') for more details.

 (SQL: 0x00000FDC: Cannot open database &quot;SSODB&quot; requested by the login. The login failed.

Login failed for user 'DOMAIN\BizTalkServiceAccoun'.)" Source="SSO" HelpID=""/></Exception></Exception>

[04:27:15 PM Warning SSOServerCfg] (ssoconfigobj2.cpp:1652) CSSOServerCfg::ConfigureFeature: 0x80004005 (-2147467259)

[04:27:15 PM Warning Configuration Framework]Feature failed to configure: SSOServer,Engine.

[04:27:15 PM Info Configuration Framework]Configuration Summaries:

[04:27:15 PM Error Configuration Framework]Feature: [Enterprise SSO] Failed to configure with error message [<Exception Message="Failed to create the SQL database 'SSODB' on SQL Server 'ormpoc01' (with SSO Administrator account 'DOMAIN\SSO Administrators')." Source="SSO" HelpID=""><Exception Message="(0xC0002A21) An error occurred while attempting to access the SSO database.

" Source="SSO" HelpID=""><Exception Message="An error occurred while attempting to access the SSO database. See the event log (on computer 'ORMPOC02') for more details.

 (SQL: 0x00000FDC: Cannot open database &quot;SSODB&quot; requested by the login. The login failed.

Login failed for user 'DOMAIN\BizTalkServiceAccoun'.)" Source="SSO" HelpID=""/></Exception></Exception>]

 

Neither of these error codes provided us with any help. I did some investigation, as it was failing on the SSO config, the first part of the config framework, I looked into why it would be failing.

 

We checked: DTC comms, as SQL was on a different machine, this was not correct, it was corrected.

 

Next was SQL Server permissions, this was correct, and everything was great for the currently logged on user, as well as our BizTalk user.

 

I tried to do it manually as you can via the command line tools:

 

C:\Program Files\Common Files\Enterprise Single Sign-On>ssoconfig -createdb ormpoc01 "DOMAIN\biztalkserviceaccount"  "DOMAIN\biztalkserviceaccount"

 

This is where I received: ERROR: 0x80070002 : The system cannot find the file specified.

 

Now annoyed, I knew that step created the sso db, and it could not, so why not try and create a database called the SSSODB ?? This produced an error as well, giving me the solution.

 

The solution….. As part of one of the failed install attempts, the SSO Database had been created, and by the time I was involved, it had been removed. HOWEVER… The physical file SSODB.DBF was not removed from the file system, it was lying around.

 

Hence if you tried to create the SSO database it would have failed as the database file already exists. SQL Server provides the correct error detail when you try and do this, however BizTalk was not reporting this up the stack. Where did my error disappear to?

 

Delete the offending SQL database file, and it all worked 100%.