PHWinfo - Afficher un message - SQL Server Express 2005 stopped working--urgent

26/09/2006, 21h44

I finally found http://www.petefreitag.com/item/458.cfm who seems to
have had the same problems I have had. That lead me to
http://msdn.microsoft.com/vstudio/express/sql/download/ and I downloaded
and was able to get SQL Server 2005 Express installed. But where is SQL
Server Express Manager? Please me find it? Did I not download
enough? I downloaded Install Microsoft SQL Server 2005 Express Edition.
Do I need to download SQL Server Management Studio Express?

cj wrote:
> 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.

26/09/2006, 21h44	#5
cj Messages: n/a Hébergeur:	Re: SQL Server Express 2005 stopped working--urgent I finally found http://www.petefreitag.com/item/458.cfm who seems to have had the same problems I have had. That lead me to http://msdn.microsoft.com/vstudio/express/sql/download/ and I downloaded and was able to get SQL Server 2005 Express installed. But where is SQL Server Express Manager? Please me find it? Did I not download enough? I downloaded Install Microsoft SQL Server 2005 Express Edition. Do I need to download SQL Server Management Studio Express? cj wrote: > 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.