SQL Server is a service based software. It does not mean you run SQL Server
when you run SSMS\SSMSE. These are just graphical user interfaces which
makes easier to manage your SQL Server Instances.

To detach and attach databases, your SQL Server services must be running and
up. So you are not supposed to stop those SQL Server services to perform
operations against them.

So run both of the SQL Server instances' services and make them running.
Then open up SSMS\SSMSE and then connect both of the SQL Server instanes.
Then determine which one you want to continue to use. I guess you want to go
on with the Enterprise Edition and you want to move your databases which are
currently attached to the Express Edition. So determine which of these
instances is the Express Edition using serverproperty('edition')
command and then if databases are attached to the Express Edition then right
click on the mentioned databases and detach them. And then suddenly jump to
your Enterprise Edition in the Object Explorer window in SSMS\SSMSE. Then
attach those detached databases from the Express Edition, to the Enterprise
Edition.

However, when you perform this operation your databases will be transferred
to the Enterprise Edition instance but not your server level objects. Such
as your Logins\Jobs... I don't know if you have any extra Login or Jobs or
Linked Server etc. however if it's just a simple installation (I'm talking
about your Express Edition here) then it's probably going to be enough just
to move your databases...

P.S.
These are very basics of SQL Server, if you are going to be working on SQL
Server, you'll need to buy a book for starters. Otherwise you'll probably
have lots of headaches. No offence, just an advice.

--
Ekrem Önsoy

"Brian Smither" INVALIDcitlink.net> wrote in message
news:Xns9A7D94CD9FA43aaom@207.46.248.16...