|
Home > Archive > MS SQL Server > October 2006 > How to name different database instances?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How to name different database instances?
|
|
| Keithb 2006-10-24, 6:37 pm |
| I now have an instance of sql server 2005 installed on my development box.
That instance uses the machine name and there seems to be no other reference
to an instance name. Now, I need to also install an instance of sql server
2000 on the same box. How can I give the 2000 instance a unique name? Also,
can I manage both of the these database using sql server 2005 management
studio, or do I need to install Enterprise manager for the 2000 instance?
Thanks,
Keith
| |
| Brett I. Holcomb 2006-10-24, 6:37 pm |
| When you install SQL 2005 again you'll have an opportunity to create and
name a new instance.
As for what to manage with I'll leave that to someone who knows <G>.
Keithb wrote:
> I now have an instance of sql server 2005 installed on my development box.
> That instance uses the machine name and there seems to be no other
> reference to an instance name. Now, I need to also install an instance of
> sql server 2000 on the same box. How can I give the 2000 instance a unique
> name? Also, can I manage both of the these database using sql server 2005
> management studio, or do I need to install Enterprise manager for the 2000
> instance?
>
> Thanks,
>
> Keith
--
Brett I. Holcomb
brettholcomb@R777bel
lsouth.net
Remove R777 to email
| |
| Arnie Rowland 2006-10-24, 6:37 pm |
| Install SQL 2000 from the CD. It will ask you for an Instance Name. Choose
something that makes sense. (If you choose MyInstance for the instance name,
then for applications, the server instance name will be
MachineName\MyInstan
ce -making it unique.)
You can fully manage the SQL 2000 instance from SQL 2005 Management Studio.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Keithb" <noreply@dslextreme.com> wrote in message
news:OmsJg4l7GHA.1188@TK2MSFTNGP05.phx.gbl...
>I now have an instance of sql server 2005 installed on my development box.
>That instance uses the machine name and there seems to be no other
>reference to an instance name. Now, I need to also install an instance of
>sql server 2000 on the same box. How can I give the 2000 instance a unique
>name? Also, can I manage both of the these database using sql server 2005
>management studio, or do I need to install Enterprise manager for the 2000
>instance?
>
> Thanks,
>
> Keith
>
|
|
|
|
|