--- title: "Multiply Windows Server and CUE Solution administrators" canonical: "https://docs.cuesystem.com/space/Dep/1097072641/Multiply%20Windows%20Server%20and%20CUE%20Solution%20administrators" format: markdown --- > ℹ️ **This chapter covers the administration of the Windows Server on which CUE Solution is installed and CUE Solution deployment /updates.** > ℹ️ > ℹ️ It does not cover the actual administration of CUE Solution using the CUE Admin front end. To install and update the CUE Solution, the administrator logged on to Windows Server must have the highest administrative rights. If you are using MS SQL Express installed on this Windows Server (which is the default configuration), all administrators who will maintain the CUE Solution must also have administrative privileges for MS SQL Express. **Just because a administrator has highest administrative rights on Windows Server does not mean that he also has admin rights on MS SQL Express. **Therefore, if multiple administrators manage the CUE Solution, you must ensure that all of them also have administrative rights for MS SQL Express. > ℹ️ If you are using an external MS SQL Server, we assume that you control the user rights on this server yourself and the procedure described here does not apply to you. During the initial installation of the CUE Solution, MS SQL Express is also installed and **administrator rights for MS SQL Express are set for the Windows Server administrator who is logged on to the server and runs the initial installation**. Therefore, **other Windows Server administrators do not have administrative access to MS SQL Server** and during some updates, when for example another database needs to be added, this update may fail. **If you have multiple administrators, you must manually assign them administrative rights for MS SQL Express according to the following procedure.** ### Add Windows Server administrators If you don't already have it, create users for all required administrators on Windows Server and assign them administrative rights. ![image-20240425-080832.png](media://52d2a0a7-2b26-4ba6-84d7-3fa88ba9e1fa) ![image-20240425-081135.png](media://1666dc14-d321-4ba8-9d7e-4078fcaa35f7) ### Download and install SQL Server Management Studio Download and install the latest release of SQL Server Management Studio (SSMS) on the server. Follow the instructions here: [https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16](https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16) ![image-20240425-082059.png](media://f9cd0067-8c5b-45e9-8ff6-85e9d57df085) ### Sign in to the server under the administrator who did the initial installation of CUE Solution > ⚠️ The following operations must be performed by a user who already has administrative rights to MS SQL Express. That is, **sign in to Windows Server under the administrator who did the initial installation of the CUE Solution**. The sample screenshots show: - ***Administrator ***- did the initial installation - ***Admin.Adam*** - another administrator, for whom we will create administrative rights for MS SQL Express So in our example, you need to sign in to Windows Server as ***Administrator***. ### Run SQL Server Management Studio (SSMS) It is a standard program in the **Start **menu, **Microsoft SQL Server Tools** group. After the start, the **Connect to Server** window appears. ![image-20240425-083024.png](media://2448ebc0-323f-44ad-805d-e6b3c6280389) - In the **Server name** field **the name of the MS SQL Express instance on this server** should be filled in. - In the **Authentication **field, select **Windows authentication**. - Check **Trust server certificate**. - Tap **Connect**. ### Add new administrator - In **Object Explorer / Security / Logins** right click on **Logins **and then select New Login… ![image-20240425-091217.png](media://f6998747-a07e-4b67-8a06-e6f0813bee5f) - On the **General **page select **Windows authentication** and tap **Search…** ![image-20240425-095735.png](media://b3f43021-0097-4afc-bbb9-eb07ed7b17bd) - Type the name of the new MS SQL Express administrator in the appropriate field (**admin.adam** in our example), and then click **Check Names**. This will check the name and if needed automatically add the server name or domain. Then tap **OK **button. ![image-20240425-093810.png](media://4bfb8543-c6bf-4ebe-b8b3-8000cdb3a14e) - On the page **Server Roles** check the role **sysadmin **and confirm the creation of the new user with the **OK **button. This will finish the creation of the new MS SQL Express administrator and you can exit SSMS. ![image-20240425-100058.png](media://8007b9b6-4860-4461-b1ad-622769525a97) ### Test the new MS SQL Express administrator account At this point, it is recommended to test if the rights of the new admin are OK. - Sign out of Windows Server and log in as a newly created administrator (**admin.adam** in our example). - Run SSMS and **Connect to the Server** with **Windows Authentication**. - In **Object Explorer / Databases** right click on **Databases** and then select New Database… ![image-20240425-102334.png](media://88c65cfd-2685-48e8-890b-2f5b868319a7) - In the **Database name** field, type any name (**Test **in our example). The name of an existing database can not be used. Confirm the creation of the database with the **OK **button. ![image-20240425-103411.png](media://a5c0dbaa-84af-4d29-87dd-868bdec1187c) - If the database was created correctly, the rights of the new administrator are also correct. You can now delete the test database you just created by right-click over the test database and clicking **Delete**. ![image-20240425-104108.png](media://34b4a218-9d7c-4317-8b67-b366def423aa) - This completes the test and you can exit SSMS.