Re: error 5414 and 5415 after moving SQL database off-box
- From: "Steven D. Kaczmarek \(MS\)" <stevenka@xxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 23 May 2005 15:49:15 -0700
I suspect that permissions are part of the issue causing theis problem. I
would recommend that you take a look at the Scenarios and Procedures for SMS
2003: Maintenance, Backup and Recovery guide for steps for moving the SMS
site database, and the Scenarios and Procedures for SMS 2003: Security guide
for the permissions required to access the site database. Both guides can be
found on the SMS Product Documentation Web Site
http://www.microsoft.com/smserver/techinfo/productdoc.
I hope this helps!
Regards
Steven Kaczmarek
Technical Writing Lead
System Center Management -UA
425-707-3626
stevenka@xxxxxxxxxxxxxxxxxxxxx
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andre Fortin" <afortin@xxxxxxxxxxxxx> wrote in message
news:118sei7kqavmi0c@xxxxxxxxxxxxxxxxxxxxx
> Hi,
>
> I am trying to move my site database from a local MS SQL server to a
> remote MS SQL server. I think there are some permission issues, but I
> can't find where they would be. If I log into my SMS server with remote
> desktop and use the SMS console, everything works fine.
>
> From a remote system MMC however, it shows the site (I recreated the site
> connection MMC), but when I try to view something (Site Hierarchy,
> Packages, Collections, etc) it just shows the hourglass and never shows
> any of the objects. In the log files I have multiple entries saying the
> MP cant connect to the SQL server (errors 5414 and 5415, error messages at
> end of this message).
>
> I reset the site config from the CD installation process to point the SMS
> software to the new database location.
>
> If I revert to the old database location, it works right away. I am using
> a single site in a single AD domain (very simple setup).
>
> Another thing that might be of interest; the SQL server used to be a DC
> for a seperate domain. I demoted it, and joined it to this domain, so it
> may still have some information about the old domain causing conflicts..
> Any help would be appreciated. Thanks in advance
>
> Andre
>
>
> Error 5414:
> MP could not complete a task when processing Hinv.
>
> Check the logs for clues. Possible cause: Out of disk space.
> Solution: Increase the disk space, remove unprocessable files.
>
> Error 5415:
> MP cannot load the hardware inventory class mapping table when processing
> Hardware inventory.
>
> Possible cause: MP cannot communicate with the SQL data base.
> Solution: Check the network connection between MP and the machine hosting
> the SQL data base (likely the PSS).
>
> Possible cause: The SQL data base not initialized properly or corrupted.
> Solution: Check the data for consistency. Recreate the hardware definition
> tables if necessary.
>
>
>
.
- References:
- error 5414 and 5415 after moving SQL database off-box
- From: Andre Fortin
- error 5414 and 5415 after moving SQL database off-box
- Prev by Date: Re: rights delegation SMS 2003
- Next by Date: Re: SMS2003 Service Account Password Change
- Previous by thread: error 5414 and 5415 after moving SQL database off-box
- Next by thread: MS05-022
- Index(es):
Relevant Pages
|
