Remote SMS_SITE_SQL_BACKUP component cannot be queried

myITforum.com Community Forum

Home Forums Blogs Live Support chat Search Articles Wiki FAQ Email Lists Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

All Forums RSS Feed Subscription:

Remote SMS_SITE_SQL_BACKUP component cannot be queried

View related threads: (in this forum | in all forums)

Logged in as: Guest

Printable Version

All Forums >> [Management Products] >> System Center Products >> System Center Configuration Manager >> Remote SMS_SITE_SQL_BACKUP component cannot be queried

Page: [1]

Message

<< Older Topic Newer Topic >>

Remote SMS_SITE_SQL_BACKUP component cannot be queried - 8/18/2008 3:13:55 PM

miltimj

Posts: 8
Score: 1
Joined: 2/21/2008
Status: offline

I have an SCCM SP1 site server with a remote SQL server running SQL 2005 SP2 that houses the site database. The site server's computer account is a local admin on the SQL server. The components installed successfully, but when I query the SMS_SITE_SQL_BACKUP component that resides on the SQL server, I get the error "Error communicating with component". I verified the service is running on the SQL server under LocalSystem.

When running the ConfigMgr backup maintenance task, the site backs up successfully, but it can't backup the database (due to the above).

Any ideas?

Post #: 1

RE: Remote SMS_SITE_SQL_BACKUP component cannot be queried - 8/21/2008 1:09:31 PM

gfleary

Posts: 40
Score: 5
Joined: 2/24/2004
Status: offline

Encountering this as well! Did you perform an upgrade from SMS 2003?

_____________________________

SCCM site info:
SCCM 2007 SP1 upgrade from SMS 2003 SP3
1 Central primary + 3 child primary + 2 Secondaries, 15K seats

(in reply to miltimj)

Post #: 2

RE: Remote SMS_SITE_SQL_BACKUP component cannot be queried - 8/24/2008 12:23:37 PM

miltimj

Posts: 8
Score: 1
Joined: 2/21/2008
Status: offline

No, it was a standard install from scratch. We're getting this in test and production, in four separate hierarchies (all of which are remote SQL servers).

The actual service works, i.e. it backs up the database if I start the SMS_SITE_BACKUP component (along with the site files, obviously).

(in reply to gfleary)

Post #: 3

Page: [1]

All Forums >> [Management Products] >> System Center Products >> System Center Configuration Manager >> Remote SMS_SITE_SQL_BACKUP component cannot be queried

Page: [1]

Jump to:

New Messages	No New Messages
Hot Topic w/ New Messages	Hot Topic w/o New Messages
Locked w/ New Messages	Locked w/o New Messages

Post New Thread

Reply to Message

Post New Poll

Submit Vote

Delete My Own Post

Delete My Own Thread

Rate Posts

0.203