is a tool that serves for simple administration of databases (at present only MS SQL Server
and MS SQL Server Compact - description, Installation and management
). It is adjusted first of all to the administration connected with PROMOTIC system needs to these databases.
The tool uses the graphic HTML interface and the ADO interface, the technology from Microsoft, is used for accessing databases.
application is located by default in the \Promotic\Tools\PmDbAdmin
First start of PmDbAdmin tool
The first usage of the tool assumes that one version of the SQL database server was installed - see MSSQL.Install
and that this server is local
or accessible in LAN network
. Further, it is advisable to register the usage of the ADO
technology in the Windows
registry editor. By this, the security notifications that warn users about using ADO
, are disabled. The registration is done by the confirmation in the window called by the 'Registration ActiveX ADO
' link on the opening page. On the opening page there is also preset the login window by default that assumes the location of the database server to the local computer (otherwise the name of the database server in the network), the user name is sa
(system administrator) and the user password is blank. The connection is done by the Connect to the server
button or by the Enter
After connection on the "Information"
tab, the information whether the server is configured by PROMOTIC system, is marked.
In the administration mode sa there is then the possibility to make or remove this configuration.
These actions have nearly the same function as the configuration operations described in MSSQL.Install. The only difference is the possibility to change preset passwords for created user accounts.