Solved

Connect to the SQLServer 7

Posted on 2000-02-24
3
424 Views
Last Modified: 2013-11-23
I have a client program witch connect to the SQLServer 7 only when the user account is in SQL-Server Authentication.. when I set an account as Windows NT Authentication the Delphi give me this message:
   Unknown User Name or Password
   Login Failed User 'username'
   Login incorrect
   Alias: 'AliasName'

But my SQL Client access normally the user account.. in both situation... !!!!

Somebody can help me?

Sorry my poor english, I live in Brazil :) hehehe

Thank you

PS: Im using Delphi4, BDE 5.01
0
Comment
Question by:Vanclecio
  • 2
3 Comments
 
LVL 27

Accepted Solution

by:
kretzschmar earned 50 total points
ID: 2554376
hi Vanclecio,

from my paq, 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
 

Author Comment

by:Vanclecio
ID: 2554489
Thank you very much for your answer..
that help me a lot :)
0
 
LVL 27

Expert Comment

by:kretzschmar
ID: 2554506
glad to helped you, Vanclecio
good luck again

meikl ;-)
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Suggested Solutions

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
This video discusses moving either the default database or any database to a new volume.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

746 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now