SQL DATABASE ACCESS

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: walter_in_sa (walter_in_sa_at_discussions.microsoft.com)
Date: 08/25/04 

Date: Wed, 25 Aug 2004 05:25:05 -0700

I want my vb6 app to access SQL in the following way:

I've set up a special domain user that is also the dbo of the db I want to
access. This user id and password is included in the connection string that I
use to connect to the db.

Even though I'm connecting with this, I still get the error
Login failed for user 'DomainName\username'." (This is the windows user name)
It's not using the windows user to connect to the db, so why am I getting
this error?

The windows user hasn't got a login to the db.

Relevant Pages

  • Re: SQL DATABASE ACCESS
    ... To connect using the domain OS user you have to first login in to the ... > I want my vb6 app to access SQL in the following way: ... This user id and password is included in the connection string ... > The windows user hasn't got a login to the db. ...
    (microsoft.public.sqlserver.server)
  • Re: Cant connect to DB
    ... Switch off anonymous access on Directory Security tab ... Windows user name and password. ... Sandy ... >have you tried with this connection string? ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Dynamic Access in a Web based application
    ... thanks for ur valuable help but still I cant achieve the purpose. ... does that mean that it still depends on the windows user. ... problems with the connection string I have used. ... > analysis service n according to his role when ever he requests the data ...
    (microsoft.public.sqlserver.olap)
  • Re: Trying to find the currently logged on user
    ... >If you are supplying the Sql username and password in the connection string, ... Nope - it's using impersonation. ... "integrated security=SSPI" and it will then use the Windows user ...
    (microsoft.public.dotnet.framework.adonet)