SQL Caller Authentication APP

• carlos-345539

  Newbie

  Points: 9

  More actions

  July 5, 2006 at 3:00 pm

  #91138

  Hi,

               My SQL Server has a caller Authenticate, it offers the possibility to give a valid connection to those App

  whose want to connect my SQL Database Server.

   

  I´m trying to do this:

   

  I don´t know how to send in the connection string the AppName or AplicationID by ODBC to my SQL Database Server (in a VB Application called “CARLOS_INGRESOS”)

   

  I think that it looks like “APP= CARLOS_INGRESOS”, but I try without any success.

   

  I need the caller ID Application to give a valid connection to SQL,   by this way I´ ll have the possibility to authenticate

  all applications that I have register in my SQL Server and then,  if the APP has permission , then the users will authenticate

  by the app and then also by the Active Directory.

   

  Thanks for your help.

• vadba

  SSChampion

  Points: 11133

  More actions

  July 6, 2006 at 8:08 am

  #647758

  I use OLE DB, and use this connection string:

  PROVIDER='SQLOLEDB',DATASOURCE='MyServer',PROVIDERSTRING='database=MyDatabase;App=MyApp',IntegratedSecurity='SSPI'