I have a website hosted on GoDaddy and I need to create a database for it.
I headed to the Databases section and created a SQL Server Database, then on my local pc I tried to access the database via SQL Server Management Studio. I was able to login to the database but I cannot make any operations. I get a message saying "it does not exist or you do not have permission".
I decided to go to the Security tab, then Login and tried to change my username that I'm using to systemadmin role but received:
Cannot alter the server role 'sysadmin', because it does not exist or you do not have permission.
What could be the problem? There are no other accounts on it. The default
sa account is disabled and I can't enable it because it will prompt no permissions etc.
I don't understand it. Why does GoDaddy allow me to create a database but with no permissions or rather I cannot alter it?