Error installing SBConnect from April 2012 Refresh

Question

I am trying to install the SBConnect from the April 2012 Refresh and getting an error when it tried to create the database.

In the Microsoft ServiceBus Connect Setup : Choose Setup Type - I am choosing Complete

In the Microsoft ServiceBus Connect Setup : Management Service Application Pool - I am using a Other and specifing a local account with admin rights

In the Microsoft ServiceBus Connect Setup : Configure Store Database - I am using the localhost (local SQL 2008 R2)

In the Microsoft ServiceBus Connect Setup : Configure Store Master Key - I am using a complex password

In the Microsoft ServiceBus Connect Setup : Management Service Site Binding - default values except an existing certificate

When the install gets to creating database it fails with: Error -2147467259: failed to create SQL database: SBConnect, error detail: unknown error.

Anyone else get this to work?

---

Bill Chesnut | BizTalk Server MVP | Mexia Consulting | Melbourne Australia
http://www.biztalkbill.com
Please indicate "Mark as Answer" if this post has answered the question.

Answer 1

This is the log from the failure:

MSI (s) (34:CC) [09:43:53:292]: Executing op: ActionStart(Name=CreateDatabase,Description=Creating Databases,)
MSI (s) (34:CC) [09:43:53:292]: Executing op: CustomActionSchedule(Action=CreateDatabase,ActionType=25601,Source=BinaryData,Target=**********,CustomActionData=**********)
MSI (s) (34:CC) [09:43:53:370]: Creating MSIHANDLE (1167) of type 790536 for thread 7116
MSI (s) (34:E4) [09:43:53:370]: Invoking remote custom action. DLL: C:\Windows\Installer\MSI823D.tmp, Entrypoint: CreateDatabase
MSI (s) (34!F4) [09:44:11:207]: Creating MSIHANDLE (1168) of type 790531 for thread 10996
CreateDatabase:  Error 0x80004005: failed to create to database: 'SBConnect', error: unknown error
MSI (s) (34!F4) [09:44:11:207]: Closing MSIHANDLE (1168) of type 790531 for thread 10996
MSI (s) (34!F4) [09:44:11:207]: Creating MSIHANDLE (1169) of type 790531 for thread 10996
MSI (s) (34!F4) [10:06:54:794]: Product: Microsoft ServiceBus Connect -- Error 26201. Error -2147467259: failed to create SQL database: SBConnect, error detail: unknown error.

MSI (s) (34!F4) [10:06:54:794]: Closing MSIHANDLE (1169) of type 790531 for thread 10996
CustomAction CreateDatabase returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox)
MSI (s) (34:E4) [10:06:54:804]: Closing MSIHANDLE (1167) of type 790536 for thread 7116
Action ended 10:06:54: InstallFinalize. Return value 3.

---

Bill Chesnut | BizTalk Server MVP | Mexia Consulting | Melbourne Australia
http://www.biztalkbill.com
Please indicate "Mark as Answer" if this post has answered the question.

Answer 2

The install works on a machine that did not have the previous version installed, but does not work on a machine that had the previous release on.

---

Bill Chesnut | BizTalk Server MVP | Mexia Consulting | Melbourne Australia
http://www.biztalkbill.com
Please indicate "Mark as Answer" if this post has answered the question.

Answer 3

Do you have a previous version of the bits installed? Do you have permissions to create database on the SQL Server intance you are targeting?

---

______ Nitin Mehrotra, Service Bus EAI/EDI CCxG, http://blogs.msdn.com/nitinme/

Answer 4

I have uninstalled the previous bits.

I am in the local administrators group on the machine and sysadmin in the database, should not be a permissions error.

---

Bill Chesnut | BizTalk Server MVP | Mexia Consulting | Melbourne Australia
http://www.biztalkbill.com
Please indicate "Mark as Answer" if this post has answered the question.

Answer 5

Hi Bill,

Can you try to install using the below configuration and check?

In Configure Store Database screen, specify Server as '.' or '<machinename>' instead of 'localhost'.

Thanks

Answer 6

Thanks, I used the machine name an it worked, I should have thought of that.

---

Bill Chesnut | BizTalk Server MVP | Mexia Consulting | Melbourne Australia
http://www.biztalkbill.com
Please indicate "Mark as Answer" if this post has answered the question.