|
Home > Archive > Microsoft Content Management Server > December 2005 > Difference between sdo imported and database restore?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Difference between sdo imported and database restore?
|
|
| fcukoffspam@yahoo.co.nz 2005-12-14, 5:54 pm |
| Hi all,
I am wondering if there is anything different in terms on data carried
accross from a sdo import and database restore. We have three sites and
one site is massive - mainly documents. It imposes problems when
packaging up the sdo as the server runs out of memory when backing up
the site from the root site channel.
We either have to perform the sdo in many small chunks which will take
hours or simply restore the whole CMS database to a new server.
Which is the correct way? At the moment we are restoring a database
because it's easier and faster but we have noticed that some weird
authentication logs in the Event Viewer. It will attempt to
authenticate the old machine's anonymous user account. I have
configured the SCA to disallow all guest on site and allow disable it
at the IIS level, yet the Security logs still report:
note: IUSR_WN0NTWEB06 is the anonymous user account from the old
machine
WN0NTCMSWEB01 is the new machine name
------------------------------------------------------------------------------------------------------------
Event Type: Failure Audit
Event Source: Security
Event Category: Account Logon
Event ID: 680
Date: 12/15/2005
Time: 9:13:51 AM
User: NT AUTHORITY\SYSTEM
Computer: WN0NTCMSWEB01
Description:
Logon attempt by: MICROSOFT_AUTHENTICATION_PACKAGE_V1_
0
Logon account: IUSR_WN0NTWEB06
Source Workstation: WN0NTCMSWEB01
Error Code: 0xC0000064
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
------------------------------------------------------------------------------------------------------------
Event Type: Failure Audit
Event Source: Security
Event Category: Logon/Logoff
Event ID: 529
Date: 12/15/2005
Time: 9:13:51 AM
User: NT AUTHORITY\SYSTEM
Computer: WN0NTCMSWEB01
Description:
Logon Failure:
Reason: Unknown user name or bad password
User Name: IUSR_WN0NTWEB06
Domain: WN0NTCMSWEB01
Logon Type: 8
Logon Process: Advapi
Authentication Package: Negotiate
Workstation Name: WN0NTCMSWEB01
Caller User Name: NETWORK SERVICE
Caller Domain: NT AUTHORITY
Caller Logon ID: (0x0,0x3E4)
Caller Process ID: 3748
Transited Services: -
Source Network Address: -
Source Port: -
------------------------------------------------------------------------------------------------------------
Any help guys?
Cheers,
Nathan
| |
| Stefan [MSFT] 2005-12-15, 2:50 am |
| Hi Nathan,
to move a database to a new server you should use backup and restore.
Only if parts of the site need to be migrated or moved you should use site
deployment.
About the security logs below: please verify again if the IUSR account is
configured in the SCA or somewhere in the IIS metabase.
Cheers,
Stefan
--
This posting is provided "AS IS" with no warranties, and confers no rights
New to MCMS?
Check out this book: Building Websites Using MCMS: http://tinyurl.com/6zj44
Check out the new book as well: Advanced MCMS development:
http://tinyurl.com/8ugwj
----------------------
<fcukoffspam@yahoo.co.nz> wrote in message
news:1134591508.429224.45850@g43g2000cwa.googlegroups.com...
> Hi all,
>
> I am wondering if there is anything different in terms on data carried
> accross from a sdo import and database restore. We have three sites and
> one site is massive - mainly documents. It imposes problems when
> packaging up the sdo as the server runs out of memory when backing up
> the site from the root site channel.
>
> We either have to perform the sdo in many small chunks which will take
> hours or simply restore the whole CMS database to a new server.
>
> Which is the correct way? At the moment we are restoring a database
> because it's easier and faster but we have noticed that some weird
> authentication logs in the Event Viewer. It will attempt to
> authenticate the old machine's anonymous user account. I have
> configured the SCA to disallow all guest on site and allow disable it
> at the IIS level, yet the Security logs still report:
>
> note: IUSR_WN0NTWEB06 is the anonymous user account from the old
> machine
> WN0NTCMSWEB01 is the new machine name
>
>
> ------------------------------------------------------------------------------------------------------------
> Event Type: Failure Audit
> Event Source: Security
> Event Category: Account Logon
> Event ID: 680
> Date: 12/15/2005
> Time: 9:13:51 AM
> User: NT AUTHORITY\SYSTEM
> Computer: WN0NTCMSWEB01
> Description:
> Logon attempt by: MICROSOFT_AUTHENTICATION_PACKAGE_V1_0
> Logon account: IUSR_WN0NTWEB06
> Source Workstation: WN0NTCMSWEB01
> Error Code: 0xC0000064
>
>
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
> ------------------------------------------------------------------------------------------------------------
> Event Type: Failure Audit
> Event Source: Security
> Event Category: Logon/Logoff
> Event ID: 529
> Date: 12/15/2005
> Time: 9:13:51 AM
> User: NT AUTHORITY\SYSTEM
> Computer: WN0NTCMSWEB01
> Description:
> Logon Failure:
> Reason: Unknown user name or bad password
> User Name: IUSR_WN0NTWEB06
> Domain: WN0NTCMSWEB01
> Logon Type: 8
> Logon Process: Advapi
> Authentication Package: Negotiate
> Workstation Name: WN0NTCMSWEB01
> Caller User Name: NETWORK SERVICE
> Caller Domain: NT AUTHORITY
> Caller Logon ID: (0x0,0x3E4)
> Caller Process ID: 3748
> Transited Services: -
> Source Network Address: -
> Source Port: -
>
> ------------------------------------------------------------------------------------------------------------
>
>
>
>
> Any help guys?
>
> Cheers,
>
> Nathan
>
| |
| fcukoffspam@yahoo.co.nz 2005-12-15, 8:49 pm |
| Thanks Stefan,
I have another problem which may be attributable to the problems in the
error logs. I have a News type posting containing an image placeholder.
I have a homepage that gathers the 10 most recent news postings with a
thumbnail image from the Image Placeholder in the News Postings.
I understand from Chester Ragel's blog posting (MCMS Resource Stream -
http://chestermr.blogspot.com/2005_...mr_archive.html) that
there are two methods to retreive the image depending if you loaded it
from the Resource Gallery or locally. Therefore I have 2 aspx pages -
ThumbnailGen.aspx that accepts the GUID of the Resource and
ThumbnailLocalGen.aspx that accepts the URL of the image src by query
string. Both aspx pages do the same job - proportionately shrinking the
original image in an 80 x 80 pixel but performs the access method in
different ways according to Chester's blog.
Accessing it through the image via the Resource Gallery works fine.
However when it attempts to access an image that was uploaded locally,
I get a 'The remote server returned an error: (401) Unauthorized.' The
network creditentials passed belongs to the Administrator CMS role and
the aspx page itself has Windows Integrated Security. When I remove
this and enable only Anonymous Access, I get an 'Access Denied' error.
The IIS log shows that this is a 401 error too.
The weird thing is that this works fine on my local development machine
but when the code is migrated to a server environment, images will not
appear successfully.
I've search the groups on these 401 errors and they have not provided
me with much help.
Any suggestions guys?
Cheers,
Nathan
| |
| Stefan [MSFT] 2005-12-16, 7:48 am |
| Hi,
you need to pass network credentials with appropriate permissions with the
HttpRequest.
401 means that either no credentials have been sent or that the provided
credentials do not have sufficient priviledges.
The credentials need to be of a user that has subscriber rights on the
posting.
Cheers,
Stefan
--
This posting is provided "AS IS" with no warranties, and confers no rights
New to MCMS?
Check out this book: Building Websites Using MCMS: http://tinyurl.com/6zj44
Check out the new book as well: Advanced MCMS development:
http://tinyurl.com/8ugwj
----------------------
<fcukoffspam@yahoo.co.nz> wrote in message
news:1134692143.547046.87220@g44g2000cwa.googlegroups.com...
> Thanks Stefan,
>
> I have another problem which may be attributable to the problems in the
> error logs. I have a News type posting containing an image placeholder.
> I have a homepage that gathers the 10 most recent news postings with a
> thumbnail image from the Image Placeholder in the News Postings.
>
> I understand from Chester Ragel's blog posting (MCMS Resource Stream -
> http://chestermr.blogspot.com/2005_...mr_archive.html) that
> there are two methods to retreive the image depending if you loaded it
> from the Resource Gallery or locally. Therefore I have 2 aspx pages -
> ThumbnailGen.aspx that accepts the GUID of the Resource and
> ThumbnailLocalGen.aspx that accepts the URL of the image src by query
> string. Both aspx pages do the same job - proportionately shrinking the
> original image in an 80 x 80 pixel but performs the access method in
> different ways according to Chester's blog.
>
> Accessing it through the image via the Resource Gallery works fine.
> However when it attempts to access an image that was uploaded locally,
> I get a 'The remote server returned an error: (401) Unauthorized.' The
> network creditentials passed belongs to the Administrator CMS role and
> the aspx page itself has Windows Integrated Security. When I remove
> this and enable only Anonymous Access, I get an 'Access Denied' error.
> The IIS log shows that this is a 401 error too.
>
> The weird thing is that this works fine on my local development machine
> but when the code is migrated to a server environment, images will not
> appear successfully.
>
> I've search the groups on these 401 errors and they have not provided
> me with much help.
>
> Any suggestions guys?
>
> Cheers,
>
> Nathan
>
|
|
|
|
|