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