[DUG] Delphi failed login to MSSQL

[chen qing]

Hello,

If I understand your question correctly, just remove "User ID = sa;" from
your connection string, you've enabled integrated security so logins for
"non-admin" users should be fine - this is based on the assumption that your
SQL Server knows the given user id provided via using integrated
authentication

Hope this help.

Cheers..


2010/3/25 John Bird <johnkbird at paradise.net.nz>

> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20100325/1d1b50c5/attachment.html