Solved

Connect to the SQLServer 7

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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
delphi prevent click fast 2 219
Print Graphic and Text to Epson TM-T88v 12 259
Dynamically Created Query 3 55
Delphi: making a BW image transparent 10 39
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…
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…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

809 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