![]() MS SQL Server or MS SQL Server Express configurationIn order to enable the installed MS SQL Server or MS SQL Server Express from PROMOTIC application, it is necessary to complete the basic configuration (create the databases and users with preconfigured access rights). ![]() It can be done by using the installed MS SQL Server Management Studio Express client tools or by predefined command files. ![]() Using the command file is based on editation (it is edited only if the server name, user name or password is different from the values contained in the file) followed by executing the command file MsSQLInit.bat in the \Promotic\Tools\MsSQL folder.ĭuring the configuration two new database 'pm_data' is created for user data accessible by the PmaAdo, PmaDatabase objects for storing trends by the PmaTrendGroup object, for storing alarms by the PmaAlarmGroup object and for storing events by the PmaEventGroup object. Also the ODBC source 'pm_data' is registered for access over the ODBC into the 'pm_data' database.Īdditional 3 user accounts are created, where the 'pm_admin' has admin rights, the 'pm_writer' has the rights for read and write and is able to create, delete and modify the table structure and the 'pm_reader' has the access right to tables read only. Text console for MS SQL Server administrationFor the administration of the MS SQL Server (Express) the text console can be used with the command line ( OSQL.EXE or ISQL.EXE respectively). Starting the console for the default installed MS SQL Server and logging in the 'pm_admin' user: "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\OSQL.EXE" /? The list of possible parameters is displayed by the console after entering the parameter '/?': On starting the console, parameters for the connection to the appropriate MS SQL Server can be entered.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |