How to install Express Manager tool?

After wasting several days trying to get SQL 2005 installed on my test server & to connect to a virgin database (DotNetNuke), I'm reverting to simply using Express. That should be simple, right ! It's even installed with Visual Studio 2005 (June CPT)!

Lookoing, the only thing under Start|All Programs are
Microsoft SQL Server 2005 CTP|Configuration Tools with threee entries:
SQL Server Configuration Manager.lnk,
SQL Server Error and Usage Reporting.lnk and
SQL Server Surface Area Configuration.lnk

Ah, I'll use the ConfigManager to create my blank database, since the other two tools obviously are for other things. I start it up, try adding an "alias", but quickly find that isn't right and nothing else seems appropriate. Grrr... Forced to go to Help, it fairly quickly states to use the "Express Manager tool" for SQL Express. After relooking through All Programs, I search the entire help file and "Express Manager tool" only shows up twice, in neither case stating where it is.

Anyone know why this is hidden away and where it is Looking at some other posts it seems to exist -- but not be very appreciated. Thanks for any tips!

- John

Answer this question

How to install Express Manager tool?

SealedSun.ch
Hi,

there is an side by side issue with Sql Server and Sql Server Express. If you have installed Express you cannot use all tools of Sql Server.
Srini Satrasala
Hi, thanks for the fast response - and sorry if my frustration led to a bit too glib of a post!

Anyway, I don't think this is my issue, as on my dev machine I don't have full SQL Server 2005 installed (that was on another machine).

Can anyone say that SQL Express' has an Express Manager tool and that it typically gets installed with a shortcut somewhere under Start | All Programs If so, in my case I probably can not find this tool as the original (& subsequent) install failed to complete - for whatever reason.

Thanks for alerting me to the side-by-side issue though - I would have hit that before too long!!
Kevin Vogler
Don't forget the dot .
.\SqlExpress
Pedro Martins
Hi,

you can download this tool here:

http://www.microsoft.com/downloads/details.aspx FamilyId=C7A5CC62-EC54-4299-85FC-BA05C181ED55&displaylang=en
.NETBloake
try to enter with \SQLEXPRESS instead of (Local) / Windows Authentication.

Ashish P. Ruparel

Ah, trying to reinstall Express gives me:

[07/13/05,22:03:19] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition April CTP x86 is not installed.  ***EndOfSession***[07/20/05,21:11:33] Microsoft SQL Server 2005 Express Edition April CTP x86: [2] Error code 1603 for this component means "Fatal error during installation. " [07/20/05,21:11:35] Microsoft SQL Server 2005 Express Edition April CTP x86: [2] Setup Failed on component Microsoft SQL Server 2005 Express Edition April CTP x86 ***EndOfSession***







So maybe I'm just hosed !

Sanderb

Hello John,

I am in your same situation here. The Express Manager Tool I have down loaded and Installed seperatly. But when I tried to run Exp. Manager tool it asking me a

Server Instance name
Windows Authentication
Sql Server Authenticaion

I tried to enter with (Local) / Windows Authentication

But getting an error of Time out - Says Server is not responding

I checked the SQL Server and SQL Browser is Running
All other services and Protocals are Enabled...

I dont have any clue what next...!!!
How to install Express Manager tool?

Answer this question