Hi all,

I'm just trying to configure the SSO Enterprise service on the first node of
a clustered SQL instance.

When I click on "Apply Configuration", I get a correct window summarizing
the parameters. Then, when the action goes on, it fails after about 40
seconds, saying:

Failed to create the SQL database 'SSODB' on SQL Server 'MySQLCluster' (with
SSO Administrator account 'MyDom/SSO Administrators'). (SSO)

In additional informations, I get:

(SQL: 0xFFFFFFFE: Timeout expired. The timeout period elapsed prior to
completion of the operation or the server is not responding.) (SSO)

If you already encountered this error, please post the potential
resolution(s).


Here are some more details, 'in case':
- The event log has an informational message "Starting up database 'SSODB'".
- Both nodes are in a AD domain, and all accounts / Groups I use are also in
the same domain.
- The service account and current account are domain Admins and SQL Sysadmin
.
- The BizTalk trace makes a lot of checks and then does a rollback:
[...]
[16:40:06 Info SSOServerCfg] (ssoconfigobj2.cpp:7016) SQL is clustered
[16:40:06 Info SSOServerCfg] (ssoconfigobj2.cpp:6201)
CSSOServerCfg::ConfigureRegistry
[16:40:06 Info SSOServerCfg] (ssoconfigobj2.cpp:5970)
CSSOServerCfg::ConfigureDatabase
[16:40:06 Info SSOServerCfg] (ssoconfigobj2.cpp:5976) ISSOConfigDB::GetD
BInfo
[16:40:06 Info SSOServerCfg] (ssoconfigobj2.cpp:6001)
ISSOConfigDB::CreateDatabase
[16:40:41 Info SSOServerCfg] (ssoconfigobj2.cpp:5235)
CSSOServerCfg::ReportMessage
[16:40:41 Warning SSOServerCfg] (ssoconfigobj2.cpp:6020) 0xC0002A21
(-1073731039)
[16:40:41 Warning SSOServerCfg] (ssoconfigobj2.cpp:1271) 0xC0002A21
(-1073731039)
[16:40:41 Info SSOServerCfg] (ssoconfigobj2.cpp:1294) Create: perform ro
llback
[...]
--

JCH

[ Post a follow-up to this message ]

Hi,

You can use the command line utility ssoconfig to have a try:

C:\Program Files\Common Files\Enterprise Single Sign-On>ssoconfig -createdb
<secret server> <SSO Admin account> <SSO Affiliate Admin account>

If you receive "ERROR: 0x80070002 : The system cannot find the file
specified.", please delete the physical file SSODB.DBF and run the
configuration again.

Another possible cause is documented in following article. The
corresponding hotfix is included in Windows 2003 SP2.

A program that uses structured exception handling may stop responding for
several seconds in Microsoft Windows Server 2003 with SP1
http://support.microsoft.com/?id=919341

Please let me know if problem persists. Thanks.

Sincerely,

WenJun Zhang

Microsoft Online Community Support

 ========================================
==========

Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at:

http://msdn.microsoft.com/subscript...t/default.aspx.

 ========================================
==========

This posting is provided "AS IS" with no warranties, and confers no rights.

[ Post a follow-up to this message ]

I tested the configuration on another environment (Virtualized), and the
problem does'nt occur.

It seems that one of these points is realtive to my troubles:
- The first SQL server was running SQL 2005 without SP2,
- The disk performance on virtual environnment was very slow (although
Virtual Server 2005 R2).

Regards,
--

JCH

[ Post a follow-up to this message ]

Sure, I'd also suggest you first apply SQL 2005 SP2 to have test.

Thanks.

Sincerely,

WenJun Zhang

Microsoft Online Community Support

 ========================================
==========

Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at:

http://msdn.microsoft.com/subscript...t/default.aspx.

 ========================================
==========

This posting is provided "AS IS" with no warranties, and confers no rights.

[ Post a follow-up to this message ]

Hi,

Is there any update of this issue?

Sincerely,

WenJun Zhang

Microsoft Online Community Support

 ========================================
==========

Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at:

http://msdn.microsoft.com/subscript...t/default.aspx.

 ========================================
==========

This posting is provided "AS IS" with no warranties, and confers no rights.

[ Post a follow-up to this message ]