Adding 2nd instance of SQL

I am adding a 2nd instance of SQL on a SQL SP4 box. Can someone please
clarify a few things for me?
1. Can this be done during productions hours - does it requre a reboot?
2. Does it actually install another full version of SQL - I only have a CD
that has SQL 2000 on it so I would have to apply the SP 4 after the fact -
will this affect the production instance default instance)
3. Does it use a different service account to start?
4. Can it use a second bound IP address?
Any other tips I should be aware of? Thanks for your time.Hi
"Bad Beagle" wrote:

> I am adding a 2nd instance of SQL on a SQL SP4 box. Can someone please
> clarify a few things for me?
> 1. Can this be done during productions hours - does it requre a reboot?
It should not require a re-boot, but it would not be a good idea to do it on
a production server whilst it is being used.

> 2. Does it actually install another full version of SQL - I only have a C
D
> that has SQL 2000 on it so I would have to apply the SP 4 after the fact -
> will this affect the production instance default instance)
Yes you would need to apply a service pack separately.

> 3. Does it use a different service account to start?
This is however you configure it, the can be the same if required.

> 4. Can it use a second bound IP address?
You could do this via a firewall and filter on tcp/ip ports or possibly by
using the TCP/IP filtering in the advanced options of the network connection.">
> Any other tips I should be aware of? Thanks for your time.
>
>
Having a second instance will use resources on this machine, you should not
(really) have a second instance on a production server if you can avoid it,
and certainly test/development instances should be kept separate.
John|||Hello,
Thank you for posting. Also, thanks very much to John for his contribution.
It seems that John has essentially answered all the questions appropriately.
You can install the instance without re-booting the system. Application of
SP4 does require a reboot. I would also recommend that, regardless, you do
reboot the system simply to refresh services and what not. You can
install the instance followed by SP4 then reboot.
My understanding is that the root of this question is "Can you do the
installation on a production server while it is being used?" While it
should work without issue, there are a number of reasons not to attempt
this. First, if something does go wrong, you may unexpectedly bring down
your production server while people are using it, thus potentially losing
data and incurring user and executive wrath: something we all generally
want to avoid. Secondly, and particularly with SP updates, installations
have been known to fail silently and return a successful message without
properly updating services. It's very much recommended to do any such type
of major administration while the database is not being accessed.
You can configure the service account either during the installation of the
SQL Server, or you can update it later through SQL Enterprise manager. As
John mentioned, you can set it to a different account or the same account
depending on your requirements.
You can bind each instance that you install to a separate port, but you can
not specify an IP address for each instance. Instead, the port for the
TCP/IP network protocal is dynamically configured during installation. As
John suggests you can manage this using NAT at your Router/Firewall. To
check/change the port for the instance, you can open SQL Enterprise Manger,
Right click the instance you want to change, select Properties > Network
Configuration... > TCP/IP > Properties...
John also brings up a very good point about the performance implications of
running an extra instance on a production server. Basically, when you add
an instance, all the following are replicated, taking up additional
resources:

> SQL Server database engine
> System and user databases.
> The SQL Server and SQL Server Agent services.
> The registry keys associated with the database engine and the SQL Server
and SQL Server Agent services.
> Network connection addresses
(*see:
http://msdn.microsoft.com/library/d...-us/architec/8_
ar_cs_9i5u.asp)
Please also review the BOL section on 'multiple instance of SQL Server' in
the index for BOL. See particularly the sections "best practices', 'memory
usage', and 'when to use' to better determine if installing separate
instances is actually in your best interest.
Hope this helps!
Sincerely,
Dana Brash [MSFT]
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "Bad Beagle" <maxwelli@.nospam.postalias>
>Subject: Adding 2nd instance of SQL
>Date: Fri, 13 Jan 2006 07:29:45 -0700
>Lines: 12
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>Message-ID: <eScgO3EGGHA.3944@.tk2msftngp13.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 199.213.91.1
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417520
>X-Tomcat-NG: microsoft.public.sqlserver.server
>I am adding a 2nd instance of SQL on a SQL SP4 box. Can someone please
>clarify a few things for me?
>1. Can this be done during productions hours - does it requre a reboot?
>2. Does it actually install another full version of SQL - I only have a
CD
>that has SQL 2000 on it so I would have to apply the SP 4 after the fact -
>will this affect the production instance default instance)
>3. Does it use a different service account to start?
>4. Can it use a second bound IP address?
>Any other tips I should be aware of? Thanks for your time.
>
>|||Hi,
Just want to say Hi, and I was wondering how everything is going. If
anything is unclear, please let me know. It is my pleasure to be of
assistance.
Hope this helps!
Sincerely,
Dana Brash
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/te...erview/40010469
Others: https://partner.microsoft.com/US/te...upportoverview/
If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "Bad Beagle" <maxwelli@.nospam.postalias>
>Subject: Adding 2nd instance of SQL
>Date: Fri, 13 Jan 2006 07:29:45 -0700
>Lines: 12
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>Message-ID: <eScgO3EGGHA.3944@.tk2msftngp13.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 199.213.91.1
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417520
>X-Tomcat-NG: microsoft.public.sqlserver.server
>I am adding a 2nd instance of SQL on a SQL SP4 box. Can someone please
>clarify a few things for me?
>1. Can this be done during productions hours - does it requre a reboot?
>2. Does it actually install another full version of SQL - I only have a
CD
>that has SQL 2000 on it so I would have to apply the SP 4 after the fact -
>will this affect the production instance default instance)
>3. Does it use a different service account to start?
>4. Can it use a second bound IP address?
>Any other tips I should be aware of? Thanks for your time.
>
>|||Hi,
Just a followup on this post. I am wondering if you have any questions or
concerns about this issue. If you need further assistance, please do not
hesitate to let me know.
Hope this helps!
Sincerely,
Dana Brash
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/te...erview/40010469
Others: https://partner.microsoft.com/US/te...upportoverview/
If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "Bad Beagle" <maxwelli@.nospam.postalias>
>Subject: Adding 2nd instance of SQL
>Date: Fri, 13 Jan 2006 07:29:45 -0700
>Lines: 12
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>Message-ID: <eScgO3EGGHA.3944@.tk2msftngp13.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 199.213.91.1
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417520
>X-Tomcat-NG: microsoft.public.sqlserver.server
>I am adding a 2nd instance of SQL on a SQL SP4 box. Can someone please
>clarify a few things for me?
>1. Can this be done during productions hours - does it requre a reboot?
>2. Does it actually install another full version of SQL - I only have a
CD
>that has SQL 2000 on it so I would have to apply the SP 4 after the fact -
>will this affect the production instance default instance)
>3. Does it use a different service account to start?
>4. Can it use a second bound IP address?
>Any other tips I should be aware of? Thanks for your time.
>
>sql