VMware Workspace ONE Community
LJMCP
Enthusiast
Enthusiast

SQL 2014 WSFC and vIDM 2.8.1 Setup Failure

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!

Reply
0 Kudos
2 Replies
jrainone
Contributor
Contributor

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?
Reply
0 Kudos
LJMCP
Enthusiast
Enthusiast

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.

Reply
0 Kudos