0

I'm in the process of converting an old application to work with SQL Server instead of hundreds of Paradox DB files.

I'm using ODBC and most of the stuff is working.

However I do have a problem.

In some forms, is asking for password. I've double checked the TDatabase and TTable components, added USER NAME=sa and PASSWORD=****** to the Parameters and turned OFF the LoginPrompt

What's missing?

Is there any other way to initialize just once all the 5 databases and don't ever ask for password again?!

I've checked other questions here at StackOverflow, but didn't find a suitable one :(

Thank you

Johan
  • 74,508
  • 24
  • 191
  • 319
Filipe YaBa Polido
  • 1,656
  • 1
  • 17
  • 39
  • One word of advice: ***never ever*** use the `sa` account for your app - not even in development / testing! – marc_s Nov 29 '12 at 21:44
  • It's a VM development dedicated machine, I haven't bothered to create a new user :) – Filipe YaBa Polido Nov 29 '12 at 21:54
  • Just don't do it - one day, somehow, in the hectic of your job, you'll forget to change it and leak out your `sa` account's password (and I'm guessing you're using the same `sa` password on multiple systems - right? Thought so...). It **will** happen - trust me. So just don't do it - ***NEVER*** ... – marc_s Nov 29 '12 at 21:57

1 Answers1

1

You can use SQL Server "Windows Authentication" mode. You can assign the database permissions to a Windows Domain group/groups or individual Windows users. In this case the users will be automatically authenticated to the databases without prompts.

cha
  • 10,301
  • 1
  • 18
  • 26