I hope this is the right forum, sorry if it isn't.
I have an Access (2000) form that calls SQL Server (2000) stored procedures. I pass in the connection string:
sqlConn.Open "DATA SOURCE =OurServer; USER=sa PASSWORD=pwd; INITIAL CATALOG=DatabaseName"
and this works fine
When I try to use integrated security instead:
sqlConn.Open "Data Source=OurServer; Integrated Security=SSPI; Initial Catalog=DatabaseName"
it fails on that line and throws an error:
Run time error '-2147217887 (80040e21)'
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done
Is this something to do with trying to use integrated security through Access? Specifically SSPI? I haven't managed to find a lot about it, so any help would be appreciated.
I have an Access (2000) form that calls SQL Server (2000) stored procedures. I pass in the connection string:
sqlConn.Open "DATA SOURCE =OurServer; USER=sa PASSWORD=pwd; INITIAL CATALOG=DatabaseName"
and this works fine
When I try to use integrated security instead:
sqlConn.Open "Data Source=OurServer; Integrated Security=SSPI; Initial Catalog=DatabaseName"
it fails on that line and throws an error:
Run time error '-2147217887 (80040e21)'
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done
Is this something to do with trying to use integrated security through Access? Specifically SSPI? I haven't managed to find a lot about it, so any help would be appreciated.