Delphi2 + SQL Server 7.0

Posted on 2000-02-28
Medium Priority
Last Modified: 2010-04-04
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.


Question by:Ianternet
LVL 27

Accepted Solution

kretzschmar earned 400 total points
ID: 2565182
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

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


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


Author Comment

ID: 2565216
Fantastic....cheers Kretzschmar

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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.

Join & Write a Comment

Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
This is an update to some code that someone else posted on Experts Exchange. It is an alternate approach, I think a little easier to use, & makes sure that things like the Task Bar will update.
How to fix display issue, screen flickering issue when I plug in power cord to the machine. Before I start explaining the solution lets check out once the issue how it looks like after I connect the power cord. most of you also have faced this…
Watch the video to know the simple way to remove or recover or reset lost or forgotten passwords of Outlook PST file. With Kernel Outlook Password Recovery tool such operation is very easy to perform. It is a freeware with limitation to use with 500…
Suggested Courses

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question