I used SQL Server Express 2005 on my pc for a few months over a year
ago. That project was dropped and I moved on to non-database projects
for awhile. Then I had to connect to the company's SQL Server 2000
server and they installed Enterprise Manager for it on my pc. Now
they've resurrected the project canceled over a year ago and I need at
least the structure and indexes of those database tables from SQL Server
Express 2005 on my pc but I can't connect to it. SQL Server Express Mgr
gives an error and will not come up. Enterprise Manager says it doesn't
exist or it can't connect to it. I desperately need getting
connected to it again so I can retrieve those database tables. I do
know where the database files exist if that s--c:\sqldatabases\

Any would be greatly appreciated. I'm only semi literate in things
related to running a SQL server so please keep that in mind.

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.
--
Rick Byham, MS
This posting is provided "AS IS" with no warranties, and confers no rights.

"cj" <cj@nospam.nospam> wrote in message
news:erskMFY4GHA.3644@TK2MSFTNGP03.phx.gbl...
>I used SQL Server Express 2005 on my pc for a few months over a year ago.
>That project was dropped and I moved on to non-database projects for
>awhile. Then I had to connect to the company's SQL Server 2000 server and
>they installed Enterprise Manager for it on my pc. Now they've resurrected
>the project canceled over a year ago and I need at least the structure and
>indexes of those database tables from SQL Server Express 2005 on my pc but
>I can't connect to it. SQL Server Express Mgr gives an error and will not
>come up. Enterprise Manager says it doesn't exist or it can't connect to
>it. I desperately need getting connected to it again so I can
>retrieve those database tables. I do know where the database files exist
>if that s--c:\sqldatabases\
>
> Any would be greatly appreciated. I'm only semi literate in things
> related to running a SQL server so please keep that in mind.

uninstall and reinstall is easier said than done. It took forever to
get it working back when I was using it. Express Mgr does not load but
more importantly SQL Server Configuration Manager says SQL
Server(SQLEXPRESS) is stopped and when I try to start it, it says "The
request failed or the service did not respond in a timely fashion.
Consult the event log or other applicable error logs for details.


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.

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.

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.

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.

Hello,

Yes. You need to install Management Studio Express from

Microsoft SQL Server Management Studio Express
http://www.microsoft.com/downloads/d...5AE-4BD1-4E3D-
94B8-5A0F62BF7796&displaylang=en

It seems that you had beta edition of SQL Express installed. If you had
issues of connecting to the old database from the reinstalled instance, you
may want to attach the database files you found to this new instance. You
could use try to attach the found database file to the new instance by sth
like:

use master
go
sp_attach_db 'mydb','E:\Sqldata\mydbdata.mdf','E:\Sqldata\mydbl og.ldf'
go

Note: Please back up the database files before you try to attach them to
new instance of SQL Server.

Actuatlly if you have other SQL 2005 instance installed on other machines,
you could also try to copy the files to the machine and try to attach the
database :

224071 INF: Moving SQL Server Databases to a New Location with Detach/Attach
http://support.microsoft.com/?id=224071

314546 HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/?id=314546

If the issue is urgent, I recommend that you open a Support incident with
Microsoft Product Support Services so that a dedicated Support Professional
can assist with this case. If you need any in this regard, please let
me know.

For a complete list of Microsoft Product Support Services phone numbers,
please go to the following address on the World Wide Web:
http://support.microsoft.com/directory/overview.asp

Hope this is ful. Please feel free to reply if you need any assistance.
thanks.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.