Database cannot be opened! (SQL Authentication Error)
When opening zenon, one may encounter the following message in the output window:
Taking a glimpse at the logs reveals that there are authentication errors regarding zenon's default database user "zenOnSrv". Therefore, no projects can be opened.
There are two possibilities for this scenario:
Taking a glimpse at the logs reveals that there are authentication errors regarding zenon's default database user "zenOnSrv". Therefore, no projects can be opened.
There are two possibilities for this scenario:
1. The user credentials entered in the zenon startup tool do not match the SQL credentials of the user in the database
2. The default user 'zenOnSrv' is missing in the database.
To check either, install Microsoft SQL Server Management Studio (SSMS). The setup can be found within the zenon .ISO under /AdditionalSoftware/Microsoft SQL Server Management Studio
Run the setup. Once it's complete, start SSMS.
A dialog window will come up asking you to connect to a server.
By default, zenon 14 uses the database server "ZENON_2022" due to a recent switch to SQL 2022.
To check either, install Microsoft SQL Server Management Studio (SSMS). The setup can be found within the zenon .ISO under /AdditionalSoftware/Microsoft SQL Server Management Studio
Run the setup. Once it's complete, start SSMS.
A dialog window will come up asking you to connect to a server.
By default, zenon 14 uses the database server "ZENON_2022" due to a recent switch to SQL 2022.
The previous versions (10, 11, 12) use SQL 2019, and therefore, use the database server "ZENON_2019".
Use Windows Authentication as your authentication method. This way you will log in using your Windows User credentials.
Click Connect to continue.
You can also select your database server via the dropdown menu. If the server for your zenon version is not listed, enter it via the following syntax:
HOSTNAME\DATABASE_NAME (e.g.: MYPC\ZENON_2022)
To get the hostname of your machine, open CMD and type in "hostname".
Once you're logged in, navigate to the Object Explorer on the left side of your screen.
The Object Explorer displays directories, database instances and users stored on the database server.
Navigate to the following directory Security > Logins:
A list of every user instance stored will be displayed. Look for the zenon default user "zenOnSrv".
From here on out, there are two possible causes:
Cause 1: Wrong credentials
If there is an instance to be found, either double-click on the instance or right-click on the user and select Properties to edit it.
Enter a new password and click OK to apply the changes made to the user.
Open the zenon Startup Tool. Select Profile > Edit Profile... to make changes to your zenon profile.
Please make sure to register the zenon version where this scenario occurs first. If you have multiple versions of zenon installed and do not register the correct version beforehand, you may edit the credentials for a different database server and lock yourself out!
Select the Tab Database. Enter the new password you had previously given to the SQL server. Click OK to apply changes.
Cause 2: User instance "zenOnSrv" is missing
If the user is missing, we can create a new one in SSMS.
NOTE: If a zenOnSrv user instance is present, you can also use this procedure to check if the instance has all of the following attributes in place.
Right-click to bring up the context menu and select "New Login...".
Use Windows Authentication as your authentication method. This way you will log in using your Windows User credentials.
Click Connect to continue.
You can also select your database server via the dropdown menu. If the server for your zenon version is not listed, enter it via the following syntax:
HOSTNAME\DATABASE_NAME (e.g.: MYPC\ZENON_2022)
To get the hostname of your machine, open CMD and type in "hostname".
Once you're logged in, navigate to the Object Explorer on the left side of your screen.
The Object Explorer displays directories, database instances and users stored on the database server.
Navigate to the following directory Security > Logins:
From here on out, there are two possible causes:
Cause 1: Wrong credentials
If there is an instance to be found, either double-click on the instance or right-click on the user and select Properties to edit it.
Enter a new password and click OK to apply the changes made to the user.
Open the zenon Startup Tool. Select Profile > Edit Profile... to make changes to your zenon profile.
Please make sure to register the zenon version where this scenario occurs first. If you have multiple versions of zenon installed and do not register the correct version beforehand, you may edit the credentials for a different database server and lock yourself out!
Select the Tab Database. Enter the new password you had previously given to the SQL server. Click OK to apply changes.
Cause 2: User instance "zenOnSrv" is missing
If the user is missing, we can create a new one in SSMS.
NOTE: If a zenOnSrv user instance is present, you can also use this procedure to check if the instance has all of the following attributes in place.
Right-click to bring up the context menu and select "New Login...".
Enter a new username and password. In our case, we will name the instance "zenOnSrv". You can also give the user a different name, but make sure that the credentials match.
Also, make sure that "master" is set as the default database and English as the default language.
Move one page down to Server Roles.
Select the following roles:
Here you'll find databases you can map your user to.
Your user must be mapped to "master", "model" and "tempdb".
For each database, the following role memberships must be selected "db_owner" and "public".
Heading one page further down to the Securables, your database server must be available as an object instance.
Add an instance by clicking on Search...
A dialog window will come up, asking you to select an object. Select your database server and click OK.
Now that your server has been added as an instance, scroll down to the permissions.
The permission Connect SQL must be granted to your user, with the Grantor being "sa".
On the final page, select both Grant and Enabled to allow your user to connect and login into the Database.
With our user now being created and all set up, head into the Startup Tool, referring back to the first possible cause, and select Profile > Edit Profile... to make changes to your zenon profile.
Select the tab Database and enter your new user credentials.
zenon should now be able to open the database again and load in your projects.
Related Articles
Sporadic Runtime crash when exporting CEL to SQL database
Description In zenon 8.20, the Service Engine can sporadically crash when exporting the CEL to an SQL database. This error has been fixed. To benefit from this fix: Update your zenon Software Platform to the latest build of zenon 8,20 or higher. Item ...FAQ: What SQL server interfaces are offered by zenon?
The most common ones are: The zenon Historian The Extended Trend The zenon Report Generator The zenon Report Engine The zenon SQL export functions The zenon SQL Driver and The zenon Process Gateway SQL module All these modules depend on an ODBC / ...Sporadic Runtime crash when exporting CEL to SQL database
Summary Sporadic Runtime crash when exporting CEL to SQL database Description Sporadic Runtime crash when exporting CEL to SQL database Issue Number: 228666 Fixed on Date: 1.10.2020 Versions: 8.10 0 BUILD 69252 | 8.20 0 BUILD 69240 | 8.00 0 BUILD ...Restore missing project database instance via attaching an .MDF file or System Information Collector (SIC)
One may encounter this scenario, where a project instance is absent from the database and cannot be opened in the Engineering Studio. This may happen if, for example, you uninstall zenon and did not create a project backup. NOTE: It is highly ...Extended Trend doesn't show curves if aggregation data are evaluated in SQL database.
Summary In Extended Trens screen switch function are not show aggregation curves MIN, MAX and MW from SQL database after evaluation. DescriptionIn Extended Trens screen switch function are not show aggregation curves MIN, MAX and MW from SQL database ...