Re: Adding a server instance to SQL 2005

richardb (richardb@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
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.

It could be that if you run the MSI:s from the command line that you
work around this. I don't know much about running setup from the command
line, but is described in Books Online.

If the install is really hardwired to this one instance name, this would
mean that you would need the media to install SQL 2005, even if you already
have the license. Unless, that is, the OEM installation is only
licensed to that single instance. That may be worth checking out.

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?

There is no need to stop a running instance of SQL Server when you install
a second one.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Installing Report Services with Named Instance
    ... The preparing To Install doc states under "Choosing a Named Instance" quote: ... Windows XP or Windows 200, and the local SQL Server is a named instance. ...
    (microsoft.public.sqlserver.tools)
  • MSDE 2000 SP4 install gets to very end then rolls it all back
    ... On most machines my msde install goes fine. ... exuisting SQL server. ... Starting custom action SaveSqlServerServiceStates() ... Action start 14:23:53: RegisterClassInfo. ...
    (microsoft.public.sqlserver.setup)
  • Re: Problem install SQL Server 2005 Express
    ... If you select Named Instance, ... Click Installed Instances to view a list of installed SQL Server Express ... SQL Server Express Setup checks whether the instance name SQLExpress exists ... Developer 2005 Express Edition and trying to install SQL Server 2005 ...
    (microsoft.public.sqlserver.setup)
  • Re: Critical Alert Update - W32.Slammer
    ... The .net SDK 1.0 sp1 comes with a very basic SQL Server engine for testing ... >> Microsoft SQL Desktop ... >>>cumulative SQL security patch, is completely safe from ... >> may install SQL ...
    (microsoft.public.security)
  • RE: SBS 2003 SP1 Upgrade - MSDE 2000 Service Pack 4 did not instal
    ... registry keys of the Microsoft SQL server and mail to me for analyze. ... This newsgroup only focuses on SBS technical issues. ... SBS 2003 SP1 Upgrade - MSDE 2000 Service Pack 4 did not install ...
    (microsoft.public.windows.server.sbs)