Don't Make Assumptions in Your Installers

TIBCO iProcess Engine makes an assumption when it installs. It assumes that the database owner name and the schema name for that user will match. With a standard mixed-mode SQL Server 2005 install this would be fine – throw Windows Integrated Authentication (WIA) in the mix and it gets complicated. SQL2k5 creates a dbo user, linked to a domain account, and a dbo schema. TIBCO assumes the schema name will match what it resolves the dbowner to (domain/user). It doesn’t allow you to override this. It doesn’t take what SQL2k5 says is the default schema for the user. It makes an assumption. Which then results in a error during installation or the creation of a schema that can break enterprise standards. And it’s just ugly.

Don’t make assumptions in your installers.

Advertisements

Author: Kevan

Director, Technology at Capital One Labs. Married to Erin, with two sons, Cooper and Fletcher. We live in Arlington, VA, USA.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s