dbTalk Databases Forums  

Installing SQL 2005 when SQL 2008 already installed

microsoft.public.sqlserver.setup microsoft.public.sqlserver.setup


Discuss Installing SQL 2005 when SQL 2008 already installed in the microsoft.public.sqlserver.setup forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ekrem Önsoy
 
Posts: n/a

Default Re: Installing SQL 2005 when SQL 2008 already installed - 07-13-2009 , 02:47 PM






Could it be... Your SQL Server 2008 instance is a Default Instance and you
are trying to install your SQL Server 2005 instance as a Default Instance
too? If so, install your SQL Server 2005 instance as a Named Instance.

--
Ekrem Önsoy - SQL Server MVP



"Carl" <a@b.c>, iletisinde şunu yazdı,
news:%23ZbZQsLBKHA.1208 (AT) TK2MSFTNGP03 (DOT) phx.gbl...
Quote:
I'm trying to do some work with Reporting Services on SQL 2005, using the
Business Intelligence Development Studio. I had SQL 2008 installed on my
machine for another project, and now I have to work with SQL 2005. BIDS
is installed and working for SQL 2008, but I need to use the SQL 2005
version to be compatible with other team members. Whenever I try and
install the SQL 2005 version, it tells me that a newer version is already
installed, and will not be overwritten. I'm installing this on a XP SP2
workstation.

Do I need to uninstall SQL 2008, and then re-install 2005 in order to get
the BIDS for SQL 2005? Or can I create compatible objects with the SQL
2008 version?

Thank you for any help you can provide.

Carl.

Reply With Quote
  #2  
Old   
Carl
 
Posts: n/a

Default Installing SQL 2005 when SQL 2008 already installed - 07-14-2009 , 02:41 PM






I'm trying to do some work with Reporting Services on SQL 2005, using the
Business Intelligence Development Studio. I had SQL 2008 installed on my
machine for another project, and now I have to work with SQL 2005. BIDS is
installed and working for SQL 2008, but I need to use the SQL 2005 version
to be compatible with other team members. Whenever I try and install the
SQL 2005 version, it tells me that a newer version is already installed, and
will not be overwritten. I'm installing this on a XP SP2 workstation.

Do I need to uninstall SQL 2008, and then re-install 2005 in order to get
the BIDS for SQL 2005? Or can I create compatible objects with the SQL 2008
version?

Thank you for any help you can provide.

Carl.

Reply With Quote
  #3  
Old   
Carl
 
Posts: n/a

Default Re: Installing SQL 2005 when SQL 2008 already installed - 07-14-2009 , 02:52 PM



I specifically set the SQL 2005 installation as a named instance to avoid
this issue.

Any other suggestions?

Thanks.

Carl.

"Ekrem Önsoy" <iletisim@ekrem[REMOVETHIS]onsoy.net> wrote

Quote:
Could it be... Your SQL Server 2008 instance is a Default Instance and you
are trying to install your SQL Server 2005 instance as a Default Instance
too? If so, install your SQL Server 2005 instance as a Named Instance.

--
Ekrem Önsoy - SQL Server MVP



"Carl" <a@b.c>, iletisinde şunu yazdı,
news:%23ZbZQsLBKHA.1208 (AT) TK2MSFTNGP03 (DOT) phx.gbl...
I'm trying to do some work with Reporting Services on SQL 2005, using the
Business Intelligence Development Studio. I had SQL 2008 installed on my
machine for another project, and now I have to work with SQL 2005. BIDS
is installed and working for SQL 2008, but I need to use the SQL 2005
version to be compatible with other team members. Whenever I try and
install the SQL 2005 version, it tells me that a newer version is already
installed, and will not be overwritten. I'm installing this on a XP SP2
workstation.

Do I need to uninstall SQL 2008, and then re-install 2005 in order to get
the BIDS for SQL 2005? Or can I create compatible objects with the SQL
2008 version?

Thank you for any help you can provide.

