Re: Help: Login failed for User ???

Glad to hear it!

"Michael" <Michael@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:33FF6156-E393-4CE8-978B-2F63A5E28124@xxxxxxxxxxxxxxxx
I just wanted to let you all know that I found the problem. It was a
connect
string, but it was hidden in a few SQLConnection objects that where used
on
several screens. It now works as expected. Thanks again for all the help.
Michael


"Michael" wrote:

Please Help me. I've got a .Net 2003 program that attaches to a SQL
Server
machine and I'm getting the above error when a user tries to log in. The
SQL
server is setup to use Windows Auth. and I have added the new user to the
database and have given the user access to the database for the app. But
everytime I try and login using this users ID, I always get the error:
Login failed for user Christian.Gaut
If I login using my userid and password, the program works fine, but if I
login (into windows) as the user and try it again, same thing happens. I
tried putting the userid and password(windows) in the connect string, but
that is not helping either. Now, in the user properties of the database,
it
won't allow me to change the password for the user (I guess cause I'm
using
Windows Auth). So should I leave the password blank in the connect
string?
Any help would be great, thanks again for taking the time to stop by.
Michael




.

Relevant Pages

  • Re: Help: Login failed for User ???
    ... I tried using the new version of the connect string and have the same ... Only the database that needs accessing is checked for permission. ... I login Windows, Run application, I can get ... Since you are using Windows Auth, ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Macro to VBA
    ... cause sUser is string and ID is a autonumber. ... Database Administrator ... Static iLogAttempts as Integer 'Number of Login Attempts ... MsgBox "You do not have access to this database..." ...
    (microsoft.public.access.modulesdaovba)
  • Re: GetPassword from different databases?
    ... I do not think you need to retrieve the password again from the database. ... Microsoft.Web.Services.Security.UsernameToken) As String Implements ... Regarding dynamic connection strings - you can append a custom soap header ... > string is hard coded in the Web.config file which exposes the Login ...
    (microsoft.public.dotnet.framework.webservices.enhancements)
  • Re: Cant open database in browser control
    ... private string FindIIdentity() ... string returnValue = string.Empty; ... AUTHORITY\NETWORK SERVICE login to my database under the Security/Users ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: dynamic connection string?
    ... I've implemented my solution for this scenario by puting my connection ... string in database and prior to login to my portal, ... to get authenticated and retrieve the connection string. ...
    (microsoft.public.dotnet.framework.aspnet.webcontrols)
Loading