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..."Test 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

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..."Test 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

re: MS Access Connection Window in ADP

"Lauren Quantrell" <laurenquantrell@hotmail.com> wrote in message
news:47e5bd72.0404131452.57d5ce2@posting.google.co m...[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..."Test 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.

re: MS Access Connection Window in ADP

"Eric Kant" <erik@kant.com> wrote in message
news:c5iui0$ptf$1@hercules.btinternet.com...[color=blue]
> "Lauren Quantrell" <laurenquantrell@hotmail.com> wrote in message
> news:47e5bd72.0404131452.57d5ce2@posting.google.co m...[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..."Test 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

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.com> wrote in message news:<c5iui0$ptf$1@hercules.btinternet.com>...[color=blue]
> "Lauren Quantrell" <laurenquantrell@hotmail.com> wrote in message
> news:47e5bd72.0404131452.57d5ce2@posting.google.co m...[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..."Test 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]

re: MS Access Connection Window in ADP

"Lauren Quantrell" <laurenquantrell@hotmail.com> wrote in message
news:47e5bd72.0404151459.72c3ab0a@posting.google.c om...[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