FOCA icon indicating copy to clipboard operation
FOCA copied to clipboard

Foca 4.3.7.1 - Needs SQL Database although SQL Express 2022 is installed

Open kastahl opened this issue 2 years ago • 3 comments

I installed SQL Express 2022 successfully and run FOCA for installation. Unfortunately, I received the message that FOCA needs a SQL database. Trying to setup a databse connection failed.

I tried as Server name following combinations:

  • ".\SQLEXPRESS"
  • "SQLEXPRESS"
  • "localhost\SQLEXPRESS"
  • "localhost"
  • "systemname\SQLEXPRESS"

Attached also a screenshot from the FOCA error message, which refers to a connection timeout. Note that this message appears in less then a second. And a screenshot from the SQLSERVER version.

foca-error

sqlexpress-version

I already found and check this issue #95 but no luck with the solution.

kastahl avatar Jan 19 '23 16:01 kastahl

danielcshn avatar Mar 17 '23 22:03 danielcshn

Hi, thx, but it still does not work. Please see attached image.

1-

kastahl avatar Jun 26 '23 11:06 kastahl

you should try to connect through the sql authentication option, using the name of the local host or your own ip with port. after, try the sa password. It worked for me in my mac

Emergumeno avatar Nov 05 '23 23:11 Emergumeno