invalid attribute/option identifier

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • René Pedersen

    invalid attribute/option identifier

    Hi
    I currently have a problem with registering a new server in my Enterprise
    Manager on a new PC.

    I need to connect to a MSSQL2K server on a windows 2003.
    My current PC is on the same LAN as the server and has no problem
    registering the server in Enterprise manager. This PC uses NT (about time I
    change :-)

    The new PC runs WIN2K. But this PC is on another LAN and has to access the
    server through a firewall. Port 1433 is open in the firewall.
    I use a Firewall-1 authentication agent to access the server.

    I use SQL authentificatio n to logon (sa account), I have checked that the
    new clients network libraries are the same version as the servers.
    In the client network Utility I have set up an alias with the server I want
    to access.

    The registration seems to access the SQL server, but comes out with an error
    stating: "invalid attribute/option identifier"

    When I search KB with this message, I get nothing. Did anyone in here
    experience anything like this? Any pointers to help me move on would be
    greatly appreciated.

    best regards
    René Pedersen


  • Simon Hayes

    #2
    Re: invalid attribute/option identifier


    "René Pedersen" <rpe@post6.tele .dk> wrote in message
    news:4107a915$0 $175$edfadb0f@d text01.news.tel e.dk...[color=blue]
    > Hi
    > I currently have a problem with registering a new server in my Enterprise
    > Manager on a new PC.
    >
    > I need to connect to a MSSQL2K server on a windows 2003.
    > My current PC is on the same LAN as the server and has no problem
    > registering the server in Enterprise manager. This PC uses NT (about time[/color]
    I[color=blue]
    > change :-)
    >
    > The new PC runs WIN2K. But this PC is on another LAN and has to access the
    > server through a firewall. Port 1433 is open in the firewall.
    > I use a Firewall-1 authentication agent to access the server.
    >
    > I use SQL authentificatio n to logon (sa account), I have checked that the
    > new clients network libraries are the same version as the servers.
    > In the client network Utility I have set up an alias with the server I[/color]
    want[color=blue]
    > to access.
    >
    > The registration seems to access the SQL server, but comes out with an[/color]
    error[color=blue]
    > stating: "invalid attribute/option identifier"
    >
    > When I search KB with this message, I get nothing. Did anyone in here
    > experience anything like this? Any pointers to help me move on would be
    > greatly appreciated.
    >
    > best regards
    > René Pedersen
    >
    >[/color]

    There are a few hits on Google which suggest reinstalling MDAC and/or the
    client tools, plus this post about a specific DLL:



    Simon


    Comment

    • René Pedersen

      #3
      Re: invalid attribute/option identifier

      Worked like a charm - thank you very much.

      regards
      René

      "Simon Hayes" <sql@hayes.ch > skrev i en meddelelse
      news:4107ea67$1 _2@news.bluewin .ch...[color=blue]
      >
      > "René Pedersen" <rpe@post6.tele .dk> wrote in message
      > news:4107a915$0 $175$edfadb0f@d text01.news.tel e.dk...[color=green]
      > > Hi
      > > I currently have a problem with registering a new server in my[/color][/color]
      Enterprise[color=blue][color=green]
      > > Manager on a new PC.
      > >
      > > I need to connect to a MSSQL2K server on a windows 2003.
      > > My current PC is on the same LAN as the server and has no problem
      > > registering the server in Enterprise manager. This PC uses NT (about[/color][/color]
      time[color=blue]
      > I[color=green]
      > > change :-)
      > >
      > > The new PC runs WIN2K. But this PC is on another LAN and has to access[/color][/color]
      the[color=blue][color=green]
      > > server through a firewall. Port 1433 is open in the firewall.
      > > I use a Firewall-1 authentication agent to access the server.
      > >
      > > I use SQL authentificatio n to logon (sa account), I have checked that[/color][/color]
      the[color=blue][color=green]
      > > new clients network libraries are the same version as the servers.
      > > In the client network Utility I have set up an alias with the server I[/color]
      > want[color=green]
      > > to access.
      > >
      > > The registration seems to access the SQL server, but comes out with an[/color]
      > error[color=green]
      > > stating: "invalid attribute/option identifier"
      > >
      > > When I search KB with this message, I get nothing. Did anyone in here
      > > experience anything like this? Any pointers to help me move on would be
      > > greatly appreciated.
      > >
      > > best regards
      > > René Pedersen
      > >
      > >[/color]
      >
      > There are a few hits on Google which suggest reinstalling MDAC and/or the
      > client tools, plus this post about a specific DLL:
      >
      >[/color]
      http://groups.google.com/groups?hl=e...ing.google.com[color=blue]
      >
      > Simon
      >
      >[/color]


      Comment

      Working...