• GoDaddy Community
  • Websites + Marketing | Website Builders
  • Websites + Marketing | Website Builders

    cancel
    Showing results for 
    Show  only  | Search instead for 
    Did you mean: 
    New

    How to create a MsSQL user with administration permissions

    Hi,

    I am hosting using windows plan, I created a MsSQL database and whenever I want to do any changed in a table design it refuses to save, saying:

    "saving changes not permitted".

     

    How can I overcome this? 

    How can I create login user who have admin permissions?

    How can I know the password of the "sa" admin user?

     

    Thanks for your help.

    1 REPLY 1
    Helper II

    Re: How to create a MsSQL user with administration permissions

    Please click on your "MySQL Databases" and edit the corresponding Mysql User that is been attached to the Current database that you are actually referring to and edit the Privillleges to your taste. Please be careful when doing this. You may reply back if you ever experience any problem. Thank You.

    Son Of Peace