Skip to main content
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

MS SQL database created using Plesk - Database User is just login only. No Permission

Hello

 

Created new MS-SQL database name="xxxxx" using Plesk.

Created new database user name="yyyyy" for it.

 

Now access db using mssql.<your domainname>.

Login with "yyyyy" successful.

but I can no longer create tables or do any kind of modifications of permissions.All buttons are disabled.

Tried sqlcmd  but still it says "No permission to yyyyy"

 

I am stuck. please help.

It is expected that database I purchased, my login user should have full permission on it.

 

Thanks and Best Regards

Sachin Erande

+91-7709862546

 

 

 

 

 

 

1 REPLY 1
MPC
Community Team
Community Team

You'll need to connect to the database remotely if you want to edit it outside of your hosting control center.  Please use these instructions to locate the proper settings to use: https://au.godaddy.com/help/connect-remotely-to-databases-16107

 

MPC