[DUG] Delphi failed login to MSSQL

[Neven MacEwan]

John

Which version of mssql, I've never useed integrated security but a quick 
look at my 2005 shows a BUILTIN\Users login which is what it might use 
if you are not an admin

HTH

N
> 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
>
>
> _______________________________________________
> NZ Borland Developers Group - Delphi mailing list
> Post: delphi at delphi.org.nz
> Admin: http://delphi.org.nz/mailman/listinfo/delphi
> Unsubscribe: send an email to delphi-request at delphi.org.nz with Subject: unsubscribe
>
>
>