After upgrade MSDE Sp4 Can't connect it through Enterprise Manager

Hi,
I have upgrade MSDE to SP4, but can't connect it throught enterprise manager
after upgrade.
How can I fix it?
Thanks,
Tiger
hi Tiger (Oracle user? :D ),
Tiger wrote:
> Hi,
> I have upgrade MSDE to SP4, but can't connect it throught enterprise
> manager after upgrade.
actually you shoud have no technical problem (but legal)...
what kind of exception are you reported with when trying connection to MSDE
instance?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||No, I'm not use Oracle
I just use SQL Server Enterprise Manager to connect client PC MSDE, but
after upgrade MSDE to SP4, then fail to connect.
Tiger
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3ngm9cF1ecmrU1@.individual.net...
> hi Tiger (Oracle user? :D ),
> Tiger wrote:
> actually you shoud have no technical problem (but legal)...
> what kind of exception are you reported with when trying connection to
> MSDE instance?
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Tiger,
Tiger wrote:
> No, I'm not use Oracle
>
that was a joke, as Scott / Tiger are the "default" sample credentials for
accessing Oracle

> I just use SQL Server Enterprise Manager to connect client PC MSDE,
> but after upgrade MSDE to SP4, then fail to connect.
what kind of exception are you reported with when trying connection to MSDE
instance?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||On Mon, 29 Aug 2005 17:01:01 +0200, "Andrea Montanari"
<andrea.sqlDMO@.virgilio.it> wrote:

> hi Tiger (Oracle user? :D ),
> Tiger wrote:
> actually you shoud have no technical problem (but legal)...
Legal problem?
I thought a SQL Server Developer Edition license ($39 or free with MSDN)
allows you to use Enterprise Manager to configure your development copies
of MSDE.
Managing production copies is another matter, but Tiger never mentioned
that.
|||hi,
Lucvdv wrote:
> Legal problem?
> I thought a SQL Server Developer Edition license ($39 or free with
> MSDN) allows you to use Enterprise Manager to configure your
> development copies of MSDE.
> Managing production copies is another matter, but Tiger never
> mentioned that.
if you install SQL Server Dev Edition (for dev and test) you already have a
full SQL Server instance and should not require MSDE at all, but I must
confess as well I've both installed on the same dev pc for my own tests/dev
tasks...
as regard the "legal" problem, I always refer to http://tinyurl.com/ac3v2 ,
where Steve presents a good metaphor about using SQL Server Client Tools
against MSDE in production...
then it's all up to you...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi!
I had the same problem - it seems that SP4 changes the server port ... check
this in server network utility.
greeting
Lukas
"Tiger" <tigerwong666@.hotmail.com> schrieb im Newsbeitrag
news:OBwjydHrFHA.3216@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I have upgrade MSDE to SP4, but can't connect it throught enterprise
> manager after upgrade.
> How can I fix it?
> Thanks,
> Tiger
>