Re: SQL Server Express 2005 stopped working--urgent
I uninstalled Express Manager and when I try to reinstall it I get:
SQL server 2005 CTP Setup has detected incompatible beta components from
Visual Studio or SQL Server, You must run the build cleanup wizard from
the CD to remove previous SQL Server 2005 components and .NET Framework
components, and then run SQL Server 2005 CTP Setup again. For detailed
instructions on uninstalling SQL Server builds, see the SQL Server 2005
CTP readme file.
I have notes on where I fixed this back when I initially installed SQL
Express in June of 2005 that said I had to:
Run sqlexpr.exe /x which unzips its contents into a directory you
specify. The under that dir in setup tools\build uninstall wizard run
sqlbuw.exe. Allow sqlbuw.exe to uninstall the .net framework 2.0. If
you've used control pannel's add or remove programs to uninstall
framework 2.0 you need to reinstall it so sqlbuw.exe can uninstall it.
Once sqlbuw.exe has uninstalled it you can reinstall it and then run
sqlexpr.exe.
Since I have Visual Studio 2003 and 2005 on this pc and also use SQL
Server Enterprise Mgr now I decided not to try to reinstall SQL Express
on this pc. I have another PC that does not have any SQL server stuff
on it--it does have Visual Studio 2003 but not 2005. I copied the
install files for SQL Express to that and tried to install it there. I
get the same error on this pc:
SQL server 2005 CTP Setup has detected incompatible beta components from
Visual Studio or SQL Server, You must run the build cleanup wizard from
the CD to remove previous SQL Server 2005 components and .NET Framework
components, and then run SQL Server 2005 CTP Setup again. For detailed
instructions on uninstalling SQL Server builds, see the SQL Server 2005
CTP readme file.
So I followed the instructions and sqlbuw.exe reports:
There are no SQL Server 2005 or .NET Framework components to uninstall.
You may now run setup wizard to install new instance of SQL Server 2005.
That's crap. I see in Start/settings/control pannel/add or remove
programs that MS .NET Framework 1.1 and 2.0 are both on this pc. And I
still the sqlexpress setup wizard still gives the same error. So I
can't get it installed on this pc either. If I could I'd copy the mdf
and ldf file to it and view the DB structures there.
perhaps you can me get SQLExpress installed on that pc?
Rick Byham, MS wrote:
> You say Express Manager gives an error and won't come up. If this is
> just the tool that's failing, uninstall Express Manager, then reinstall
> Express Manager and try again.
>
> If the Express Manager opens but can't connect to SQL Server Express,
> that's different problem.
> - Could be an expired password (update that with SQL Server
> Configuration Manager).
> - Could be SQL Server Express is not started.
> - Could be that the SQL Server Browser Service is not running (start
> that with SQL Server Configuration Manager).
>
> SQL Server 2000 Enterprise Manager cannot connect to SQL Server 2005, so
> that won't work. SQL Server 2000 Query Analyzer can, if you are
> comfortable with that tool.
|