How to configure Windows user accounts for ODBC network with NT authentication?
- by Ian Mackinnon
I'm trying to create a connection to an SQL Server database from the ODBC Data Source Administrator using "Windows NT authentication using the network login ID". Both server and client are running Windows XP.
It appears that any account with administrator privileges can add the data source on the server*, though connection attempts from the client result in error messages that suggest it is trying to authenticate using a guest account.
I found a Microsoft support page that says:
For SQL Server...: connect using the impersonated user account.
But it doesn't offer advice about how to do that.
How do I impersonate a user account on the server?
or (since it sounds like that would lead to an unfortuante squashing of privileges and loss of accountability):
How do I give an account on the client privileges on the server database and then ensure the client attempts authentication with the privileged account and not with a guest account?
I'm aware that I'm providing rather sparse information. This is because I'm in unfamiliar territory and don't know what's pertinent. I'll attempt to add any requested information as quickly as possible.
*I'm planning on tightening privileges straight after I get it working as it stands.