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.

 

 

 

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

About the Author:

Leave A Comment

We use technology (including cookies) to collect, use and transfer information to support this Site, including for data analytics purposes, as described in this Site's updated Privacy Policy. Your continued use of the Site signifies your acceptance of such cookies. To learn more about how to manage your cookie settings and how to exercise your rights under GDPR please see our Privacy Policy

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