Log In
Register
Topic RSS
15:49, EET
January 24, 2020
Offline
I just installed the OPC UA Historian and want to connect to an existing database in a Microsoft SQL instance. The MS SQL instance is reachable through network connection and does not reside on the same server as the OPC UA Historian.
When testing the connection, I get an error message.
“Could not connect: CREATE DATABASE permission denied in database ‘master’.”
And with that error message, it is not possible to proceed.
Is there any chance to configure the connection to an existing database, where the user will have CREATE DATABASE permission, but, due to company guidelines, not on the database master?
Regards,
Jochen
17:54, EET
April 3, 2012
Offline
Hi,
Generally the application needs/assumes full access and thus it is not guaranteed if it will work properly if not. So basically the answer is “No”.
You could try manually creating database named “ProsysOPCUAHistorian” to see if it works. Still the user must have permissions to run “IF NOT EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N’ProsysOPCUAHistorian’) CREATE DATABASE ProsysOPCUAHistorian”.
11:52, EET
January 24, 2020
Offline
Hi,
thank you for the answer.
A skeleton database, where OPC UA Historian should store the data already exists in the MS SQL instance, but wth a generic name.
So the OPC UA Historian database must be named “ProsysOPCUAHistorian”? Using another name for the database is not possible?
If this database with the required name exists in my Microsoft SQL instance I can proceed with the configuration?
12:51, EET
April 3, 2012
Offline
The application needs to be in full control of the database, and that is the only tested scenario. It will create and manage it’s own tables. And to clarify, it wont work with existing tables etc., it must actually be able to create them (and modify/delete them etc. everything). It uses liquibase internally to version control the database such that a future version of the application can rely and the database schema being compatible.
Currently that database name is hardcoded. Given the other requirements I’m not sure it would make that much sense for it to be configurable, but we will think that in the future.
1 Guest(s)
