Recently I tried to configure BizTalk 2010 on which Visual Studio 2010 was already installed.
I could not configure SSO and got the following error message in the log file.
Failed to create the SQL database Source="SSO" HelpID=""><Exception Message="(0xC0002A21) An error occurred while attempting to access the SSO database.
It also said to check the eventlog for more details but there was no error in Eventlog.
Finally I traced the issue that it was because of the missing folders on the SQL Server machine so SQL Server could not create the databases and log files.
I found it out by using SQL Profiler and activating all types of Events.
I knew of many SSO Errors so tried everything like registering SSOSQL.dll and other fixes but never imagined it could be because of SQL not been configured properly.
I could not configure SSO and got the following error message in the log file.
Failed to create the SQL database Source="SSO" HelpID=""><Exception Message="(0xC0002A21) An error occurred while attempting to access the SSO database.
It also said to check the eventlog for more details but there was no error in Eventlog.
Finally I traced the issue that it was because of the missing folders on the SQL Server machine so SQL Server could not create the databases and log files.
I found it out by using SQL Profiler and activating all types of Events.
I knew of many SSO Errors so tried everything like registering SSOSQL.dll and other fixes but never imagined it could be because of SQL not been configured properly.
Thanks for writing such a good article, I stumbled onto your blog. I like your style of writing…
ReplyDeleteBiztalk Online Training Hyderabad
Thanks for sharing it's very good blog Biztalk online training Bangalore
ReplyDelete