What to do if you get “Error connecting to database” when creating a user

Hi all, this is a frequently asked question.

Sometimes, when trying to set up Tabbles Lan, the “create database” button succeeds, but then you try the “create user” button and you get “Error connecting to database“:


In this case, the reason is almost certainly that you did not enable Sql Authentication in your Sql Server installation. (Windows authentication only allows you to create the database, but then, to create the user and login, you need Sql Authentication. )

Here is how to enable Sql Authentication with Sql Server Management Studio:

Connect to the server as admin:


Right click in the server node and choose “properties”:

server name and choose propert

and then



Press OK.

Restart the server with Sql Server Configuration Manager.

Now the “create user” button should work.

To repeat, this howto is only useful if the “create database” button works, but the “create user” does not. Elsewhere we will deal with the case where the “create database” button does not work.




By | 2017-11-17T21:10:50+00:00 June 23rd, 2015|howto, Support|0 Comments

About the Author:

Leave A Comment

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.