Moving BizTalk 2006 Database from SQL 2000 to SQL 2005

If you open up the properties of the BTSNTSvc.exe file (by default located in C:\Program Files\Microsoft BizTalk Server 2006), go to the version tab and look at the Product Name. If it's R2, it will say so there. If not, it will just say Microsoft BizTalk Server 2006.

Hope that helps!

A few of pointers:

• Check out the two points at the end of the Configuring Enterprise SSO Using the Configuration Manager page on MSDN:

When configuring the SSO Windows accounts using local accounts, you must specify the account name without the computer name.

When using a local SQL Server named instance as data store, you must use LocalMachineName\InstanceName instead of LocalMachineName\InstanceName, PortNumber.

• Check out the relevant installation guide (don't worry about the fact that it relates to R2, they seems to have hidden the 'R1' documentation, but they are the same), and specifically the section around "Windows Groups and Service Accounts"

• also - just to be sure - when you have uninstalled BizTalk and removed the databases - you have removed the SSODB as well, right?! :-)

• The log files are very confusing - especially when deciding which error is the acutal problem - have you tried looking up any other errors you've had? (check out this blog entry, for example)