Re: Decode an error message

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Eric (EricHigg_at_gmail.com)
Date: 01/18/05

  • Next message: Eric: "Re: Decode an error message" 
    Date: 18 Jan 2005 13:32:52 -0800

    I am getting a similar error from the collection evaluator: Microsoft
    SQL Server reported SQL message 207, severity 16:
    [42S22][207][Microsoft][ODBC SQL Server Driver][SQL Server]Invalid
    column name 'ChassisTypes00'.

    I've ruled out legacy clients, and mof issues. Not all collections are
    having errors, in fact the majority are ok. There doesn't seem to be a
    reason I can see that makes any collection stand out from another.

    Any help is much appreciated.

    Thanks,
    -Eric

    Stan White [MS] wrote:
    > What SMS component is generating this error?
    > Do you ahve the entire SQL statement from the component log? - is it
    trying
    > to insert a discovery record, run a query, etc?
    >
    > --
    > --
    > Stan [MSFT]
    > --
    > --
    > This posting is provided "AS IS" with no warranties, and confers no
    rights.
    > --
    > --
    >
    > "Jaye" <jaye.roberts@specializedloanservicing.com> wrote in message
    > news:u7Di0uGLEHA.1484@tk2msftngp13.phx.gbl...
    > > Hello, I am getting a lot of these errors on my SMS server. It
    has to do
    > > with its connection to our SQL server but I have verified that it
    can
    > > connect and that there are enough user connections available. Has
    anyone
    > > seen this before or know what else I can try to fix it? Here is
    the error
    > > message...
    > >
    > > Microsoft SQL Server reported SQL message 207, severity 16:
    > > [42S22][207][Microsoft][ODBC SQL Server Driver][SQL Server]Invalid
    column
    > > name 'Last_Logon_User_Name0'.
    > >
    > > Thank you,
    > >
    > > ~Jaye
    > >
    > >

  • Next message: Eric: "Re: Decode an error message"

    Relevant Pages

    • Re: Decode an error message
      ... SQL Server reported SQL message 207, ... I've ruled out legacy clients, ... > What SMS component is generating this error? ... >> connect and that there are enough user connections available. ...
      (microsoft.public.sms.setup)
    • Re: Decode an error message
      ... What SMS component is generating this error? ... Do you ahve the entire SQL statement from the component log? ... > with its connection to our SQL server but I have verified that it can ... > connect and that there are enough user connections available. ...
      (microsoft.public.sms.setup)
    • RE: Explain
      ... Can any one let me know the difference between user connections and not the ... number of users that currently are connected to SQL Server. ... > Server affects its performance, you may want to keep an eye on this counter. ...
      (microsoft.public.sqlserver.clients)
    • Re: Enterprise manager security?
      ... using a special account. ... permissions) for user connections to the server running SQL Server. ... Security can be implemented and secured based on NT groups. ...
      (microsoft.public.sqlserver.security)
    • Explain
      ... Counter Name: SQL Server General Statistics: User Connections ... Prev by Date: ...
      (microsoft.public.sqlserver.clients)