ClearCanvas Server 13.2 cannot get past "Database directory setup" when installing.

[irbisbear]

Have Windows Server 2016. Added SQL express. Everything standard. Enabled sa login. Installed all Net frameworks, intalled IIS. However, when installing ClearCanvas Server 13.2 right after entering sa login, it takes me to "DB file Directory" page where I am stuck. By default it has:
C:\Program Files\Microsoft SQL Server
but when clicking next, it gives an error "Database cannot be created in the directory specified. This is often because of directory permissions. Please select another directory."

I tried putting:
hostname/SQLEXPRESS
localhost/SQLEXPRESS
127.0.0.1/SQLEXPRESS
/localhost/SQLEXPRESS
but still getting same error. I tried selecting every possible permission for sa login and still same problem. Please, help me to get past that part of install.
I read ClearCanvas Server installation guide and it shows database connection information page where I enter sa login and as a next step it shows "Filesystem setup". It doesn't show or talk about "DB file Directory" at all. Please, help.

Here is the image:

[radyworks]

Not sure this will help, please try to run the installer in Administrator mode - "Run As Administator"

[irbisbear]

Hello @radyworks

Thank you for suggestion. I usually always try to "Run as admin" when installing programs. I tried again making sure I run as admin and same thing is happening. I went through all issues on this forum and noone is mentioning this problem. If that makes difference, I am running windows server 2016 on amazon aws cloud as EC2 instance. What would be the best OS for ClearCanvas Server 13.2?

[medcornsa]

Hi,

Best OS for ClearCanvas Server 13.2

If ClearCanvas Server 13.2 - 64 bit package please choose 64 bit windows server and 64 bit SQL server

Try it for windows server 2012 R2 and SQL server 2008 R2.

[steveTree]

I did manage to get past this step ruining the latest SQL server, but cannot remember what i needed to do
things i did do
(0) when installing make sure that the accounts can have R/W access to the place the DB is going ( I found it beneficial to put it in a non stranded place so i could keep a eye on it, testing only )
(1) make sure i had SQl management studio installed ( i used SQL server managements studio 17
changed the security mode in the management studio to SQl server and windows authentication mode. 9 open managment right click at top level select properties - security)
(2)go to main- security -logins and enabled SA and changed the PW
(3) to get the name of the its normal in the form "host macine name"/SQLEXPRESS

suspect your problems are R/W permition related
hope that helps

[goldang]

This error is s caused by a permissions error for where it is trying to create that directory - I experienced it too. I changed my install directory to e:\ and it worked.