Error: Failed to connect to server (LocalDB)\GBSQL2019

There are many reasons that we may get the error message about connections to the listed server.  While the most generic of this is the below message, you could get a message at any point with Geobank For Field Teams about the database or instance not being accessible.

We firstly would need to check that all permissions are set as per this knowledge base article.  Most times, this will resolve the error as it is generally permissions based.

Once we have confirmed that the appropriate permissions are assigned and we still get this error message, we can use the sqllocaldb commands in Command Prompt to restart the Geobank For Field Teams server.

To start, firstly close any open instance of Geobank for Field teams.  Then click the start button or press the windows key.  Then type command until you get the following

Press enter to open the command prompt.  Please note, users with restricted access may not have access to the following and may need to run the command prompt as an administrator.  You may need to engage your IT team to assist with this.

The first command you will run is 

sqllocaldb i

This will give you a list of local databases installed on the specific machine.

If you get an error that the sqllocaldb application cannot be found, you will need to reinstall Geobank For Field Teams or install the SQL Server 2019 Local Server separately.  This would indicate that the underlying database is not installed.

If you do not find the database in the list, you can attempt to create the database using the following command

sqllocaldb c GBSQL2019 -s

This will create a blank server with the correct name and start the instance.  If you do run this command, you can then open Geobank for Field Teams and import / create your profile.

If you do see that GBSQL2019 server in already in the list, you can then try

sqllocaldb s GBSQL2019

You should see the below message when this is successful.  At this point, try opening the Geobank For Field teams application again and if it does not open, you may need to reinstall the Geobank For Field Teams application.

If the above does not assist, please contact the support team for further guidance.

Want to learn more?

Online Help Manuals - Click here for the latest version

Learning Management System - Click here to login or here to request access