Using Windows authentication to login to MS-SQL

[Diego Marrero]

Hi all.

I need to login to MS-SQL 2000 using Windows authentication, instead of the
regular SQL Server authentication in which the user supplies a user id and
password. How can I achieve this. I don't see how to configure this in a db
profile in the database painter.

TIA

Diego Marrero

[Jason 'Bug' Fenter]

I'm using PB8 and Ole-DB. On the "Security" tab, there's a field called
"Integrated Security" in which you would put the value "SSI" without the
quotes. For an ODBC connection, it's on the "Options" tab as a checkbox
with the same label. In your script, it's at the end of your DBParm.
SQLCA.DBParm += ",INTEGRATEDSECURITY='SSI'" // for Ole-DB and
SQLCA.DBParm += ",ConnectOption='SQL_INTEGRATED_SECURITY,SQL_IS_ON'" //
for ODBC

--
"Don't just fix; teach."

Some informative links:
news:news.announce.newusers
http://www.geocities.com/nnqweb/
http://www.catb.org/~esr/faqs/smart-questions.html
http://www.caliburn.nl/topposting.html
http://www.netmeister.org/news/learn2quote.html

[Sanjiv Das]

Here's a sample script that uses Windows Integrated Security to connect to
the pubs database on a local SQL Server:

// Profile Local MSSQL - Pubs - OLE DB
SQLCA.DBMS = "OLE DB"
SQLCA.AutoCommit = False
SQLCA.DBParm =
"PROVIDER='SQLOLEDB',DATASOURC­E='(local)',INTEGRATEDSECURITY­='SSPI',PROVIDERSTRING='databa­se=pubs'"

When creating the database profile, you need to set the integrated security
authentication provider (in this case SSPI).

Sanjiv.

"Diego Marrero" <di...@vegati.com> wrote in message
news:42b840a2@forums-1-dub...