jwcolby
jwcolby at colbyconsulting.com
Wed Oct 24 10:21:13 CDT 2012
Robert, I have databases that I am managing on my own servers using Hamachi. I would like to get rid of this and do it out on the internet. What I need to know from you is how do you manage more than one database? Using Hamachi I hit an IP address which is literally a number, with that ,1433 at the end. On my server I have multiple databases, each of which have users set up by me, with passwords etc and inside of SQL Server those users can "see" only a single database. Thus if I come in as UserXYZ I can get at DatabaseXYZ and if I come in as UserABC I can only get at DatabaseABC. I assume that If I go with this company the same methodology is going to work except that the IP will now be ColbyConsulting.com,1433? BTW it is possible to change that default port to another port number to help defend against probing of that port. I am not sure how much it helps. What CMS do you use for the web side of things? John W. Colby Colby Consulting Reality is what refuses to go away when you do not believe in it On 9/28/2012 1:13 PM, Robert Stewart wrote: > I use Arvixe for hosting. I can admin it through SSMS (SQL Server. > I can also access it with MS Access if I add ,1433 to the end of > the ODBC server name. > > 1433 is the normal port for SQL Server. > > While it is not free, It is only about 200 for 2 years. >