October 15, 2010 at 3:12 am
I am posting here as well as on the Avast forums, and am not sure if this is the right sub-forum to be posting in. Please move it if necessary.
Basically I have never used any form of MSSQL and have some experience with PHPMyAdmin (doubt that counts for much though right? :-D)
So the situation is that I am trying to integrate Avast ADNM on a server pre-configured with MS SQL 2k5 and it wants all the server details. Rather than adding a new database in a current instance (is this the right word?) i would like to create a new instance for Avast and then create the required database in there.
Am I on the right track here? As far as I can tell I will need to run the SQL install disc and select to add a new instance, is this correct?
To sum it up this is what I think I understand about the situation,
With MSSQL 2k5 installed one can have up to 15 instances which are basically each standalone servers under which databases can be created. I want to create a new one for this specific program rather than mess with any of the existing ones which belong to other programs. In order to do so I will need the discs and run a new install and add on the new instance in that.
Thanks in advance for any support you can give me.
Cheers
Tarn
October 18, 2010 at 5:09 am
I know nothing about Avast, but if you want a separate named instance on your server for the Avast DB, that's perfectly okay.
Yes, you need the install disks or .msi file (if your company does it that way).
I assume you're using Workgroup edition? 16 is the maximum instances for Workgroup, 50 if you're using any other edition. Those numbers include the default instance. EDIT: I should note that the "50" goes down to 25 if you're using a failover cluster.
Your biggest problem, though, isn't how many instances you can install on the server. It's making sure the hardware can support all the instances you're trying to squeeze on it. Go to Microsoft's website or read Books Online for more details on the necessary hardware components for SQL Server 2005. It doesn't even matter if you're adding an extra database to an existing instance or creating a new instance for the database. The hardware will still need to be checked to make sure it can handle the additional load.
Does this help?
October 18, 2010 at 5:21 am
Thank you Brandie! That is all I needed to hear. 🙂 I am pretty sure the server should manage the extra load but probably only just. This is OK however as the client is thinking of upgrading their server anyway.
October 18, 2010 at 5:50 am
Glad I could help. Please let us know if you have any additional questions.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply