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“:

error-db-2

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:

post-1

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

server name and choose propert

and then

error-db-3

 

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.

 

 

 

 

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

Download Area

Tabbles 4.1.7

(~ 9MB) Compatible with: Vista, 7, 8, 8.1, 10. For LAN mode, it requires Sql Server Express 2008 or above, or LocalDB

Write us!

Do you have questions about Tabbles, or just want to say hi? Drop us a line and we'll get back to you:

Your Name (required)

Please leave this field empty.

Your Email (required)

Please leave this field empty.

Your Message (required)

Please leave this field empty.

Type the 4 characters below and press Send
captcha

Please leave this field empty.

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.

Close