January 11, 2008 at 6:58 am
I have a Excel file with an ODBC-connection to a tabel in a SQL Server 2005 database. I use a trusted connection, because the users are in an Windows Domain. This works fine for all users except one.
Although he is known as an AD user, He doesn't log in on the domain (lets assume that this has to stay that way).
I have tried to give him rights (on SQL server) via his local login name, ie. \\[workstationname]\[username], but SQL server can't find him then.
How can I resolve this?
January 11, 2008 at 6:49 pm
If you're using mixed authentication, setup a login to use SQL Server authentication and use that for the ODBC connection on the client.
Another option is to create a local user account on the SQL server that has the same username and password as what's being used to logon to the client with. Then create a login in SQL that uses that local account.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply