When trying to attach a Vault database to the ADMS Console you can see this error.
In the ADMS Console log you will see an error similar to this:-
CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data\KnowledgeVaultMaster.mdf'. ---> System.Data.SqlClient.SqlException: CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data\KnowledgeVaultMaster.mdf'
This can happen if there are not sufficient Security permissions set on the files or the containing folders.
To be able to attach Vault databases, the "SYSTEM" and "SQLServer2005MSSQLUser$<COMPUTERNAME>$AUTODESKVAULT" user accounts must have full permission over the files.
Subscribe
Comments