0

May i know is there any software supporting this task ? or probably how people providing SQL server renting service ? implementing "virtual" and "private" SQL server for developer which allow them to remote access their server...

1myb
  • 3,536
  • 12
  • 53
  • 73

1 Answers1

0

You can install multiple instance of sql server on the same machine. But this venture isn't likely to work well, as it doesn't take much for a single sql server instance to peg a machine on any of cpu, ram, or disk io.

Joel Coehoorn
  • 399,467
  • 113
  • 570
  • 794
  • if and only if i install multiple instance, will it allowed customer to remote control without bother other server ?? – 1myb Jan 19 '11 at 16:54
  • @Spencer No, they won't be allowed to RDP in. They will be able to connect via Management Studio and do anything you want from there. If you want to allow them to RDP, you should look at VMWare. Your licensing costs are _much_ better going the instance route. – Joel Coehoorn Jan 19 '11 at 17:22
  • Thx for reply, dude... if i want them to access via management studio, how could i make it up and act like shared hosting but not hosting website is hosting sql server only... this action formally what it called that i can found inside sql books ? Thx for reply =D – 1myb Jan 20 '11 at 08:24