Carl.


Reply With Quote
  #4  
Old   
Tim Glenn
 
Posts: n/a

Default Re: Installing SQL 2005 when SQL 2008 already installed - 07-31-2009 , 08:54 AM



I believe you cannot have both installed at the same time. I use a VM with
2005 installed when I have to work with 2005 reporting.

"Carl" wrote:

Quote:
I specifically set the SQL 2005 installation as a named instance to avoid
this issue.

Any other suggestions?

Thanks.

Carl.

"Ekrem Önsoy" <iletisim@ekrem[REMOVETHIS]onsoy.net> wrote in message
news:F27CB99A-F926-4614-BBB6-0B2C585FCF28 (AT) microsoft (DOT) com...
Could it be... Your SQL Server 2008 instance is a Default Instance and you
are trying to install your SQL Server 2005 instance as a Default Instance
too? If so, install your SQL Server 2005 instance as a Named Instance.

--
Ekrem Önsoy - SQL Server MVP



"Carl" <a@b.c>, iletisinde þunu yazdý,
news:%23ZbZQsLBKHA.1208 (AT) TK2MSFTNGP03 (DOT) phx.gbl...
I'm trying to do some work with Reporting Services on SQL 2005, using the
Business Intelligence Development Studio. I had SQL 2008 installed on my
machine for another project, and now I have to work with SQL 2005. BIDS
is installed and working for SQL 2008, but I need to use the SQL 2005
version to be compatible with other team members. Whenever I try and
install the SQL 2005 version, it tells me that a newer version is already
installed, and will not be overwritten. I'm installing this on a XP SP2
workstation.

Do I need to uninstall SQL 2008, and then re-install 2005 in order to get
the BIDS for SQL 2005? Or can I create compatible objects with the SQL
2008 version?

Thank you for any help you can provide.

Carl.





Reply With Quote
  #5  
Old   
Jeffrey Williams
 
Posts: n/a

Default Re: Installing SQL 2005 when SQL 2008 already installed - 07-31-2009 , 07:32 PM



Go to Add/Remove programs and select Change on your SQL Server 2005 install.
Follow the prompts to add components and add BIDS for SQL Server 2005.

"Tim Glenn" <Tim Glenn (AT) discussions (DOT) microsoft.com> wrote

Quote:
I believe you cannot have both installed at the same time. I use a VM with
2005 installed when I have to work with 2005 reporting.

"Carl" wrote:

I specifically set the SQL 2005 installation as a named instance to avoid
this issue.

Any other suggestions?

Thanks.

Carl.

"Ekrem Önsoy" <iletisim@ekrem[REMOVETHIS]onsoy.net> wrote in message
news:F27CB99A-F926-4614-BBB6-0B2C585FCF28 (AT) microsoft (DOT) com...
Could it be... Your SQL Server 2008 instance is a Default Instance and
you
are trying to install your SQL Server 2005 instance as a Default
Instance
too? If so, install your SQL Server 2005 instance as a Named Instance.

--
Ekrem Önsoy - SQL Server MVP



"Carl" <a@b.c>, iletisinde þunu yazdý,
news:%23ZbZQsLBKHA.1208 (AT) TK2MSFTNGP03 (DOT) phx.gbl...
I'm trying to do some work with Reporting Services on SQL 2005, using
the
Business Intelligence Development Studio. I had SQL 2008 installed on
my
machine for another project, and now I have to work with SQL 2005.
BIDS
is installed and working for SQL 2008, but I need to use the SQL 2005
version to be compatible with other team members. Whenever I try and
install the SQL 2005 version, it tells me that a newer version is
already
installed, and will not be overwritten. I'm installing this on a XP
SP2
workstation.

Do I need to uninstall SQL 2008, and then re-install 2005 in order to
get
the BIDS for SQL 2005? Or can I create compatible objects with the
SQL
2008 version?

Thank you for any help you can provide.

Carl.





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.