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