RE: SBS NTBackup VSS Errors

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hello David,

Thank you for kind update.

After analyze your MPS report, I think the issue is exactly with MSSQL$ACT7
instance. As I listed in my last reply, this is not a default MSDE instance
and it is probably introduced by third-party software. As this software is
not configured to allow SYSTEM account to authenticate, then this issue
appeared.

At the current status, you could either ignore this issue if it does not
affect your normal backup. If you do need to resolve this issue, you may
need to consult the software manufactory and check with them if this
instance could be configured to add System account as administrator and
what the proper steps they suggest to add this account.

Generally, we could use the following steps to add a account into default
database, however, please consult your software vendor for availability of
below steps on their database before you perform them. Otherwise, you may
take your own risk for any data lose on this instance

1. Open SQL Enterprise manager
2. Right click your server and click New SQL server Reiteration.
3. Register MSSQL$ACT7
4. Expand Security->Logins and add "NT AUTHORITY\SYSTEM" to allow access to
this database.
5. Restart the service and test again.

If it could not resolve the issue, you may still need to consult the
database manufactory for more information.

Thank you for your time and effort.

Hope that helps.

Thanks and have a nice day!

Best regards,

Terence Liu(MSFT)

Microsoft CSS Online Newsgroup Support

Get Secure! - www.microsoft.com/security

=====================================================
This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx

When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.

Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.

For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.

Any input or comments in this thread are highly appreciated.
=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
| Thread-Topic: SBS NTBackup VSS Errors
| thread-index: AcdrPRYbUyLUnTdxQVuEof/H89Ae1g==
| X-WBNR-Posting-Host: 86.140.126.71
| From: =?Utf-8?B?RGF2aWQ=?= <David@xxxxxxxxxxxxxxxxxxxxxxxxx>
| References: <E95C5D9A-A2FE-457B-8940-0F455806C2EC@xxxxxxxxxxxxx>
<jtiriJIZHHA.2372@xxxxxxxxxxxxxxxxxxxxxx>
<D589BD0C-5ED9-4B94-9922-95BE28DF1A36@xxxxxxxxxxxxx>
<f5d2qnQZHHA.4088@xxxxxxxxxxxxxxxxxxxxxx>
| Subject: RE: SBS NTBackup VSS Errors
| Date: Tue, 20 Mar 2007 15:14:11 -0700
| Lines: 238
| Message-ID: <9F5A287A-93E7-41C6-82F1-BE943C6AC9A9@xxxxxxxxxxxxx>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2757
| Newsgroups: microsoft.public.windows.server.sbs
| Path: TK2MSFTNGHUB02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.windows.server.sbs:24133
| NNTP-Posting-Host: tk2msftsbfm01.phx.gbl 10.40.244.148
| X-Tomcat-NG: microsoft.public.windows.server.sbs
|
| Terence
|
| I've checked the settings for the SQL instances and the only one I can't
log
| on to is the ACT! 8.0. I get an invalid logon attempt for
| server\administrator. All the others I can connect to and they are all
using
| the local system account.
|
| I've emailed the .cab file to your directly.
| --
| David @ Solsletta
|
|
| "Terence Liu [MSFT]" wrote:
|
| > Hello David,
| >
| > Thank you for kind update.
| >
| > I was just writing to say that I hope everything is going well.
| >
| > Please do not hesitate to let me know if there's anything else I can do
for
| > you.
| >
| > Thank you and have a nice day,
| >
| > Best regards,
| >
| > Terence Liu(MSFT)
| >
| > Microsoft CSS Online Newsgroup Support
| >
| > Get Secure! - www.microsoft.com/security
| >
| > =====================================================
| > This newsgroup only focuses on SBS technical issues. If you have issues
| > regarding other Microsoft products, you'd better post in the
corresponding
| > newsgroups so that they can be resolved in an efficient and timely
manner.
| > You can locate the newsgroup here:
| > http://www.microsoft.com/communities/newsgroups/en-us/default.aspx
| >
| > When opening a new thread via the web interface, we recommend you check
the
| > "Notify me of replies" box to receive e-mail notifications when there
are
| > any updates in your thread. When responding to posts via your
newsreader,
| > please "Reply to Group" so that others may learn and benefit from your
| > issue.
| >
| > Microsoft engineers can only focus on one issue per thread. Although we
| > provide other information for your reference, we recommend you post
| > different incidents in different threads to keep the thread clean. In
doing
| > so, it will ensure your issues are resolved in a timely manner.
| >
| > For urgent issues, you may want to contact Microsoft CSS directly.
Please
| > check http://support.microsoft.com for regional support phone numbers.
| >
| > Any input or comments in this thread are highly appreciated.
| > =====================================================
| >
| > This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| > --------------------
| > | Thread-Topic: SBS NTBackup VSS Errors
| > | thread-index: AcdkhGu5FPE9u8sCTuef9nQSPtchAg==
| > | X-WBNR-Posting-Host: 86.148.21.212
| > | From: =?Utf-8?B?RGF2aWQ=?= <David@xxxxxxxxxxxxxxxxxxxxxxxxx>
| > | References: <E95C5D9A-A2FE-457B-8940-0F455806C2EC@xxxxxxxxxxxxx>
| > <jtiriJIZHHA.2372@xxxxxxxxxxxxxxxxxxxxxx>
| > | Subject: RE: SBS NTBackup VSS Errors
| > | Date: Mon, 12 Mar 2007 01:57:10 -0700
| > | Lines: 135
| > | Message-ID: <D589BD0C-5ED9-4B94-9922-95BE28DF1A36@xxxxxxxxxxxxx>
| > | MIME-Version: 1.0
| > | Content-Type: text/plain;
| > | charset="Utf-8"
| > | Content-Transfer-Encoding: 7bit
| > | X-Newsreader: Microsoft CDO for Windows 2000
| > | Content-Class: urn:content-classes:message
| > | Importance: normal
| > | Priority: normal
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2757
| > | Newsgroups: microsoft.public.windows.server.sbs
| > | Path: TK2MSFTNGHUB02.phx.gbl
| > | Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.windows.server.sbs:22269
| > | NNTP-Posting-Host: tk2msftsbfm01.phx.gbl 10.40.244.148
| > | X-Tomcat-NG: microsoft.public.windows.server.sbs
| > |
| > | Terence
| > |
| > | Many thanks for the prompt response. I'll try this when I'm next
on-site
| > | (later this week) and I'll post back to.
| > | --
| > | David @ Solsletta
| > |
| > |
| > | "Terence Liu [MSFT]" wrote:
| > |
| > | > Hello David,
| > | >
| > | > Thanks for posting here.
| > | >
| > | > From your problem description, I understand this issue to be: the
| > | > performance report gives the error message regarding the VSS.
| > | >
| > | > 0x80040e4d stands for Database authentication failure. This error
event
| > | > means that 'NT AUTHORITY\SYSTEM' is not able to logon to the
SQL/MSDE
| > | > database when performing backup operation.
| > | >
| > | > To check the instances you have installed, please open the services
| > console
| > | > by running services.msc command. If you have SQL server installed
with
| > | > default instance, you may have following entries in the service
console
| > | > along with running account.
| > | >
| > | > MSSQL$MSFW - Running on System Account
| > | > MSSQL$SBSMonitoring - Running on System Account
| > | > MSSQL$SHAREPOINT - Running on System account
| > | > MSSQLSERVER - Running on the account you configure manually. By
default
| > | > domain administrator.
| > | >
| > | > Please check these services are running and stable and you could
use
| > the
| > | > following method to test the connectivity.
| > | >
| > | > OSQL -E -S ServerName\InstanceName
| > | >
| > | > For Example: OSQL -E -S SBS2k3\SHAREPOINT.
| > | >
| > | > If you could connect successfully, you then will get a "1>" prompt.
| > | >
| > | > You could also send me the MPS report and I can also check if for
you
| > | >
| > | > a. Visit
| > | >
| >
http://download.microsoft.com/download/b/b/1/bb139fcb-4aac-4fe5-a579-30b0bd9
| > | > 15706/MPSRPT_NETWORK.EXE. to download the file.
| > | > b. Run the MPSRPT_NETWORK.EXE on the server box.
| > | > c. Wait for 10~15 minutes.
| > | > d. Open Windows explorer, navigate to
| > | > %SYSTEMROOT%\MPSReports\Network\Reports\cab\
| > | > e. Send the .cab file directly to me at ericsun@xxxxxxxxxxxxx
| > | >
| > | > If you have any questions or concerns related to this issue, please
let
| > me
| > | > know.
| > | >
| > | > I appreciate your time and look forward to hearing from you.
| > | >
| > | > Thanks and have a nice day!
| > | >
| > | > Best regards,
| > | >
| > | > Terence Liu(MSFT)
| > | >
| > | > Microsoft CSS Online Newsgroup Support
| > | >
| > | > Get Secure! - www.microsoft.com/security
| > | >
| > | > =====================================================
| > | > This newsgroup only focuses on SBS technical issues. If you have
issues
| > | > regarding other Microsoft products, you'd better post in the
| > corresponding
| > | > newsgroups so that they can be resolved in an efficient and timely
| > manner.
| > | > You can locate the newsgroup here:
| > | > http://www.microsoft.com/communities/newsgroups/en-us/default.aspx
| > | >
| > | > When opening a new thread via the web interface, we recommend you
check
| > the
| > | > "Notify me of replies" box to receive e-mail notifications when
there
| > are
| > | > any updates in your thread. When responding to posts via your
| > newsreader,
| > | > please "Reply to Group" so that others may learn and benefit from
your
| > | > issue.
| > | >
| > | > Microsoft engineers can only focus on one issue per thread.
Although we
| > | > provide other information for your reference, we recommend you post
| > | > different incidents in different threads to keep the thread clean.
In
| > doing
| > | > so, it will ensure your issues are resolved in a timely manner.
| > | >
| > | > For urgent issues, you may want to contact Microsoft CSS directly.
| > Please
| > | > check http://support.microsoft.com for regional support phone
numbers.
| > | >
| > | > Any input or comments in this thread are highly appreciated.
| > | > =====================================================
| > | >
| > | > This posting is provided "AS IS" with no warranties, and confers no
| > rights.
| > | >
| > | > --------------------
| > | > | Thread-Topic: SBS NTBackup VSS Errors
| > | > | thread-index: AcdkJ4P4xt6Ul4RYQFinpjGUeJDuFA==
| > | > | X-WBNR-Posting-Host: 86.148.21.212
| > | > | From: =?Utf-8?B?RGF2aWQ=?= <David@xxxxxxxxxxxxxxxxxxxxxxxxx>
| > | > | Subject: SBS NTBackup VSS Errors
| > | > | Date: Sun, 11 Mar 2007 14:52:08 -0700
| > | > | Lines: 12
| > | > | Message-ID: <E95C5D9A-A2FE-457B-8940-0F455806C2EC@xxxxxxxxxxxxx>
| > | > | MIME-Version: 1.0
| > | > | Content-Type: text/plain;
| > | > | charset="Utf-8"
| > | > | Content-Transfer-Encoding: 7bit
| > | > | X-Newsreader: Microsoft CDO for Windows 2000
| > | > | Content-Class: urn:content-classes:message
| > | > | Importance: normal
| > | > | Priority: normal
| > | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2757
| > | > | Newsgroups: microsoft.public.windows.server.sbs
| > | > | Path: TK2MSFTNGHUB02.phx.gbl
| > | > | Xref: TK2MSFTNGHUB02.phx.gbl
microsoft.public.windows.server.sbs:22206
| > | > | NNTP-Posting-Host: tk2msftsbfm01.phx.gbl 10.40.244.148
| > | > | X-Tomcat-NG: microsoft.public.windows.server.sbs
| > | > |
| > | > | This item hasn't attracted any attention so I've reposted it:
| > | > |
| > | > | Does anyone know what causes this, please? It doesn't seem to
| > prevent
| > | > the
| > | > | backup just an irritation in the Performance Report?
| > | > |
| > | > | VSS 6013 27/02/2007 21:00 4 *
| > | > | Sqllib error: OLEDB Error encountered calling
| > IDBInitialize::Initialize.
| > | > hr
| > | > | = 0x80040e4d. SQLSTATE: 42000, Native Error: 18456 Error state:
1,
| > | > Severity:
| > | > | 14 Source: Microsoft OLE DB Provider for SQL Server Error
message:
| > Login
| > | > | failed for user 'NT AUTHORITY\SYSTEM'
| > | > | --
| > | > | David @ Solsletta
| > | > |
| > | >
| > | >
| > |
| >
| >
|

.

Relevant Pages

  • RE: SBS 2003 error during step 5
    ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... >check http://support.microsoft.com for regional support phone numbers. ... >>You can refer to the following suggestions to try to resolve the issue: ...
    (microsoft.public.windows.server.sbs)
  • Re: Access to external FTP server
    ... Microsoft CSS Online Newsgroup Support ... | box in the FTP protocol definition was selected in the ISA 2004 ... |> I will try my best to work with you to resolve this issue. ...
    (microsoft.public.windows.server.sbs)
  • RE: RWW Remote Web Workplace Multiple Logins
    ... Thanks for letting us know that my solution help you resolve the issue, ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... this issue could be caused by the authentication ...
    (microsoft.public.windows.server.sbs)
  • RE: SBS 2003 error during step 5
    ... Let"s perform the following tests to try to resolve the OWA issue: ... Clear the IIS server files follow these steps: ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • Re: All external access broken after upgrading to ISA 2004
    ... I hope to see you again in the newsgroup. ... Microsoft CSS Online Newsgroup Support ... RWW and other web sites that does not match the ... To resolve this issue, we must ...
    (microsoft.public.windows.server.sbs)