Solved

Connect to the SQLServer 7

Posted on 2000-02-24
3
430 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Delphi XE10 Round Image 2 160
select query - oracle 16 100
JAudiorecorder record freezing the app 29 76
firemonkey keyboard covers the controls 1 37
This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

829 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