Hello Guest, Welcome to Apnea Board !
As a guest, you are limited to certain areas of the board and there are some features you can't use.
To post a message, you must create a free account using a valid email address.

or Create an Account


New Posts   Today's Posts

Installing SQL for EncorePro
#1
Question 
Installing SQL for EncorePro
The installation of EncorePro 2.23 halts, presumably because SQL Server 2008 is not installed. There are many versions of 2008. I'm looking for one that is known to be sufficient for EncorePro, minimal in footprint and free. Suggestions?

Secondly, in watching some YouTube videos I see a multitude of SQL option settings. How does one determine the selections?

Unfortunatly  I can't search for SQL here because that is too short.
Post Reply Post Reply






Donate to Apnea Board  
#2
RE: Installing SQL for EncorePro
I have encore pro running on my windows 10 laptop I installed Microsoft SQL Server Express 2017 (the free one)

I also needed to install the Microsoft SQL Server Management Studio also free to change settings so encore pro would install. the settings to change are documented in the encore pro installation guide


See my steps in this thread http://www.apneaboard.com/forums/Thread-...ients-only

First you need to install The following software first
Microsoft SQL Server Express (I went for version 2017)
Microsoft SQL Server Management Suite

Then read the Installation manual and configure the following on the MSSQL Server
Filestream Support
Filestream Full Access
Mixed Mode Authentication

Then once you have done that then you need to run the EP2.3 Installer, Select a custom install (as That's your only choice) in the Server location select your instance on MSSQL just installed

But the install does work.
Post Reply Post Reply
#3
RE: Installing SQL for EncorePro
Here's the download page for the free Microsoft® SQL Server® 2017 Express::

https://www.microsoft.com/en-us/download...x?id=55994
SuperSleeper
Apnea Board Administrator
www.ApneaBoard.com


INFORMATION ON APNEA BOARD FORUMS OR ON APNEABOARD.COM SHOULD NOT BE CONSIDERED AS MEDICAL ADVICE. ALWAYS SEEK THE ADVICE OF A PHYSICIAN BEFORE SEEKING TREATMENT FOR MEDICAL CONDITIONS, INCLUDING SLEEP APNEA. INFORMATION POSTED ON THE APNEA BOARD WEB SITE AND FORUMS ARE PERSONAL OPINION ONLY AND NOT NECESSARILY A STATEMENT OF FACT.




#apneaboard
Post Reply Post Reply
#4
RE: Installing SQL for EncorePro
Thanks    Looks like a weekend project.
Post Reply Post Reply






Donate to Apnea Board  
#5
RE: Installing SQL for EncorePro
I must have missed something.

Installed both SQL Server Express 2017 (Basic) and SQL Server Management 18.4 and then restarted as instructed.

But I never saw the Installation manual to guide me in configuring the MSSQL Server. So I am stuck. Should I uninstall both and start over looking for an Installation manual?
Post Reply Post Reply
#6
RE: Installing SQL for EncorePro
(12-04-2019, 03:22 PM)Dee Nyal Wrote: I must have missed something.

Installed both SQL Server Express 2017 (Basic) and SQL Server Management 18.4 and then restarted as instructed.

But I never saw the Installation manual to guide me in configuring the MSSQL Server. So I am stuck. Should I uninstall both and start over looking for an Installation manual?

The encore pro installation manyal covered the settings required as described and a bit of following and Google showed me what to do
Post Reply Post Reply
#7
RE: Installing SQL for EncorePro
You may not be aware, but there is a client-only version of EncorePro now that does not require SQL server... it's smaller in size and less of a pain to install and configure.  The only reason that I know of as to why someone would want the full server version is if they're keeping tracking of several patients.  (Please let me know if you know of another reason to use the full server version)

Instructions on how to get the newest EncorePro 2.24 here:

http://www.apneaboard.com/forums/Thread-...hines-only

Log into your forum account to access the above link.

With the new version, you don't need SQL Server at all.
SuperSleeper
Apnea Board Administrator
www.ApneaBoard.com


INFORMATION ON APNEA BOARD FORUMS OR ON APNEABOARD.COM SHOULD NOT BE CONSIDERED AS MEDICAL ADVICE. ALWAYS SEEK THE ADVICE OF A PHYSICIAN BEFORE SEEKING TREATMENT FOR MEDICAL CONDITIONS, INCLUDING SLEEP APNEA. INFORMATION POSTED ON THE APNEA BOARD WEB SITE AND FORUMS ARE PERSONAL OPINION ONLY AND NOT NECESSARILY A STATEMENT OF FACT.




#apneaboard
Post Reply Post Reply






Donate to Apnea Board  
#8
RE: Installing SQL for EncorePro
Wow! No SQL! Thanks for alerting me to 2.24; I have downloaded it. 2.23 is also single user client only but the install of SQL was a nightmare for me.

And yes, this is the only program that (I hope) will work for me.
Post Reply Post Reply
#9
RE: Installing SQL for EncorePro
It isn't going well with 2.24.

Select Type
advanced is forced

Select Features
all are checked

Database Server
no server is shown
attempt to proceed results in: Failed to connect to given server
there were authentication boxes that are in the 2.23 install

Backup to Select Features
uncheck Database and continue

Select Server
(local)\ENCOREPRO2 is shown
click on Find Server and error results
This server does not exist or does not contain an EncorePro version 2.24 Database

Cannot proceed.

I note the comment about unlocking the software after downloading. I assume that the unlocking is after installation.

I did uninstall or delete everything I could find that was related to SQL.

Has anyone been successful in installing 2.24?
Post Reply Post Reply
#10
RE: Installing SQL for EncorePro
(12-06-2019, 04:47 PM)Dee Nyal Wrote: It isn't going well with 2.24.

Select Type
advanced is forced

Select Features
all are checked

Database Server
no server is shown
attempt to proceed results in: Failed to connect to given server
there were authentication boxes that are in the 2.23 install

Backup to Select Features
uncheck Database  and continue

Select Server
(local)\ENCOREPRO2 is shown
click on Find Server and error results
This server does not exist or does not contain an EncorePro version 2.24 Database

Cannot proceed.

I note the comment about unlocking the software after downloading. I assume that the unlocking is after installation.

I did uninstall or delete everything I could find that was related to SQL.

Has anyone been successful in installing 2.24?

Exactly the same result for me. Advanced install forced, then stuck when asked for a database...
:-(
Post Reply Post Reply






Donate to Apnea Board  


Possibly Related Threads...
Thread Author Replies Views Last Post
  EncorePro 2 password locked [unlock utility in post #3] KSMike 32 7,424 11-02-2020, 08:38 PM
Last Post: Naroz
  Installing OSCAR-copy from desktop to laptop for travel Samultra 3 124 09-22-2020, 10:59 AM
Last Post: Samultra
  Installing OSCAR on Second Computer SideSleeper 2 119 09-16-2020, 06:49 PM
Last Post: SideSleeper
Sad Problem installing Oscar with SleepyHead info Tinkerbell 9 156 09-16-2020, 01:46 AM
Last Post: jaswilliams
  Oscar installing on Ubuntu 18.04 - problem - please help spioch 5 367 03-31-2020, 03:47 PM
Last Post: spioch
  Installing Oscar to new Chromebook chronic 31 1,289 03-26-2020, 05:11 PM
Last Post: mjphyi
Angry problème d’installation de Encorepro 2.24 [Problem installing EncorePro 2.24] tiaibachir 0 277 02-23-2020, 05:34 AM
Last Post: tiaibachir


New Posts   Today's Posts






About Apnea Board

Apnea Board is an educational web site designed to empower Sleep Apnea patients.