January 12, 2006 at 1:45 pm
Is it possible to create a second local server on my machine? If so, can anyone give me some guidance on how? I haven't been able to find anything.
January 12, 2006 at 1:52 pm
You can have multiple installations of SQL Server on a machine if you use named instances. Even in this case, a reference to 'local' would mean the local default instance. Are you looking to have multiple instances installed on one machine, or do you have a requirement that you must refer to them both as local?
January 12, 2006 at 2:03 pm
No, we have a box setup as a shared server that a few groups hit. The databases in the named instance are continually messed up as it is an experimental area and we wanted to setup a different instance with the same databases that we could establish as a stable version - not to be messed with. Make sense? For now I've just added a new db and named it differently.
January 12, 2006 at 2:28 pm
Are you saying that the databases in the named instances are continually messed up because they are in a named instance?
January 12, 2006 at 2:33 pm
No - people are just messing them up - they are in flux...
January 12, 2006 at 2:41 pm
Why not create a new instance with the same database names and use SQL Server or Windows security to control who can access the databases?
January 12, 2006 at 2:53 pm
That is exactly what I would like to do - I just can't figure out how to create a new instance...Thanks for the help by the way.
January 12, 2006 at 2:56 pm
You need to install a new instance from your SQL Server installation disks. During the installation, you will have the option of naming your instance.
January 12, 2006 at 2:59 pm
Okay, very good, I thought I could do it that way, but hoped there was another. Thanks so much for the help.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply