SQL 2014 WSFC and vIDM 2.8.1 Setup Failure

[LJMCP]

When attempting to connect vIDM 2.8.1 and SQL 2014 SP2 on WSFC running on W2K12R2 I am not able to complete the DB connection setup.

I see errors in horizon.log indicating a permission issue, although the horizon sql user account has sysadmin permissions on the db and I see all the tables created in the DB in SQL Management Studio.

horizon.log -

ALTER COLUMN strUsername
NVARCHAR(150) COLLATE SQL_Latin1_General_CP1_CI_AS: Cannot find the object "Users" because it does not exist or you do not have permissions.

Anyone else successfully install vIDM with SQL 2014 on WSFC?

I am able to complete the configuration using a standalone SQL 2014 SP2 database.

Thanks!

[jrainone]

Hi LJMCP

While I have not configured VIDM against a Clustered SQL instance lately I have done several stand-alone and AlwaysOn configurations.  Based on my limited knowledge of SQL I don't believe the SQL Connection string should be any differen't. 

• Does it matter which physical instance is active to get that error?
• Is this on the initial appliance configuration?

[LJMCP]

I've attempted the install while having the clustered instance on either nodes and same result.  I am attempting the initial db connection setup after deploying the appliance, after supplying the passwords.