cannot create Datab...
 
Notifications
Clear all

cannot create Databases and SQL Users

16 Posts
2 Users
1 Reactions
2,562 Views
Posts: 1509
Admin
(@trobinson)
Noble Member
Joined: 9 years ago

Hello,

You go to Configuration -> Servers -> SQL Server

You will then need to configure the settings such as internal and external access and the connection. You should make a SQL username with sysadmin role added to it.

Screenshot 2021 04 17 SolidCP   Servers

More details can be found at https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/join-a-role?view=sql-server-ver15#SSMSProcedure

Regards,

Trevor

Reply
Posts: 21
Topic starter
(@kzk404)
Eminent Member
Joined: 4 years ago

Sorry sir. but on my main menu there isn't configuration and Scheduled task.

Reply
Posts: 21
Topic starter
(@kzk404)
Eminent Member
Joined: 4 years ago

am i need to reinstall it one more time? to get that configuration and scheduled task on my main menu?

Reply
Posts: 21
Topic starter
(@kzk404)
Eminent Member
Joined: 4 years ago

is this the file that i need to get my configuration on main menu? http://installer.solidcp.com/Files/stable/Tools/SolidCP-Configuration-Tool.zip
i found that from this topic , is it related to my problem? https://solidcp.com/forum/question/step-by-step-configuration-guide/

Reply
Posts: 21
Topic starter
(@kzk404)
Eminent Member
Joined: 4 years ago
solidcpreport5

yes i have try to make sysadmin role users , it feels like the solidCP login account and my SQL Server is different connection. the user that i add manually is scp and admin. if i change the admin password from SQL the login to solidCP isn't affected, i must change the password from solidCP account after i login. i have tried to give 'serveradmin' sysadmin role too but it comes with error " Msg 15405........Cannot use the special principal 'serveradmin'". and i cannot login to solid CP using account 'scp' that i make manually too from SQL Server

Reply
Page 2 / 3
Share: