• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 436
  • Last Modified:

Connect to the SQLServer 7

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
Vanclecio
Asked:
Vanclecio
  • 2
1 Solution
 
kretzschmarCommented:
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
 
VanclecioAuthor Commented:
Thank you very much for your answer..
that help me a lot :)
0
 
kretzschmarCommented:
glad to helped you, Vanclecio
good luck again

meikl ;-)
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now