Portal Home > Knowledgebase > Articles Database > MSSQL Server and Guest Access -Shared hosting server

MSSQL Server and Guest Access -Shared hosting server

Posted by SAHostKing, 02-09-2015, 12:52 PM

Hi, Currently we have a SQL Shared Hosting server with 2012 on. Now if we add 10 databases to different accounts. Then we connect via SQL Management studio we can only access that database that it is assigned to but we can see all others on the shared server? Any way to hide all other client databases and have the client only view there own. Is this due to the guest user being there?

---

Posted by Tolis, 02-09-2015, 12:58 PM

Connect with SQL studio and click on "security"- (left tab) and add users, assign passwords and database

---

Posted by iserversupport, 02-09-2015, 02:01 PM

Setup separate mysqluser for each database

---

Add to Favourites    Print this Article

the planet down? (Views: 832)

How to install this on a dedicated server? (Views: 763)

MaxClient setting if wrong can block out visiors? (Views: 719)

Can't send outbound from my server with Comcast (Views: 739)

TMPL_VAR (perldesk 2.2) (Views: 773)