Can't connect to filevisa db

Hello.

I am testing FileVista now.
I have installed it on Windows 2008 R2 with SQL server 2008 express.
I succeded to create the filevista db.
When trying to connect through the 'Choose DB type and configure connection setting' it failed with 'login failed for user xxx' error message.
I have tried both the 'trusted connection' (via administrator) and a dv user i have created that has all the permissions as dbo.

Please help.

Regards,

Moshe

I am seeing the same issue trying to use a remote SQL 2008 Express database on a Windows Server 2008 R2 Server. With Windows authentication and SQL Authenticaion with users that have DBO Rights.

FileVista will try to connect to the SQL Server in the context of the IIS application domain identity.
This is usually Network Service account (noted on the first page of the FileVista config page).
You need to assign this user db_owner role on the FileVista database in SQL Server Management Studio.
Then you should just select “Trusted user” (means Windows authentication) on FileVista db config page and be able to connect.

If you want to use SQL authentication, then you should use a custom SQL server user which again has db_owner role on the FileVista database.
Then you should enter the username and password of this user on FileVista db config page.