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

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

Date: Fri, 4 Jun 2004 17:47:08 +0300

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

  • Re: Sql Server Login
    ... firstly I was under the impression SQL authenticaiton will be better ... But now I know windows authentication is recommended. ... Now my application is ready and talking to this database in MSDE. ...
    (microsoft.public.sqlserver.msde)
  • Re: Forms Authentication and DB
    ... this also explain how to have Forms Authentication ... Instead of connection to SQL server, ... I have my users and their passwords stored in an access database ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Synchronize users from AD to SQL-Server [password problem]
    ... users to the database is by setting it up with AD Integrated Authentication. ... If you want them to be the same, just utilize SQL ...
    (microsoft.public.win2000.active_directory)
  • RE: SQL server didnt exist or access denied
    ... Does the connect to SQL step return an error? ... I can't connect to our database from within my ... I have configured the webService to use "windows" authentication and to ...
    (microsoft.public.dotnet.framework.webservices)
  • Re: Use of Active Directory vs Database (e.g. SQL server)
    ... the main reason to use ADAM for authentication is that it ... If you go with SQL for the user store, you have to build all that. ... the app going to have its own SQL server database for OLTP ...
    (microsoft.public.windows.server.active_directory)