Install Second Instance Of SQL Server 2005

I'm trying to install a second instance of SQL Server 2005 to an existing
server where Service Pack 2 is installed. Nothing special - no clustering, I
just want an additional instance for QA purposes.
The problem that I'm experiencing is that I receive an error message during
the installation:
Error 1603 installing Microsoft SQL Server 2005 Setup Support Files
The log file doesn't provide any description of an error. My only guess at
this point is that my current instance has higher versions of files than the
ones on the original install disk.
Any suggestions on how to proceed? Should I wipe-out the server and start
over?
I would appreciate any assistance. THANKS!!!
Regards,
RayHi Ray,
You could try running sqlrun.msi (in the setup directory) directly,
instead of the setup.exe. That would forego the installation of the
Setup Support Files. Not sure if that works, though.
--
Regards,
Steve
www.foxville.ch
On Sep 13, 7:08 pm, raz0r9edge <raz0r9e...@.discussions.microsoft.com>
wrote:
> I'm trying to install a second instance of SQL Server 2005 to an existing
> server where Service Pack 2 is installed. Nothing special - no clustering, I
> just want an additional instance for QA purposes.
> The problem that I'm experiencing is that I receive an error message during
> the installation:
> Error 1603 installing Microsoft SQL Server 2005 Setup Support Files
> The log file doesn't provide any description of an error. My only guess at
> this point is that my current instance has higher versions of files than the
> ones on the original install disk.
> Any suggestions on how to proceed? Should I wipe-out the server and start
> over?
> I would appreciate any assistance. THANKS!!!
> Regards,
> Ray

Install RS - Separate DB from Web

I am trying to install reporting services on a web server, which will connect
to an existing instance of the RS Sql Server backend on another machine.
This backend server already has SP2 installed - so when I install RS on the
web server machine and try to point to the existing backend during
installation, it tells me that it is not compatible.
What would be the correct steps to take in order to install on a web server
and connect to an existing RS backend DB? Any relevant articles will help...
Enjoy!
mikeFirst, are you implementing a web farm?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Michael R" <MichaelR@.discussions.microsoft.com> wrote in message
news:9F638932-02F0-48DF-8EF9-A54EF42AF0FA@.microsoft.com...
>I am trying to install reporting services on a web server, which will
>connect
> to an existing instance of the RS Sql Server backend on another machine.
> This backend server already has SP2 installed - so when I install RS on
> the
> web server machine and try to point to the existing backend during
> installation, it tells me that it is not compatible.
> What would be the correct steps to take in order to install on a web
> server
> and connect to an existing RS backend DB? Any relevant articles will
> help...
> Enjoy!
> mike|||Not in the sense that I will have multiple ReportServer databases. I will
have a one to one relationship: 1 web server and 1 server with the
ReportServer database.
It was recommended that I do this by the server admins, in order to take the
load off of IIS.
"Bruce L-C [MVP]" wrote:
> First, are you implementing a web farm?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Michael R" <MichaelR@.discussions.microsoft.com> wrote in message
> news:9F638932-02F0-48DF-8EF9-A54EF42AF0FA@.microsoft.com...
> >I am trying to install reporting services on a web server, which will
> >connect
> > to an existing instance of the RS Sql Server backend on another machine.
> > This backend server already has SP2 installed - so when I install RS on
> > the
> > web server machine and try to point to the existing backend during
> > installation, it tells me that it is not compatible.
> >
> > What would be the correct steps to take in order to install on a web
> > server
> > and connect to an existing RS backend DB? Any relevant articles will
> > help...
> >
> > Enjoy!
> >
> > mike
>
>|||I would try this:
1) install SQL RS on the web server, and during the install, create new
SQL RS database(s) for it to point to / use (doesn't matter where you
put the DB, you'll end up dropping them soon). At the end of the
install, you'll have a new SQL RS web app, pointing to a new SQL RS db.
2) Apply SP1 to the SQL RS instance (web & new database).
3) Apply SP2 to the SQL RS instance (web & new database).
4) Now that you're web app is up to SP2, you can point it to your
original database using the 'rsconfig' command line utility (see SQL RS
Books Online for details of usage & syntax). After using 'rsconfig' to
point your app to the original database, you'll need to run the
'rskeymgmt' command line utility to initialize / activate your Report
Server for use with the original database (allows it to read the
original database) -- see Books Online for details of syntax and usage.
5) Drop the new SQL RS databases that were created in Step #1, since
you're not going to use them, now that your web app is pointing to the
'original' SP2 database.

Install reporting services after SQL sp2

