Re: Help: Login failed for User ???

www.connectionstrings.com is your friend.

Since you are using Windows Auth, your connectionstring should look like
this:

"Integrated Security=SSPI;Data Source=BACKUPSVR\BKUPEXEC;Initial
Catalog=NF_Inventory"

or

"Server=BACKUPSVR\BKUPEXEC;Database=NF_Inventory;Trusted_Connection=True"

"Michael" <Michael@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5F42A0FD-E734-4746-BA87-EC33DC4DD8A0@xxxxxxxxxxxxxxxx
Hi Everyone,
After looking back at the message, I thought that the connection string
might be a good thing to add to the list. The connect string is as
follows:
"User=Christian.Gaut Password=??? packet size=4096;integrated
security=SSPI;data source=BACKUPSVR\BKUPEXEC;persist security
info=False;initial catalog=NF_Inventory"

Now I've only put the userid and password here for testing only. I can
leave
that in, and login into my machine(using my ID) and it will work. Any
ideas.
Thanks
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: Help: Login failed for User ???
    ... string, but it was hidden in a few SQLConnection objects that where used ... server is setup to use Windows Auth. ... database and have given the user access to the database for the app. ... Login failed for user Christian.Gaut ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Using Windows Auth in Sharepoint and ASPx pages question
    ... there different sharepoint pages when they login. ... IsinRole method and then they get prompted with a LOGON windows Auth popup ... sharepoint page they get prompted with another LOGON windows Auth popup. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Error: Login failed for user ????
    ... Michael wrote: ... Login failed for user Christian.Gaut ... If I login using my userid and password, the program works fine, but if I login as the user and try it again, same thing happens. ... 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). ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Windows authentication with ability to override
    ... btw - you cannot use Windows auth *and* AD membership - i guess you are using Windows auth when you user don't have to login. ... We are using windows authentication and an Active Directory membership ...
    (microsoft.public.dotnet.framework.aspnet.security)