[DUG] Delphi failed login to MSSQL

[John Bird]

I have a connection to a MSSQL database that fails if the logged in user is 
a non-administrative user on Windows XP

This is the connection string:

    DefaultConnectionString:='Provider=SQLOLEDB.1;'
    +'Integrated Security=SSPI;Persist Security Info=False;'
    +'User ID=sa;Initial Catalog=mobile_xx;'
    +'Data Source=localhost;Use Procedure for Prepare=1;'
    +'Auto Translate=True;Packet Size=4096;'
    +'Workstation ID=DELPHI-207;'
    +'Use Encryption for Data=False;'
    +'Tag with column collation when possible=False';

Same non-admin user can run MSSQL management studio but also cannot connect 
to the database.

I think the problem is using Windows authentication for the connection - a 
non-admin user is not enough?

Anyone have ideas on what settings need to be changed to allow logins for 
non-admin users?  This connection could be made read-only if that makes it 
possible to connect.   (Note - other programs can access the same database 
as a non-admin user).

John