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

(Nur auf Amerikanisches Englisch verfügbar) Der Inhalt wird unten in einer verfügbaren Sprache angezeigt. Klicken Sie auf den Link, um die aktuelle Sprache zu ändern.

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

Herunterladen

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

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)

Your Email (required)

Subject (required)

Your Message (required)

Subscribe to our Newsletter

WP User Control Widget

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