Re: SQL connection
From: William \(Bill\) Vaughn (billvaRemoveThis_at_nwlink.com)
Date: 09/04/04
- Next message: Jack: "Re: Can I format the field to 2 decimal places in my sql"
- Previous message: David Hodgkins: "Re: SQL connection"
- In reply to: David Hodgkins: "Re: SQL connection"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 3 Sep 2004 19:16:37 -0700
Include "Trusted_Connection=Yes;" or "Integrated Security=SSPI" instead of
"UID=xx;PWD=yy;" in the ConnectionString.
-- ____________________________________ William (Bill) Vaughn Author, Mentor, Consultant Microsoft MVP www.betav.com Please reply only to the newsgroup so that others can benefit. This posting is provided "AS IS" with no warranties, and confers no rights. __________________________________ "David Hodgkins" <DavidHodgkins@discussions.microsoft.com> wrote in message news:1A4A8658-0B58-4E68-9493-7B4E0C6B604D@microsoft.com... > So What would the ADO connection string be if using Windows > authentication? > > David > > "Andrea Montanari" wrote: > >> hi Leszek, >> "Leszek Gruszka" <legrooch@poczta.onet.pl> ha scritto nel messaggio >> news:u$6uCIYkEHA.3608@TK2MSFTNGP09.phx.gbl... >> > I'm creating an aplication to write and read data from database. >> > I need to use user authentication, not build-in account name and >> > password. >> > I can't hold this parameters in file. What i must do? Maybe set in SQL >> > for >> > SQL authentication? >> > >> > Sorry if it's on wrong newsgroup. >> >> if you use Windows (trusted) authentication, you only need to grant the >> account (better, the winnt group the account is member of) adeguate >> privileges both on the instance (grant login) and on the db and relative >> objects (grant user's access)... you do not need to pass futher info at >> application login... and you do not need to store user's information.. >> if you resort on SQL Server authentication, you have the same needs to be >> fullfilled, grant the sql user adeguate privileges both on the instance >> (grant login) and on the db and relative objects (grant user's access) >> you can even not store his credentials, but you are then required to >> prompt >> him for that info at application (better, at database) login... >> it's up to your design... >> -- >> Andrea Montanari (Microsoft MVP - SQL Server) >> http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org >> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1 >> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual >> interface) >> --------- remove DMO to reply >> >>
- Next message: Jack: "Re: Can I format the field to 2 decimal places in my sql"
- Previous message: David Hodgkins: "Re: SQL connection"
- In reply to: David Hodgkins: "Re: SQL connection"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
