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

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

• David Kyle

  Hi,

  It could be that your SqlExpress and Express Manager is not compatible. Try downloading the latest Express (renamed as Server Management Studio) Here. This manager is compatible to the release version on SqlExpress...

   

   

  cheers,

  Paul June A. Domag

  
  
  

• InVitro

  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

  
  
  

• Egypt Develover

  Hi,
  
  The SQL Server 2005 Express uses the Express Manager(XM). Further with SQL Server 2005, the Enterprise Manager has been replaced a tool called SQL Management Studio.
  
  One correction to Paul's information is that the June CTP of SQL Server 2005 does not require a MSDN subscription or the DVD ordering. Its available for direct public download from here:
  http://www.microsoft.com/sql/2005/productinfo/ctp.mspx
  
  Regards,
  Vikram
  
  

• Daniel Molina - MSFT

  Hi,
  
  SMO would be installed upon installing SqlExpress.
  
  
  
  
  cheers,
  
  Paul June A. Domag
  
  
  

• Evian_

  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

  
  
  

• MSDN Sealevel

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

• llvc

  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

  
  

• gimmick

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

   

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

  
  

• Sid463

  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

  
  

• SSISy Boy

  Hi,
  
  Definitely. SqlExpress is the replacement for MSDE. SqlExpress extends MSDE's maximum size to 4gb higher than MSDE's 2gb. But you don't need to install MSDE to connect to a remote database. MSDE and SqlExpress are Database Engines theirselves. YOu only need to have a data provider to be able to connect to a remote sql database.
  
  
  
  
  cheers,
  
  Paul June A. Domag
  
  
  

• jmoser

  Hi,

  You have posted the same question on thread

  How can I connect to Microsoft SQL Server 2005 CTP with Microsoft...

  The thread has been moved to SQL Server Data Access

  Please refer to the thread for future responses and inquiries on the said topic...

   

  cheers,

  Paul June A. Domag

  
  
  

• KnowsEnuf2BDangrous

  Hi,

  Yup.

   

  cheers,

  Paul June A. Domag

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