Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 694
  • Last Modified:

Installing SQL Server 2005 Biz intell aside SQL Server 2008

I have SQL Server 2008 installed on my laptop - the complete package.  Database server, reporting services, analytical services, etc.  I need to get the SQL Server 2005 Business Intelligence tool also installed because that's what my business uses for production.  I get the following error when trying to install the package:

Machine         : DELLD820
Product         : SQL Server Backward-Compatibility Files
Error           : The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2203.
--------------------------------------------------------------------------------
Machine         : DELLD820
Product         : Microsoft SQL Server 2005 Backward compatibility
Product Version : 8.05.1054
Install         : Failed
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0002_DELLD820_BackwardsCompat_1.log
Last Action     : InstallInitialize
Error String    :ipi
Error Number    : 2203

The detail error in the log is:

DEBUG: Error 2203:  Database: C:\Windows\Installer\2282fbf.ipi. Cannot open database file. System error -2147287035
MSI (s) (D0:C0) [06:18:12:890]: Product: Microsoft SQL Server 2005 Backward compatibility -- The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2203. The arguments are: C:\Windows\Installer\2282fbf.ipi, -2147287035,

The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2203. The arguments are: C:\Windows\Installer\2282fbf.ipi, -2147287035,


Any help would be appreciated.
0
JLEmlet
Asked:
JLEmlet
  • 4
  • 3
  • 2
1 Solution
 
rob_farleyCommented:
You should install SQL Server 2005 completely too. The SQL 2005 tools cannot open SQL 2008 packages, as they don't understand the SQL 2008 parts of it.

If you're trying to have a development environment that must produce SQL 2005 stuff (packages, cubes, etc), then you should use an installation of SQL 2005 for it.

I know this isn't what you want to hear, but it's the way it goes...

Rob
0
 
pcelbaCommented:
It seems the Microsoft SQL Server 2005 Backward compatibility tool is attempting to open some SQL 2008 database (versions do not match, of course). BUT this tools can open just SQL 2000 (and older) databases and fails when trying to open SQL 2008 data.

If you leave all data in SQL2005 format then it could work.
0
 
JLEmletAuthor Commented:
I only want to install the client tools for SQL 2005.  I don't care about the SQL 2005 server products.  So I'm not sure how best to proceed with your recommendations.  I do not have the option of installing all of SQL 2005 - the server products are grayed out on installation.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
rob_farleyCommented:
You should be able to choose just the Client Tools in the installation wizard for SQL 2005.
0
 
JLEmletAuthor Commented:
That's what I chose that gave me the original error.  I wasn't trying to install anything except for the Biz Intell (VB Studio) .
0
 
rob_farleyCommented:
Oh, I see. Sorry, had thought you were meaning when you opened an SSIS 2005 Package.

I'll give it some more thought, but I haven't come across many people who have had trouble putting 2005 client tools on a machine before (even if they have 2008 already).

Is your system 32-bit? And are you using a 32-bit version of the install?
0
 
pcelbaCommented:
Yes but the client installation is attempting to open some database because the error says "Cannot open database file." Possible reason is in answer ID:26068607.

Two ways exist now (no one of them looks satisfactory):
1) Ask Microsoft to fix this bug
2) Uninstall SQL 2008, Install SQL Server 2005 Business Intelligence tool, and install back SQL 2008

But, maybe I am wrong...
0
 
rob_farleyCommented:
Seems this error means "Access Denied". So can you make sure you're running setup with elevated permissions, and can you also try disabling your anti-virus for a moment while you try the installation? Don't open anything else during the install, and make sure it's a real copy of SQL you're using. Then reenable as soon as it's done.

Rob
0
 
JLEmletAuthor Commented:
I reinstalled the system and now i was able to install both.
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 4
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now