Re: VB6 Using ADO to Login to SQL Server using NT Authentication

Not sure this helps alot. I think that I need to setup a group in the
Active Directory that is the login on the SQL Server for the database
needed. Then, place the user logins into that group. Then the
connection string that needs NT Athentication should see that both the
SQL Login and NT Login are in the group that SQL Server security login
specifies. Not sure if that is the method but would like verification.

THanks..
Mark J. McGinty wrote:
"jmassa01" <joemanelli@xxxxxxx> wrote in message
news:1159055097.932324.129070@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have an application that uses a secure SQL Server Database with a
UserID/Password that is different from the NT (XP) Workstation
Login/Password on the Domain. The SQL Server is setup for NT
Authentication Only. Simply stated, I need the APPLICATION to login
with its ADO connection string using its own USERID/PASSWORD to the SQL
Server to access a database regardless of the NT Login. The
application has its own user security. This application will be used on
CITRIX or Terminal Server by several users. Do I have to use ODBC or
something else?

You cannot pass credentials for NT Auth in the connection string. To
achieve this your app will need to impersonate an NT account that is valid
on the SQL Server box, which means you will have to store credentials for
that NT account in the app or in the registry (or otherwise make them
available to it at runtime.)

A less elegant but [perhaps] equally workable alternative would be to run
your app from the RUNAS command, or with the Run As checkbox in the shortcut
checked.

The key is that the ADO objects must be running under an NT user context
that has access to the SQL Server.


-Mark


Need Help ASAP. Thanks.


.

Relevant Pages

  • Re: Login failed for user NT AUTHORITYANONYMOUS LOGON
    ... Do you want the Windows App ... This means that each application user will have to have a SQL Server login ... > Web service on a w2K3 server, using integrated authentication, web.config ...
    (microsoft.public.dotnet.distributed_apps)
  • Re: Securing Connection string
    ... How do I assign rights to the SQL Server ... instance my app will be using and how to I assign the rights to my database ... recommended to avoid the users from having to login again and again (once on ... Andrea Montanari ...
    (microsoft.public.sqlserver.msde)
  • Re: Is there any way to prevent hacker trying to guess sa password?
    ... What is the migration path like to SQL Server 2005? ... How is installation and setup? ... I setup my own SQL Server accounts and use those. ... You can include the login (such as sa, admin, ...
    (microsoft.public.sqlserver.security)
  • Re: Yet another not a trusted connection problem
    ... Your SQL Server is setup to only accept NT Integrated logins, ... Trying to login with sa will always fail. ... > On my client machine i have installed the mssql client tools, ...
    (microsoft.public.sqlserver.connect)
  • Re: Login problem
    ... that MSDN article was exactly what I needed. ... you would not want to use a UID parameter, that is for SQL Server ... My app requires a user to login to the database. ...
    (microsoft.public.sqlserver.security)