Calling all MSSQL 2005 Experts

[theintrepidfox]

Dear Group.

Wondered if any of you has any suggestion for the following?
Trying to install SQL Server 2005 Eval on a 'clean' machine. Well, my
mistake was probably that I had installed Visual Studio 2005
Professional Eval before which installed an MSSQL Express instance.
Since then I didn't get 'Enterprise Manager' (excuse my ignorance, I
know it's called differently in2005 but it's late and I'm tired) for
MSSQL 2005 installed.Don't remember the error exactly but after some
trying I received some error during the MSSQL Management Studio (is
that right?) installation that it needs to be upgraded in some ini file
which I looked for to no avail. ANYWAY, after some desperate registry
deletes and following MS Kbase articles I arrived at: 'The installer
has encountered an unexpected error installing this package. This may
indicate a problem with the package. The error code is 2718.' during
the installation of SQL Server Backward-Compatibility files.
Which is of course complete rubbish. We all now that Microsoft has done
an awful job in getting SQL Express and SQL Server installed
side-by-side but it never has been as bad as this on any machine
before. Needless to say the package is fine as I've used it many times
before. Any suggestions?

Gratefully yours,

Martin

'Just wanna get on with work. Tired of starring at error messages.'

[Erland Sommarskog]

(th************@hotmail.com) writes:

Wondered if any of you has any suggestion for the following?
Trying to install SQL Server 2005 Eval on a 'clean' machine. Well, my
mistake was probably that I had installed Visual Studio 2005
Professional Eval before which installed an MSSQL Express instance.
Since then I didn't get 'Enterprise Manager' (excuse my ignorance, I
know it's called differently in2005 but it's late and I'm tired) for
MSSQL 2005 installed.Don't remember the error exactly but after some
trying I received some error during the MSSQL Management Studio (is
that right?) installation that it needs to be upgraded in some ini file
which I looked for to no avail. ANYWAY, after some desperate registry
deletes and following MS Kbase articles I arrived at: 'The installer
has encountered an unexpected error installing this package. This may
indicate a problem with the package. The error code is 2718.' during
the installation of SQL Server Backward-Compatibility files.
Which is of course complete rubbish. We all now that Microsoft has done
an awful job in getting SQL Express and SQL Server installed
side-by-side but it never has been as bad as this on any machine
before. Needless to say the package is fine as I've used it many times
before. Any suggestions?

It's very unclear what you have done, after messing with the registry your
machine may be beyond repair. Or may at least require a complete uninstall
of VS and SQL Server and back again.

But if you already had SQL Server Management Studio Express installed,
that may be the root of your problem, as you cannot have both SSMS Express
and the big SSMS installed side by side.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx