Connecting to MSDE with Enterprise manager.. 1

[matthewking]

Hi all,

I've just installed MSDE on my system, I already has Sql Server 2000 running. I installed MSDE as instance name "msde" and have compname&msde service running, so it appears to be working.

When I open query analyzer I can connect to this instance and run queries on it, however my knowledge of database administration through sql is limited, therefore I would like to connect to the msde db through enterprise manager.

Im not sure how I even start to do this? Any help would be greatly appreciated.

Thanks in advance,
Matt.

 

[JamesLean]

In Ent Mgr, right-click "SQL Server Group" and select "New SQL Server registration...".

In the server name box type in your instance name (machine\instance). Select the authentication method you want to use, as you do when connecting via Query Analyzer.

Click OK and you should see the server appear in your list.

--James

 

[matthewking]

Great, Thanks very much. I did actually try that earlier but I had it on the wizard, so it only displayed a list of servers, with msde not included, oh well.

Thanks again,

Matt.