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

27/09/2006, 03h03

Management Studio Express is another download - it's on the
same page. Right below Express Edition.

-Sue

On Tue, 26 Sep 2006 16:44:57 -0400, cj <cj@nospam.nospam>
wrote:

>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.

27/09/2006, 03h03	#6
Sue Hoegemeier Messages: n/a Hébergeur:	Re: SQL Server Express 2005 stopped working--urgent Management Studio Express is another download - it's on the same page. Right below Express Edition. -Sue On Tue, 26 Sep 2006 16:44:57 -0400, cj <cj@nospam.nospam> wrote: >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.