A few days ago I installed Biztalk Server 2006 Beta 1 and during Configuration I got the following error when trying to configure Enterprise Single Sign On:

“Failed to connect to the SQL database SSODB on MY-MACHINE (An error occurred while attempting to access the SSO database).”

This is caused when the SQL server name was changed in the machine, and the value of the variable @@servername was not updated.

SSO uses “select @@servername” to return the name of the SQL Server. However, this apparently returns the name of the SQL Server at the time it was configured - and not the current value! Thus, the SQL Server name that we are getting from SQL is old (I guess it was changed on these machines), so config is getting confused and can’t create the required local accounts.

To workaround this issue, you should change the value of the @@servername variable to match your computer name using the sp_dropserver and sp_addserver SPs:

1.       select @@servername
2.       Check if value returned by step 1 match you machine name

3.       If it does not match:

      3.1.    exec sp_dropserver ’servername1′  -> where servername1 is the value returned by step 1

      3.2.    exec sp_addserver ‘my-machine’, ‘local’  -> where my-machine is the name of your machine

      3.3.    restart sql server service