Error Creating Data...
 
Notifications
Clear all

Error Creating Database

5 Posts
3 Users
0 Reactions
1,601 Views
Posts: 12
Topic starter
(@haseeb)
Active Member
Joined: 8 years ago

When ever i try to create the database this error shows up.

What are the causes for this error. How can i solve it?

4 Replies
Posts: 12
Topic starter
(@haseeb)
Active Member
Joined: 8 years ago

I also i installed MySQL Server as well. But i don't see it. How can i configure that and use phpmyadmin to manage MySql Database?

Reply
Posts: 1995
Admin
(@m-tiggelaar)
Noble Member
Joined: 9 years ago

Hello,

For MSSQL : Make sure it's properly configured in the mssql service (i would avoid trusted connections but using actual SQL login with sysadmin permissions).

mysql: once added and configured enable it at the hosting plan to allow users to create things.

Regards,

Marco

Reply
Posts: 27
(@newtothis)
Eminent Member
Joined: 7 years ago

Hi

I am having the same problem.
I have SQL server 2016 web, I have MSSQL service enabled, I created an SQL security login user and gave it a password and sysadmin rights, then confirgured the service settings in SolidCP to use SQL and then entered the username and password for that login, but I still get the same error as above. I originally checked the Error log in SQL Management to see that the Trusted connection was getting a user not recognised error, hence why I created the new login. The log is now showing no, but I am still getting the error above.

Once I can get the service to connect, will the space name prefix start to show for the database name, or is that another thing on my list to work out?

Reply
Posts: 1995
Admin
(@m-tiggelaar)
Noble Member
Joined: 9 years ago

Did you have the browser service enabled for MSSQL? (if not it will only respond to localhost connections).

You can configure the database prefix/ suffix under the policies pages in the serveradmin home --> bottom right --> Policies

Reply
Share: