Hello,<br><br>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<br>
<br>Hope this help.<br><br>Cheers..<br><br><br><div class="gmail_quote">2010/3/25 John Bird <span dir="ltr"><<a href="mailto:johnkbird@paradise.net.nz">johnkbird@paradise.net.nz</a>></span><br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
I have a connection to a MSSQL database that fails if the logged in user is<br>
a non-administrative user on Windows XP<br>
<br>
This is the connection string:<br>
<br>
DefaultConnectionString:='Provider=SQLOLEDB.1;'<br>
+'Integrated Security=SSPI;Persist Security Info=False;'<br>
+'User ID=sa;Initial Catalog=mobile_xx;'<br>
+'Data Source=localhost;Use Procedure for Prepare=1;'<br>
+'Auto Translate=True;Packet Size=4096;'<br>
+'Workstation ID=DELPHI-207;'<br>
+'Use Encryption for Data=False;'<br>
+'Tag with column collation when possible=False';<br>
<br>
Same non-admin user can run MSSQL management studio but also cannot connect<br>
to the database.<br>
<br>
I think the problem is using Windows authentication for the connection - a<br>
non-admin user is not enough?<br>
<br>
Anyone have ideas on what settings need to be changed to allow logins for<br>
non-admin users? This connection could be made read-only if that makes it<br>
possible to connect. (Note - other programs can access the same database<br>
as a non-admin user).<br>
<br>
John<br>
<br>
<br>
_______________________________________________<br>
NZ Borland Developers Group - Delphi mailing list<br>
Post: <a href="mailto:delphi@delphi.org.nz">delphi@delphi.org.nz</a><br>
Admin: <a href="http://delphi.org.nz/mailman/listinfo/delphi" target="_blank">http://delphi.org.nz/mailman/listinfo/delphi</a><br>
Unsubscribe: send an email to <a href="mailto:delphi-request@delphi.org.nz">delphi-request@delphi.org.nz</a> with Subject: unsubscribe<br>
</blockquote></div><br>