multiple server question

Question

multiple server question

chen kirsch

SSC-Addicted

Points: 431
More actions
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

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

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

Mike Metcalf SSCrazy Eights Points: 8763 More actions · Answer 1

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.

chen kirsch SSC-Addicted Points: 431 More actions · Answer 2

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

DCPeterson SSCoach Points: 15266 More actions · Answer 3

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

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

chen kirsch SSC-Addicted Points: 431 More actions · Answer 4

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

DCPeterson SSCoach Points: 15266 More actions · Answer 5

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

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

chen kirsch SSC-Addicted Points: 431 More actions · Answer 6

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