Hello,
our customer tried to update his existing SQL Server 64 Bit Enterprise
Edition with reporting services to SP2. During Setup there was an error with
the reporting services. So the customer decided to uninstall the reporting
services and applied SP2 successfully after that.
Now he needs the reporting services for a new application. Can i install the
reporting services from the original media and then upgrade that reporting
services installation to sp2?What do i have to take care of?
My plan was to install reporting services via software. Change SQL Server
Installation and add reporting services.
I tried that but the setup then comes up with the warning that there is a
version change. I think that is because the sql server has another
patchlevel than the original installation media. Can i ignore that?
thanks in advance
thomasHi Thomas
Although I haven't tried what you are doing, there is not really any
alternative as there is no slipstreamed releases of SQL Server that will go
straight in as SP2, so I guess you have to ignore the error and continue. It
is probably better to install this by hand!
John
"Thomas Oeser" wrote:
> Hello,
> our customer tried to update his existing SQL Server 64 Bit Enterprise
> Edition with reporting services to SP2. During Setup there was an error with
> the reporting services. So the customer decided to uninstall the reporting
> services and applied SP2 successfully after that.
> Now he needs the reporting services for a new application. Can i install the
> reporting services from the original media and then upgrade that reporting
> services installation to sp2?What do i have to take care of?
> My plan was to install reporting services via software. Change SQL Server
> Installation and add reporting services.
> I tried that but the setup then comes up with the warning that there is a
> version change. I think that is because the sql server has another
> patchlevel than the original installation media. Can i ignore that?
> thanks in advance
> thomas
>

Install New Instance/ Store Data & Log Files in existing drive

Hello,
I need to install a new instance of SQL Server 2000 on a cluster.
Currently, we have three instances. Each instances stores program files on
the E:\ Drive. Each instance has its own drive for data and another for
logs. However, there is no more unallocated space on the array to create
another partitioned drive.
My question is: If I create the new instance, can I store the data and log
files on an existing drive? Are there any performance or overhead costs that
should be considered?
Thank you,
Caroline
Each instance must have separate disk resources from any other instances.
You will need new disks to create another instance.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Caroline" <Caroline@.community.nospam> wrote in message
news:4E870F35-33B9-4E92-91E6-1993FD8FE4C4@.microsoft.com...
> Hello,
> I need to install a new instance of SQL Server 2000 on a cluster.
> Currently, we have three instances. Each instances stores program files
> on
> the E:\ Drive. Each instance has its own drive for data and another for
> logs. However, there is no more unallocated space on the array to create
> another partitioned drive.
> My question is: If I create the new instance, can I store the data and
> log
> files on an existing drive? Are there any performance or overhead costs
> that
> should be considered?
> Thank you,
> Caroline
sql

install integration service on existing instance

I need to install Integration Service on an existing SQL 2005 instance. Is
it possible add components to an existing instance or do I need to create a
new instance of SQL server?
When you install SSIS on a Server, the service is "stand alone", not bound to
a specific instance. You can install SSIS alone, running the setup and asking
for the installation of the Integration services without install the other
components
Gilberto Zampatti
"Mike" wrote:

> I need to install Integration Service on an existing SQL 2005 instance. Is
> it possible add components to an existing instance or do I need to create a
> new instance of SQL server?
>
>

install integration service on existing instance

I need to install Integration Service on an existing SQL 2005 instance. Is
it possible add components to an existing instance or do I need to create a
new instance of SQL server?When you install SSIS on a Server, the service is "stand alone", not bound t
o
a specific instance. You can install SSIS alone, running the setup and askin
g
for the installation of the Integration services without install the other
components
Gilberto Zampatti
"Mike" wrote:

> I need to install Integration Service on an existing SQL 2005 instance. Is
> it possible add components to an existing instance or do I need to create
a
> new instance of SQL server?
>
>

install integration service on existing instance

I need to install Integration Service on an existing SQL 2005 instance. Is
it possible add components to an existing instance or do I need to create a
new instance of SQL server?When you install SSIS on a Server, the service is "stand alone", not bound to
a specific instance. You can install SSIS alone, running the setup and asking
for the installation of the Integration services without install the other
components
Gilberto Zampatti
"Mike" wrote:
> I need to install Integration Service on an existing SQL 2005 instance. Is
> it possible add components to an existing instance or do I need to create a
> new instance of SQL server?
>
>sql

Install Full-Text on Existing SQL Server 2005 Cluster

