The e-magazine for KNX home & building control

Dr KNX: Difficulties with Installing the SQL Server

Dr KNX1By Dr KNX.

Dear Dr KNX, I am experiencing difficulty in installing the SQL server within the ETS setup. I get the message 'A database server was not found'. Can you help?
Dear Dr KNX, I am experiencing difficulty in installing the SQL server within the ETS setup. I get the message ‘A database server was not found’. Can you help?

Dear KNXer,

A lot of problems are due to the Microsoft SQL Server installation, so please be aware that these are not necessarily ETS issues as ETS only uses this Microsoft product.

Let’s start by making sure you have the following:

1) A stable Windows platform.
2) The latest version of ETS installed. This can be checked via the diagnostic wizard.
3) The latest master data installed (this can be checked under ‘Settings’).

ETS requires Microsoft SQL Server 2008 R2.

The usual troublemaker is the EXPRESS edition, which in some cases really is a burden to remove. This can be checked via the Control Panel under Add/Remove programs.

Make sure that the pre-installed SQL Server version (or versions) is (are) uninstalled. Once this is done, re-install the latest ETS version.

You may also find that the SQL server is installed but will not start, giving you the same error of ‘A database server was not found’.

In this case, manually restart the ETS database engine by clicking:
– Start.
– All Programs.
– Microsoft SQL Server 2008 R2.
– Configuration Tools.
– SQL Server Configuration Manager.
– SQL Server Services.

Note: you might also need to set the Start Mode to ‘Manual’.

I hope that helps!

Yours truly
Dr KNX

If you have a question that you would like to be considered, please send an email to me, Dr KNX, via info@knxtoday.com. Simple or tricky, try me!

Share on facebook
Share
Share on twitter
Tweet
Share on linkedin
Share

SPONSORS

Schneider's new KNX Push Button with dynamic labeling


Schneider's new KNX Push Button with dynamic labeling
Schneider Electric’s new KNX Push Button has an attractive display that enables digital labeling with text and symbols. System ...

How KNX Smart Home reduces energy consumption and increases comfort


How KNX Smart Home reduces energy consumption and increases comfort
The Dutch housing company Woonborg is building 36 flats based on the strict NOM (Zero-on-the-Meter) standard. To ...

Update of JUNG Actuators


Update of JUNG Actuators
The JUNG KNX switching and blind actuators have received a firmware update, which brings new features and simplified initial commissioning ...

AVE’s KNX Room Controller


AVE’s KNX Room Controller
Ideal for home and hotel, AVE Room Controller is a high-design solution with OLED display and touch controls, which ...