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
John
any reason you are using integrated securtiy? I notice in your
connection string you have User ID=sa, so why not use SQL server security?
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:
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
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
If you are using integrated security then the user needs a server login in
the form Domain\UserName or if not on a domain then ServerName\UserName (it
is possible that BUILTIN\Users works too, tbh I have never played with
that).
If the user is already able to connect to the server using
Hi guys,
The recent email from Embarcadero on ToolCloud may have been a bit out of
the blue. If anyone wants clarification of the points in the email, please
email me off list and I will be happy to give you a call to explain them.
If you didn't get the email, let me know also - we will see what