Using the text expander PhraseExpress v16 with a SQL Server

https://www.phraseexpress.com/ - This video guides you step-by-step through the easy installation of a Microsoft SQL server for use with the text expander PhraseExpress v16.

---

Closed Caption:

in this video we will show you how to
use phrase express with an sql server
we are now at the central server
computer
where all workstation clients have
network access to
here install the phrase express sql
client manager
double click the installer to launch the
installation
and follow the on-screen instructions
if you don't have a microsoft sql server
forex express offers you to install the
free express edition of microsoft sql
server it's pre-configured and ready to
use
after installation of the sql client
manager the sql server installation is
launched and you need to click install
to continue now you can grab a coffee
because this takes a while
okay the installation of the server is
complete and you can also install the
sql server management studio here which
will lead to the website of microsoft
where you can download it
uh this is optional but it's a useful
tool if you need to troubleshoot the sql
server but to run the sql server with
fresh express you don't need it so we
click on close
and launch the phrase express client
manager now this is important by default
microsoft selects a dynamic port which
is not recommended if you use it with
phrase express so our client manager
offers you to fix this settings
click on yes but of course if you have
an existing ski server you would need to
check with your it administration
whether you don't break anything okay
after fixing it and restarting the sql
server you're good to go we can double
check if you click on database if you
see green text here everything is fine
now that's important we now keep the
client manager running in the background
on the server computer making it easy
for other clients on the workstation to
find the sql server without any
additional configuration so keep this
program running we will now switch to a
workstation client to install phrase
express there
okay we are now on a workstation
computer and install the regular phrase
express client
make sure to keep the microsoft sql
server support activated we also
recommend to configure the firewall so
you will have a flawless experience and
that the client automatically connects
to the sql server
okay after installation you will find
the program icon in the lower right of
the windows task tray if you don't see
it
click this rectangle
and drag the phrase express icon onto
the test tray for quick access now we
open the program window
and after a short while it will
automatically connect to the sql
database
and it will be mounted to the phrase
tree on the left now you can drag and
drop your own phrases from the local
phrase file to the sql database node
just select the desired folders
and keep pressing the ctrl key to select
multiple folders then drag it to the sql
database node without the control key
you move the phrases so they will be
removed from your local phrase file and
if you keep pressing the control key you
see a little plus symbol and the phrases
will be copied we recommend to copy so
you haven't backup in your local phrase
file the phrases have been copied or for
bigger databases this may take a while
and now you don't need the local phrase
5 node anymore so select it
right click and select unload
it won't delete the phrase file but just
unload it from frys express because now
you are using the sql database by the
way if the client should not
automatically connect you can initiate
this manually by click on file
open
connect to sql database
then enter the sql server information
which you can find in the client manager
or use the configuration file which you
can load from here we switch back to the
server we now switch back to the server
computer to show you how to create such
configuration file
in the sql client manager go to
databases
and here you can find the connection
info
and this can be stored in a client
configuration file
we created on the desktop
and this is the file you would load on
the clients if you already have license
keys
switch to license keys
paste your set of license key into the
input box and press update
in the monitor you will find a list of
all connected clients the w checkbox
indicates whether the user has general
write access right to the phrases
c can restrict access to the program
settings if unchecked you are user
phrase file folders which creates a
personal user folder on each client
let's do this
we switch back to the client computer
and if we restart the client
every user will have a personal folder
which is indicated with the smiley icon
and the individual user
so users can store their own phrases
in this folder
it will become invisible for all other
users
this is independent from the regular
access right system so you can select
any folder and define read and write
access right separately
as shown here
additional information on how to use
phrase express with the sql server can
be found in the documentation that way
you will also find the troubleshooting
section if you run into any connection
problem
[Music]
you