MS Access Connection Window in ADP

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Lauren Quantrell
    #1

    MS Access Connection Window in ADP

    I select the server name.
    I select the database on the server.
    I select the option: Use Windows NT Integrated Security.
    tada...It works fine. Test connection sings.

    Instead, I select: Use a specific user name and password.
    I enter my user name
    I enter my password.
    bonggggg..."Tes t connection failed because of an error in initializing
    provider. Login failed for user "myname".
    I enter my user name and password a couple dozen times to make sure I
    didn't typo it.
    bonggggg...

    What's up with that?
    lq
    Tags: None
    • (Pete Cresswell)
      #2
      Re: MS Access Connection Window in ADP

      RE/[color=blue]
      >I select the server name.
      >I select the database on the server.
      >I select the option: Use Windows NT Integrated Security.
      >tada...It works fine. Test connection sings.
      >
      >Instead, I select: Use a specific user name and password.
      >I enter my user name
      >I enter my password.
      >bonggggg..."Te st connection failed because of an error in initializing
      >provider. Login failed for user "myname".
      >I enter my user name and password a couple dozen times to make sure I
      >didn't typo it.
      >bonggggg...
      >
      >What's up with that?
      >lq[/color]

      Are you running a firewall like Norton's?
      That's what nailed my for a few days until somebody finally suggested
      that I check to see if the firewall was intercepting the logon request.

      Something about another entity that's not named SQL Server but works on it's
      behalf...
      --
      PeteCresswell

        Comment

        • Eric Kant
          #3
          Re: MS Access Connection Window in ADP

          "Lauren Quantrell" <laurenquantrel l@hotmail.com> wrote in message
          news:47e5bd72.0 404131452.57d5c e2@posting.goog le.com...[color=blue]
          > I select the server name.
          > I select the database on the server.
          > I select the option: Use Windows NT Integrated Security.
          > tada...It works fine. Test connection sings.
          >
          > Instead, I select: Use a specific user name and password.
          > I enter my user name
          > I enter my password.
          > bonggggg..."Tes t connection failed because of an error in initializing
          > provider. Login failed for user "myname".
          > I enter my user name and password a couple dozen times to make sure I
          > didn't typo it.
          > bonggggg...
          >
          > What's up with that?
          > lq[/color]

          The server may have been set up to only allow Windows authentication, which
          should make the installation more secure. If you have access to Enterprise
          Manager and sufficient privellages you can right-click the server and edit
          the SQL Server registration properties.

          But you should have a sensible reason to allow Mixed Mode Authentication.



            Comment

            • Eric Kant
              #4
              Re: MS Access Connection Window in ADP


              "Eric Kant" <erik@kant.co m> wrote in message
              news:c5iui0$ptf $1@hercules.bti nternet.com...[color=blue]
              > "Lauren Quantrell" <laurenquantrel l@hotmail.com> wrote in message
              > news:47e5bd72.0 404131452.57d5c e2@posting.goog le.com...[color=green]
              > > I select the server name.
              > > I select the database on the server.
              > > I select the option: Use Windows NT Integrated Security.
              > > tada...It works fine. Test connection sings.
              > >
              > > Instead, I select: Use a specific user name and password.
              > > I enter my user name
              > > I enter my password.
              > > bonggggg..."Tes t connection failed because of an error in initializing
              > > provider. Login failed for user "myname".
              > > I enter my user name and password a couple dozen times to make sure I
              > > didn't typo it.
              > > bonggggg...
              > >
              > > What's up with that?
              > > lq[/color]
              >
              > The server may have been set up to only allow Windows authentication,[/color]
              which[color=blue]
              > should make the installation more secure. If you have access to[/color]
              Enterprise[color=blue]
              > Manager and sufficient privellages you can right-click the server and edit
              > the SQL Server registration properties.
              >
              > But you should have a sensible reason to allow Mixed Mode Authentication.[/color]



              Unreserved apology for the horrendous misspelling of "privileges ".

              Erik


                Comment

                • Lauren Quantrell
                  #5
                  Re: MS Access Connection Window in ADP

                  Erik,
                  I checked and it's set up to accept SQL Server and Windows Authentication.
                  lq


                  "Eric Kant" <erik@kant.co m> wrote in message news:<c5iui0$pt f$1@hercules.bt internet.com>.. .[color=blue]
                  > "Lauren Quantrell" <laurenquantrel l@hotmail.com> wrote in message
                  > news:47e5bd72.0 404131452.57d5c e2@posting.goog le.com...[color=green]
                  > > I select the server name.
                  > > I select the database on the server.
                  > > I select the option: Use Windows NT Integrated Security.
                  > > tada...It works fine. Test connection sings.
                  > >
                  > > Instead, I select: Use a specific user name and password.
                  > > I enter my user name
                  > > I enter my password.
                  > > bonggggg..."Tes t connection failed because of an error in initializing
                  > > provider. Login failed for user "myname".
                  > > I enter my user name and password a couple dozen times to make sure I
                  > > didn't typo it.
                  > > bonggggg...
                  > >
                  > > What's up with that?
                  > > lq[/color]
                  >
                  > The server may have been set up to only allow Windows authentication, which
                  > should make the installation more secure. If you have access to Enterprise
                  > Manager and sufficient privellages you can right-click the server and edit
                  > the SQL Server registration properties.
                  >
                  > But you should have a sensible reason to allow Mixed Mode Authentication.[/color]

                    Comment

                    • Fletcher Arnold
                      #6
                      Re: MS Access Connection Window in ADP


                      "Lauren Quantrell" <laurenquantrel l@hotmail.com> wrote in message
                      news:47e5bd72.0 404151459.72c3a b0a@posting.goo gle.com...[color=blue]
                      > Erik,
                      > I checked and it's set up to accept SQL Server and Windows Authentication.
                      > lq[/color]

                      And can you see that login using Enterprise Manager (look under
                      security>logins )? If so, you should be able to start Enterprise Manager
                      with that login and password and if that login has permissions for the
                      database in question it should be able to read tables or run stored
                      procedures.

                      Fletcher


                        Comment

                        Previous template Next
                        Working...