Recently, we have made a change to our Hosted Database services to only allow the primary database user for any given database to view the database via SQL Server Management Studio. This change was made with the privacy and security of our customers as our primary concern.
When a Hosted Database and associated user are created, the initial user will be able to log into the database via SQL Server Management Studio, and view the details of the database, including tables, stored procedures, and other details.
Any subsequent users which are created will have the ability to log into Management Studio, however they will not be able to directly view the database details. However, the user will still be able to run SQL queries against the database from Management Studio, and also connect via a website connection string.
If you have any questions regarding this policy, please don’t hesitate to contact our Technical Support department for further information and assistance.