SRM 5.11 Installation Error : failed to create database tables

[JinshengChen]

Hi all,

I saw an odd error message when installing SRM 5.11 to Windows Server 2008 R2.

The message was shown up during database creation step and it says:

Failed to create database tables.

Details:

There was an error during execution: Invalid argument:

'C:\Users\myusername\AppData\Local\VMware' is not a directory

Press Retry to try again or press Cancel to exit installation

Have anyone seen it?

[marcelo_soares]

Have you created the appropriate SQL schema on the database? Is the database supported fr this version of SRM? You can check it here: VMware Product Interoperability Matrixes

[marcelo_soares]

Did the schema creation resolved?

[JinshengChen]

I did not create a schema, instead I mapped the login to dbo of the SRM database.

I tried again with assigning the login sysadmin role, and this time it worked.

Is there a document describing the minimum permission required for database in the installation?

[marcelo_soares]

The documentation have this information. You can get it from here: http://pubs.vmware.com/srm-51/topic/com.vmware.ICbase/PDF/srm-install-config-5-1.pdf

Page 17.

Please mark the answer as helpful or correct if this was useful to you