Friday, July 20, 2007

Problem: Enterprise Single Sign-On (ENTSSO) doesn't start automatically upon system restart

I've experienced strange case these days. We have three BizTalk 2006 servers and SSO service clustered on active-active database cluster. Everything works fine, but when we restart any of biztalk servers, EntSSO does not start automatically on those.
The strange thing is that logging in thru RDP and starting the service manually (net start or from Services panel) it starts without any problem.
When starting automatically, it shuts down with error: Access is denied.

The problem has been solved by adding a registry key pointing to the IP of a clustered SSO service name. Follows .reg file:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\MSSQLServer\Client\ConnectTo]
"ForSSO"="DBMSSOCN,127.0.0.1"


Remember to change 127.0.0.1 for your valid SSO service name IP

Cheers,
Ivan