July 10, 2005

Express Manager

Do you have quistion like these? ;-)

- Where's the SQL Server Express Manager?
- I can't see the SQL Server Express Manager in start menu.
- I install the Microsoft SQL Server 2005 CTP but i havn't SQL Server Express Manager.
- I have just "Configuration Tools" sub menu in "Microsoft SQL Server 2005 CTP" at start menu.

The new Express Manager with considerable GUI(graphic User Interface) is seprated than Microsoft SQL Server 2005 CTP Package that come with Microsoft Visual Studio 2005 Beta 2.0 and you must download it from microsoft site.
This package is ExpressManager.msi with about "1004KB" size
Aftre install the Microsoft SQL Server 2005 CTP and Express Manager, you must enable SQL Server (SQLEXPRESS). for this work you can used of these two ways:

1- Start > Run > SQLServerManager.msc > SQL Server Configuration Manager (local) > SQL Server 2005 Services > SQL Server (SQLEXPRESS) > Right Click >Start

2- Start > Run > compmgmt.msc > Service and Applications > SQL Server Configuration Manager > SQL Server 2005 Services > SQL Server (SQLEXPRESS) > Right Click > Start

After that you must start the Express Manager from start menu.

In first look you see the "Connect to Server" form that must enter a "Server Instance" and then press Connect. (for example you can enter ".\SQLEXPRESS" in editbox)

Application: Microsoft SQL Server2005 Express Manager Preview 1
Version: 9.00.1116.00

Ok, wellcome to Microsoft® SQL Server™ 2005 Express Manager.

PS: If you don't like that type ".\SQLEXPRESS" for ever strat the Express Manager you can use of Express Manager Arguments.

-? Show the list of Arguments
-S server_name[\instance]
-d database
-U user_login
-P password

Start>Run>C:\Progra~1\Micros~4\XM.exe -? (for show the all Arguments)
Start>Run>C:\Progra~1\Micros~4\XM.exe -E -S .\SQLEXPRESS (for start without command)

Or you can edit your shortcut and insert new Arguments at the last of the target field.
Start>\Microsoft SQL Server 2005 CTP>SQL Server Express Manager>RightClick>Properties>Taget>"C:\Program Files\Microsoft SQL Server 2005 Express Manager\XM.exe" -E -S .\SQLEXPRESS

No comments: