Mixed authentication means that you can connect with windows user accounts and with sql server logins, Windows authentication only allows windows user accounts. The user 'sa' is a sql server builtin login, which means that you can't connect to a sql server configured with windows authentication.
Futhermore, the 'sa' user is standard configured as the administration account for maintaining the databases. Using this account from within an application is not a good choice (to say the least). If you want to use a sql server login for your application, it's best you create a new login and only grant the privileges needed for your application.
I created another sql server login.
The question is :
Why does this sql server login work from my application with
"Windows Authentication' SQL-server configuration and doesn't
work with Mixed Mode Authentication?
It have to be vice versa, no?
Enterprise manager ->Security->Logins-> new login (with checkbox -SQL server authentication)
I connect to Sql server from Delphi application (BDE or ADO - both work
We also checked in registry for 'Logintype' value - it's OK.
And within delphi? With a connection string or a udl file? How is this configured? We use Delphi and ADO with an udl file. In this udl file you specify the user that is connecting. The user specified has to be the sql server user and not set it to Windows authentication.
I have two Delphi applications.
One is in Delphi7 (ADO connection) and you are true.
I used the connection string with 'NT integrated security' . Thank you.
My another old Delphi4 application uses BDE alias for connection with
SQL server user name and password and it works !
We only use mixed mode databases. When I create an alias of type 'mssql' i cannot login with a windows account but I can login with sql server login. When I use the type 'sql server' (through odbc) i can login with both windows as sql server login. That's all i can make of it. Hope it helps.