Re: can't connect to sql server with domain users? Help....

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Martin Marinov (memmarinov_at_mecrossroad.bg)
Date: 06/07/04 

Date: Mon, 7 Jun 2004 09:22:17 +0300

If you can add these domain users to a domain group and then add rights for
this group and set the quthentication to be windows authentication

check if the group Domain Users has not been added with deny rights

Regards
Martin Mrinov

"Reza" <uwhockey@hotmail.com> wrote in message
news:F36E84E5-AC1A-4794-A3C9-94719351D9E1@microsoft.com...
> Well I thought I had resolved this, but looks like this company's policy
not allows sql authentication for the users, so I am back to step one.
> It works for aspnet user, however, there is a fix list of people that will
be able to access it, which they belong to a domain.
> and looks like I get the same message, login failed for user 'username'?
>
>
>
> ----- Martin Marinov wrote: -----
>
> Now when you change it to sql and windows authentication you have to
add the
> aspnet user to the database and use Integrated Security=True
>
> Regards
> Martin
>
> "Reza" <anonymous@discussions.microsoft.com> wrote in message
> news:EE20B721-6D8E-45F9-8216-826C58A3FADD@microsoft.com...
> > Martin,
> >> I get the same message when I tried your suggestion. Looks like it
is
> complaining that there is not a secure connection. How do I do this?
I
> changed the authenticaion to both, SQL and windows, but still the
same
> thing!
> >> Any idea?
> >> thanks,
> > reza
> >> ----- Martin Marinov wrote: -----
> >> Have you tried to connect with sql query analizer with your
username
> and
> > password
> > if you don't have query analizer try this:
> >> osql -U yourusername -P password -S servername -d database
> >> if this is failed to than you don't have sql authentication
to your
> server
> >> Regards
> > Martin
> >> "Reza" <anonymous@discussions.microsoft.com> wrote in message
> > news:ADFEE77D-2ADD-4ED9-AF72-4E6ACB7CD423@microsoft.com...
> >> Yes, I tried both of these, but no luck. I tried with domain name
> and
> > without. Tried the trusted connection, Integrated
Security=True, but
> still
> > the same problem - Login failed for user 'username'!
> >>> ----- Martin Marinov wrote: -----
> >>> are you sure that in the connection string the user is
> > DOMAINNAME\USERNAME ?
> >> have you tried by connection like this:
> >>> server=servername;database=databasename;Integrated
> Security=True
> >>> Regards,
> >> Martin
> >>>> "Reza" <uwhockey@hotmail.com> wrote in message
> >> news:B692F699-0808-4276-987D-CD866271C3E5@microsoft.com...
> >>> Hello,
> >>>> The project was working, where I had a domain user registered in
> > the
> >> database as a user, and I used that user to connect the
> datebase.
> > Everything
> >> was fine and it was working, then when I moved the project to
> the
> > production
> >> servers - database server and web server. Following that all
> the
> > users are
> >> failing to connct to database, getting this message:
> >>> "login failed for user 'username'"
> >>>> I am getting the user with property identity and it is
registered
> >> identically in the database user list.
> >>>> I am pretty much stuck and ran out of ideas to try. So a
> > resolution will
> >> be greatly apreciated.
> >>>> Thanks in advance,
> >>>> Reza
> >>>>

Relevant Pages

  • ADAM NULL nt bind...
    ... after adding my Domain Users group to my ADAM partitions ... anyone who does a NULL bind using a windows authentication ...
    (microsoft.public.windows.server.active_directory)
  • Requested registry access is not allowed. error
    ... i am trying to write to event log from my aspx application that is ... using windows authentication. ... All my users would be 'Domain Users'. ...
    (microsoft.public.dotnet.framework.aspnet.security)