Delphi2 + SQL Server 7.0

Having just upgraded our SQL server to version 7 from 6.5, I have taken the opportunity of providing access to the SQL server using NT logon verification only.  When my Delphi 2 application prompts for logon, it fails as it does not recognise the user as it appears to be looking for SQL authenticated user, even though the user is part of a valid NT group for that database.

Is it possible to use NT verification as part of the application or do I have to kludge it by setting up a new user with SQL authentication.

Regards


Ian  
IanternetAsked:
Who is Participating?
 
kretzschmarConnect With a Mentor Commented:
hi Ianternet,

if u use native sql-links, then
look at this from borland

---paste begin

Question and Answer Database

     FAQ: FAQ4731B - NT Authentication/Integrated security
Category: Database (MSSQL)
Platform: All-32Bit
 Product: All
Question:

If Integrated Security is enabled on my MSSQL sql server
how do I make the BDE MSSQL SQL Links driver use
Integrated Security?


Answer:

Leave user name and password blank in your application's
TDatabase and make sure that the USER NAME in the BDE
ALIAS and MSSQL driver settings is blank (used as a default
when an ALIAS parameter is blank).

7/13/99 10:13:32 AM

---paste end

meikl
0
 
IanternetAuthor Commented:
Fantastic....cheers Kretzschmar
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.