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@delphi.org.nz
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to delphi-requ...@delphi.org.nz with Subject:
unsubscribe
