Re: Adding a server instance to SQL 2005

You would not being adding the named instance. Rather, you'd be placing the
database into an existing instance. In that case, you'd have to have the
service running for that instance.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"richardb" <richardb@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D7997E05-F595-42DF-90D8-E6219B611859@xxxxxxxxxxxxxxxx
Rick,

This is much clearer to me now. The SQL 2005 OEM disks that came with the
[medical billing] software only installs their named instance; there's no
choice, and no way to specify a different instance if I install it again. I
suppose I could have prevously installed SQL 2005 from some other source,
then install the OEM version and that would add their instance to the one I
had already. A posting on a forum (for the billing software) said that if I
want to do that (add the OEM named instance to an existing SQL 2005 server)
that I should shut down the SQL services before starting the OEM SQL
install.
Would you agree with that?

Richard Bennett

"Rick Byham, (MSFT)" wrote:

You must run setup from the CD to install another instance of the SQL
Server
Database Engine.
Or, if you are running SQL Server Express edition, run the install program
a
second time and name the new instance something other than the default
name
(SQLExpress).
As an alternative, you can install another database (for use by another
program) onto the first instance. That you could do using Management
Studio.
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no
rights.

"richardb" <richardb@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B95EF417-C50F-4575-9FC4-65AD9DBA4149@xxxxxxxxxxxxxxxx
I appologize for this simple question. However, i have a software that
installs a full version of SQL 2005 and its own named server instance.
Now
i
want to add another server instance (for use by another program).
However,
I
can't figure out or find documentation how to add onther server using
the
SQL
Server Management Studio, and would appreciate advice. Thank you.



.

Relevant Pages

  • RE: How do I get back to base SQL server on my SBS 2003 server?
    ... After you uninstall SQL 2005, the instance which you upgraded will not go ... Uninstall and then reinstall ISA server. ... Uninstall and then reinstall the Monitoring component. ... Tools to Maintenance, change Monitoring component to Install, and then ...
    (microsoft.public.windows.server.sbs)
  • RE: How do I get back to base SQL server on my SBS 2003 server?
    ... What's the error message you see when installing SQL? ... the easier way is to restore the server from recent backup. ... Screen shot of the error when you install SQL 2005 Workgroup edition. ... <The server-based applications that were running fine are: McAFee EPO, ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS 2003 and Sql Server ~ Client Install
    ... I've found the client tools and have now ... A word mail merge document could access a SQL database via ... We want to install to gain an understanding. ... Once we've managed to install the SQL Server Client we can start to ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: how do I change the user install wizard to create user folder in different location?
    ... Some people read the instructions in such a way that they install both a new ... instance of sql, ... Never slight the SBS wizards. ... I reinstalled from scratch using the Dell OpenManage Server ...
    (microsoft.public.windows.server.sbs)
  • Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
    ... Config Tool of SQL Server? ... > link to download the PUBs database. ... >>> Setup and they directed me to install MSDE and they attached a ...
    (microsoft.public.sqlserver.msde)