dbTalk Databases Forums  

problem with SQL 2000 Enterprise Manager display

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss problem with SQL 2000 Enterprise Manager display in the microsoft.public.sqlserver.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
JD
 
Posts: n/a

Default problem with SQL 2000 Enterprise Manager display - 01-10-2006 , 09:57 AM






Hello,
I'm having problems when using SQL 2000 Enterprise manager and viewing
the Distribution Agents via Enterprise Manager. I have this SQL server setup
for replication with a local a distribution database. When I click on the
'Distribution Agents' folder, under 'Replication Monitor' I can't see the
agents. It doesn't matter which Enterprise Manager from what SQL server that
I use, I still can't see the distribution agents for this one server. So,
that leads me to think there is some configuration setting for that server
that is not allowing any Enterprise Mananger's replication monitor to view
those agents.

Is this correct?

If so, how do I fix it?

thanks,


Reply With Quote
  #2  
Old   
Michael Cheng [MSFT]
 
Posts: n/a

Default RE: problem with SQL 2000 Enterprise Manager display - 01-10-2006 , 10:53 PM






Hi,

Does your replication works swimmingly as expected?
What kind of replication you are creating?
What's the startup account for your SQL Server Agent?
If you create another new transactional replication, is it possible for you
to reproduce this behavior?


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.




Reply With Quote
  #3  
Old   
JD
 
Posts: n/a

Default RE: problem with SQL 2000 Enterprise Manager display - 01-11-2006 , 09:04 AM



Morning Michael,
Yes, replication works as it should. We are doing transactional replication
at the database level. SQL Server agent runs as a Domain account which also
runs the SQL Server service. Each and every new database replication has the
same problems with in the 'Distribution Agents' folder. Just to repeat my
self, this is the only folder that does not show the agents. All other
folders shows the differents agents.

So, any other thoughts as to why this one folder does not show it's agents?

thanks,
JD

"Michael Cheng [MSFT]" wrote:

Quote:
Hi,

Does your replication works swimmingly as expected?
What kind of replication you are creating?
What's the startup account for your SQL Server Agent?
If you create another new transactional replication, is it possible for you
to reproduce this behavior?


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.





Reply With Quote
  #4  
Old   
Michael Cheng [MSFT]
 
Posts: n/a

Default RE: problem with SQL 2000 Enterprise Manager display - 01-13-2006 , 05:46 AM



Hi John,

Really strange issue since other folder displays correctly.
If you register the SQL Server in another machine, will it show the Agent
correctly?


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.


Reply With Quote
  #5  
Old   
JD
 
Posts: n/a

Default RE: problem with SQL 2000 Enterprise Manager display - 01-13-2006 , 04:28 PM



Hello Michael,
No unfortuanly it doesn't. I can register that one server from any other
server but it still won't display that one folder. And it is only the one
folder that won't display.

Any thoughts? A possible registry entry that is messed up? A bit turned off
somewhere?

Thanks,
JD

"Michael Cheng [MSFT]" wrote:

Quote:
Hi John,

Really strange issue since other folder displays correctly.
If you register the SQL Server in another machine, will it show the Agent
correctly?


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.



Reply With Quote
  #6  
Old   
Michael Cheng [MSFT]
 
Posts: n/a

Default RE: problem with SQL 2000 Enterprise Manager display - 01-15-2006 , 11:36 PM



Hi John,

For now, I am afraid we will have to debug the application internal and
this job had to be done by contacting Microsoft Customer Service and
Support. Therefore, we probably will not be able to resolve the issue
through the newsgroups. If the issue is urgent, I recommend that you open a
Support incident with Microsoft Customer Service and Support so that a
dedicated Support Professional can assist with this case. If you need any
help in this regard, please let me know.

For a complete list of Microsoft Customer Service and Support phone
numbers, please go to the following address on the World Wide Web:
http://support.microsoft.com/directory/overview.asp

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.

This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/tec...rview/40010469
Others: https://partner.microsoft.com/US/tec...pportoverview/

If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.

This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/tec...rview/40010469
Others: https://partner.microsoft.com/US/tec...pportoverview/

If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.


Reply With Quote
  #7  
Old   
JD
 
Posts: n/a

Default RE: problem with SQL 2000 Enterprise Manager display - 01-16-2006 , 03:51 PM



Michael,
Thanks for your help. I'll have to log a support call then to get it
resolved.

Joe

"Michael Cheng [MSFT]" wrote:

Quote:
Hi John,

For now, I am afraid we will have to debug the application internal and
this job had to be done by contacting Microsoft Customer Service and
Support. Therefore, we probably will not be able to resolve the issue
through the newsgroups. If the issue is urgent, I recommend that you open a
Support incident with Microsoft Customer Service and Support so that a
dedicated Support Professional can assist with this case. If you need any
help in this regard, please let me know.

For a complete list of Microsoft Customer Service and Support phone
numbers, please go to the following address on the World Wide Web:
http://support.microsoft.com/directory/overview.asp

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.

This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/tec...rview/40010469
Others: https://partner.microsoft.com/US/tec...pportoverview/

If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.

This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/tec...rview/40010469
Others: https://partner.microsoft.com/US/tec...pportoverview/

If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.



Reply With Quote
  #8  
Old   
Michael Cheng [MSFT]
 
Posts: n/a

Default RE: problem with SQL 2000 Enterprise Manager display - 01-16-2006 , 11:43 PM



Hi Joe,

Thanks for your understanding, once more. Your cooperation is appreciated,
and will result in a more efficient troubleshooting process.


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.