Multi-server administration & MSDE

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Multi-server administration & MSDE

Author

Topic

samrat
Yak Posting Veteran

94 Posts

Posted - 2003-08-07 : 20:59:59

Can we use Multi-server administration functionality with MSDE. The scenario
being Master server (Standard Edition 2000) and Target Server(MSDE 2000)

Thanks in advance

Samrat

jasper_smith
SQL Server MVP & SQLTeam MVY

846 Posts

Posted - 2003-08-08 : 12:28:30

Don't think so. You would get the following error :
Error 14539: Only a Standard or Enterprise edition of SQL Server can be
enlisted into an MSX.

HTH
Jasper Smith

0x73656c6563742027546f6f206d7563682074696d65206f6e20796f75722068616e6473203f27

shsmonteiro
Constraint Violating Yak Guru

290 Posts

Posted - 2003-08-10 : 21:37:49

Jasper,

quote:

0x73656c6563742027546f6f206d7563682074696d65206f6e20796f75722068616e6473203f27

Is this the entry in SQL Server Transaction Log Data Row for this post?

Sérgio Monteiro
Trust in no Oracle

samrat
Yak Posting Veteran

94 Posts

Posted - 2003-08-11 : 03:01:44

Thanks for the reply Jasper,

I got the same error while trying to implement the scenario. So is it a bug? or MSDE is just *Not* designed to suppport it ?

Thanks,
Samrat

Samrat

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-08-11 : 12:38:06

quote:
Originally posted by samrat

I got the same error while trying to implement the scenario. So is it a bug? or MSDE is just *Not* designed to suppport it ?

"Only a Standard or Enterprise edition of SQL Server can be
enlisted into an MSX."

MSDE does not support multi-server administration. MSDE Is not standard or enterprise edition.

Tara

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources