I have installed Microsoft SQL Server 2005 Express edition, but I can't find Enterprise Manager

Hi,

Express edition doesn't contain an Enterprise manager. You need to obtain a SQLServer 2005 CTP (not the express edition) to have an enterprise manager. In the SQLExpress you can browse by downloading the Express manager, Its not as elegant as the enterprise manager but at least you can browse the databases...

SQLServer 2005 CTP
http://msdn.microsoft.com/getthebetas/
(Download only available for MSDN subscribers, but you could order a DVD copy)

Express Manager (for SqlServer Express)
http://go.microsoft.com/fwlink/?linkid=48441

cheers,

Paul June A. Domag

How can I connect to Microsoft SQL Server 2005 CTP with Microsoft SQL Server 2005 Express Manager?

I installed Microsoft SQL Server 2005 Express Manager and connect to SQL 2000 normally
but when I connect to Microsoft SQL Server 2005 CTP, I failed! when I open SQL Configuration Manager,
I find the SQL Server had been running, after I opened "Attribute" window, I find "This account" box had been checked,
and "NT AUTHORITY\NETWORK SERVICE" was displayed in Account Name edit box, "**********" was displayed in "Password" edit box.

I think that the reason I can't connect to Microsoft SQL Server 2005 CTP is that I can't know the name of SQL Server 200, account, password.
right? In Microsoft SQL Server 2000 I can find the name of server from "Service Manager" and default accunt is "SA", the default password is blank.
but I can't find it in Microsoft SQL Server 2005. Any more, when I open "Express Manager", there are two radio button, "Windows Authentication" and "SQL Server Authentication",
which one will I choose? Does "Server Instance" point the name of SQL Server 2000? or Does "Server Instance" point the name of my computer?

Hi

Does SQLExpress replace MSDE. I usually install MSDE to establish a connection to the main database, and also create a database on a workstation. If I install SQLExpress, will it do the same for me?

Thanks a million.............

So in effect this means that if I install SQLExpress at a Remote Branch, I will have everything I need?

When installing EM, the install dialogue box saids it needs SMO component. What and where do I get this?

I have installed SQLExpress 2005 and .NET2 on a WinXP SP2 PC and I have admin rights on this machine.

However, when I run ExpressManager.msi, the dialogue box saids

"This computer must have at least Windows 2000 SP4 and the user must have adminstrator previleges to continue. Also, you must install the SMO component and the .NET framework v2.0."

Is there a chance I downloaded the Windows 2000 version of the ExpressManager?