Adding the existing SQL to the MaestroPanel You will need to do the following to give the MaestroPanel control of the SQL Server you will use in the different versions you have just installed or have already installed.
Running SQL Mixed Mode
SQL Management Studio
Finish and restart SQL Service.
T-SQL
It can also be activated by running the following query.
Folder Permissions
Give the read / write permissions by adding the index of the sql database that the user belonging to the service that SQL Server uses.
We learned the service user. Then create a folder in the C: \ Program Files \ MaestroPanel \ Data folder to create the SQL database.
We created a folder called MSSQL2014DATA. The corresponding file path was C: \ Program Files \ MaestroPanel \ Data \ MSSQL2014DATA. Do not forget this.
Then add the SQL Service user that we learned this folder, make the permissions according to the following view and complete.
MaestroPanel Configuration
Module Setup
From there, download the SQL Module to the server and complete the installation. Remember to enter the SA password correctly during the installation steps. The name of the module is 2012 but it supports 2008/2012/2014/2016 versions.
SQL Server Configuration Manager Configuration
SSCM> SQL Server Network Configuration> Protocols for (SQLInstance)>
Enable TCP / IP and open the properties. Make the TCP Port value 1433 in the IPAII field in the IP Addresses tab. After you finish, restart SQL Service.
Running SQL Mixed Mode
SQL Management Studio
Finish and restart SQL Service.
T-SQL
It can also be activated by running the following query.
Folder Permissions
Give the read / write permissions by adding the index of the sql database that the user belonging to the service that SQL Server uses.
We learned the service user. Then create a folder in the C: \ Program Files \ MaestroPanel \ Data folder to create the SQL database.
We created a folder called MSSQL2014DATA. The corresponding file path was C: \ Program Files \ MaestroPanel \ Data \ MSSQL2014DATA. Do not forget this.
Then add the SQL Service user that we learned this folder, make the permissions according to the following view and complete.
MaestroPanel Configuration
Module Setup
From there, download the SQL Module to the server and complete the installation. Remember to enter the SA password correctly during the installation steps. The name of the module is 2012 but it supports 2008/2012/2014/2016 versions.
SQL Server Configuration Manager Configuration
SSCM> SQL Server Network Configuration> Protocols for (SQLInstance)>
Enable TCP / IP and open the properties. Make the TCP Port value 1433 in the IPAII field in the IP Addresses tab. After you finish, restart SQL Service.
0 yorum:
Yorum Gönder