Post reply

multiple server question

  • May 19, 2005 at 8:59 am

    #88507

    Hello all

    I have some questions i hope you could answer :

    1 Is it possible to put on the same computer multiple servers???( not instances)

    2. If it is possible how would the the computer Differentiate between servers in the registry??

    3. If it is not possibleand you could put only instances, would all instances share the same registration key?? I mean, if all instances share the registration key, then you could put any number of instances with the same key.

    Thanks in advance

    Chen

  • May 19, 2005 at 9:16 am

    #559871

    Are you talking about SQL Servers (in which case you are definately talking about instances).

    Or are you talking about vituralised servers (VMWARE, MS VIRTUAL Server, etc), in which case each is treated as a completely separate server.

  • May 22, 2005 at 1:26 am

    #560395

    i'm talking about sql servers... i have to make a registration for a program that takes the id number from the registry but i don't know how it is with  multuple servers... if you could help me, id be gratefull

    thanks in advance

    chen

     

  • May 23, 2005 at 1:47 pm

    #560585

    I'm a bit unclear on what you need, but you can install multiple versions of Windows on a single machine if you use something like Virtual Server or VM Ware.  In that case, you would have two seperate registries.

    If you install multiple instances of SQL Server on a single instance of Windows then each instance of SQL Server will have its own registry entries.

    HTH

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

  • May 24, 2005 at 2:26 am

    #560690

    thanks for the answer

    i have one last question, if you can : do you know where in the registry is the unique id number of each instance??

    chen

     

  • May 24, 2005 at 8:33 am

    #560771

    I'm not sure I know exactly what you mean, but there is a DigitalProductID in HKEY_Local_Machine\Software\Microsoft\Microsoft SQL Server\80\Registration

    I'm not positive that this is a truly unique identifier for each installed instance, however the combination of Domain and Instance Name should be.

    Of course the registry key is different for 7.0 and will be different in 2005...

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

  • May 25, 2005 at 1:19 am

    #560893

    Thanks

    i meant is there a script that can uniquely identify a server through the registry.

    1 connect to server with vb.net

    2 run script

    3 get unique identifier for server/instance based on registry

    thanks again

    chen

     

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply