Re: Secondary Server Access to SQL after SP1 Upgrade

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

From: Jerseybeast (Jerseybeast_at_discussions.microsoft.com)
Date: 11/12/04 

Date: Fri, 12 Nov 2004 12:09:04 -0800

Kim, I'm not sure how to check this setting. It is supposed to set it up
that way, but may have missed that option. Stan, I've added the machines to
that group. I did try this before with a few other servers to no avail, but
perhaps it will work on these. Could it possibly be anything else that you
can think of?

"Stan White [MS]" wrote:

> Is the MP's machine account in the SiteSystemToSQL local group on the SQL
> Server?
>
> This article may or may not be of help wiht another known issue
> http://support.microsoft.com/default.aspx?scid=kb;en-us;829868
>
> --
> --
> Stan [MSFT]
> --
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> --
>
> "Kim Oppalfens" <kim@computacenter.nospam> wrote in message
> news:MPG.1bff168527a1f82798998f@msnews.microsoft.com...
> >
> > Is the database security mode set to Sql Server and windows?
> >
> > In article <EE630ADC-FC34-4B76-B17D-EC0451F0453C@microsoft.com>,
> > Jerseybeast@discussions.microsoft.com says...
> >> Hey Stan. Yes the problems continue. I upgraded the secondaries and the
> >> MP
> >> connectivity issues continue. I have not changed any of the accounts.
> >> Basically I am getting an error when the MP attempts to send Hardware
> >> Inventory. It is looking for Hardware Inventory Mapping from SQL and
> >> cannot
> >> connect to get that info. I've tried giving explicit rights on the DB to
> >> the
> >> SMS service account, still to no avail. Here is an excerpt from the
> >> MP_Hinv
> >> log. If anyone has any info on how to correct this please reply.
> >> Thanks.
> >>
> >>
> >> <![LOG[
> >> MPDB ERROR - CONNECTION PARAMETERS
> >> SQL Server Name : <servername>
> >> SQL Database Name : SMS_sitecode
> >> Integrated Auth : True
> >>
> >> MPDB ERROR - EXTENDED INFORMATION
> >> MPDB Method : Init()
> >> MPDB Method HRESULT : 0x80004005
> >> Error Description : Login failed for user '(null)'. Reason: Not
> >> associated
> >> with a trusted SQL Server connection.
> >> OLEDB IID : {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}
> >> ProgID : Microsoft OLE DB Provider for SQL Server
> >>
> >> MPDB ERROR - INFORMATION FROM DRIVER
> >> SQL Server Name : sql server name
> >> Native Error no. : 18452
> >> Error State : 1
> >> Class (Severity) : 14
> >> ]LOG]!><time="14:46:16.132+300" date="11-11-2004"
> >> component="MP_HinvEndpoint" context="Inv Task Execute" type="3"
> >> thread="7604"
> >> file="mpdbconnection.cpp:391">
> >> <![LOG[=======================================
> >> ]LOG]!><time="14:46:16.132+300" date="11-11-2004"
> >> component="MP_HinvEndpoint" context="Inv Task Execute" type="3"
> >> thread="7604"
> >> file="mpdbconnection.cpp:392">
> >> <![LOG[Hinv: IMPDBConnection::Init() for class
> >> failed.]LOG]!><time="14:46:16.132+300" date="11-11-2004"
> >> component="MP_HinvEndpoint" context="Inv Task Execute" type="3"
> >> thread="7604"
> >> file="hinvproc.cpp:150">
> >> <![LOG[Hinv: Error loading Inventory Mapping Table from the SQL data
> >> base!]LOG]!><time="14:46:16.132+300" date="11-11-2004"
> >> component="MP_HinvEndpoint" context="Inv Task Execute" type="3"
> >> thread="7604"
> >> file="hinvproc.cpp:531">
> >> <![LOG[Raising event:
> >> [SMS_CodePage(437), SMS_LocaleID(1033)]
> >> instance of MpEvent_CannotLoadHinvMap
> >> {
> >> ClientID = "GUID:DA775777-381B-4E2D-8F48-E4DB4D2E2C3A";
> >> DateTime = "20041111194616.148000+000";
> >> MachineName = "servername";
> >
> > --
> > Kim Oppalfens
> > Proud father of Lennart Oppalfens
> > Since 05/11/2004 08.53 GMT+1
>
>
>

Relevant Pages