I need to install the full-text engine on an existing SQL Server 2005
cluster virtual instance but can't seem to figure out how. Any ideas?
Start | Programs | Add/Remove Programs
Click the modify link underneath SQL Server.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Adam Weigert" <adam.weigert@.wegmans.com> wrote in message
news:uKpmBzkPGHA.2624@.TK2MSFTNGP12.phx.gbl...
>I need to install the full-text engine on an existing SQL Server 2005
>cluster virtual instance but can't seem to figure out how. Any ideas?
>
|||Unfortunately, the only change operation I can do from Add/Remove programs
for the cluster instance is either add or remove a node from the cluster.
There are no options to change what is installed.
I've looked at some of the command line maintenance features, but haven't
been able to figure out the correct command to issue.
Any other ideas or info?
|||In case anyone else runs into this, I did open a support case with Microsoft
and they concluded that this option was "left out" of the cluster change
options. They are going to place a feature enhancement request with the
product team. I'll update the thread if any new information arises in the
near future.
|||Thanks for the info.
*mike hodgson*
http://sqlnerd.blogspot.com
Adam Weigert wrote:

>In case anyone else runs into this, I did open a support case with Microsoft
>and they concluded that this option was "left out" of the cluster change
>options. They are going to place a feature enhancement request with the
>product team. I'll update the thread if any new information arises in the
>near future.
>
>

Installation configuration

I am new to SRS, so bear with me. Can I install SRS on my existing SQL box;
install SRM on my existing web box on a different site; and install VS.NET
with report designer on my desktop?It's just depened only on software and hardware yours PC configuration. There
is not other depenedences. Ofcourse You can instal SRS on your SQL box and
SRM on your web box. VS.NET you can have everywhere you want.
J
"Dwayne" wrote:
> I am new to SRS, so bear with me. Can I install SRS on my existing SQL box;
> install SRM on my existing web box on a different site; and install VS.NET
> with report designer on my desktop?

Install database on existing MSDE server with unknown SA password?

Question regarding the MSDE SP3a install process...
What happens if I attempt to install MSDE on a server that already has MSDE
installed and the SA password has been changed to an unknown password? Can
I still install an instance for my database without knowing the SA password?
If not, how can I get around this issue?
I can see my app/database being installed at a customers site that already
has a version of MSDE for a different application they have already
installed and are using.
Thanks,
Jim K.
You should be able to install using Windows authentication, assuming you
know the password for an administrator on the box.
With that, you can also reset the sa password for an existing instance using
sp_password.
http://www.aspfaq.com/
(Reverse address to reply.)
"Jim K" <krusej@.megsinet.net> wrote in message
news:u$W9756gEHA.2952@.TK2MSFTNGP09.phx.gbl...
> Question regarding the MSDE SP3a install process...
> What happens if I attempt to install MSDE on a server that already has
MSDE
> installed and the SA password has been changed to an unknown password?
Can
> I still install an instance for my database without knowing the SA
password?
> If not, how can I get around this issue?
> I can see my app/database being installed at a customers site that already
> has a version of MSDE for a different application they have already
> installed and are using.
> Thanks,
> Jim K.
>

install another instance in existing sql server

hi, How do I isntall another isntance in existing sql server?
ThanksMecn,
You do another installation. When it gets to the proper dialog, choose
Instance Name instead of Default and give it a name. All of the SQL Server
software will be reinstalled, but will not update or overwrite the
installation for any existing instance, whether Default or some other named
instance.
RLF
"Mecn" <mecn@.yahoo.com> wrote in message
news:uxXm%23lBZIHA.4448@.TK2MSFTNGP03.phx.gbl...
> hi, How do I isntall another isntance in existing sql server?
> Thanks
>|||Run the setup program. It will prompt you for the new instance name.
--
Jason Massie
Web: http://statisticsio.com
RSS: http://feeds.feedburner.com/statisticsio
"Mecn" <mecn@.yahoo.com> wrote in message
news:uxXm%23lBZIHA.4448@.TK2MSFTNGP03.phx.gbl...
> hi, How do I isntall another isntance in existing sql server?
> Thanks
>|||Got it, Thanks all
"Jason Massie" <jason**R3move**@.statisticsio.com> wrote in message
news:e5tKZuBZIHA.4180@.TK2MSFTNGP06.phx.gbl...
> Run the setup program. It will prompt you for the new instance name.
> --
> Jason Massie
> Web: http://statisticsio.com
> RSS: http://feeds.feedburner.com/statisticsio
> "Mecn" <mecn@.yahoo.com> wrote in message
> news:uxXm%23lBZIHA.4448@.TK2MSFTNGP03.phx.gbl...
>> hi, How do I isntall another isntance in existing sql server?
>> Thanks
>