I have a web server (IIS) on my PC with web pages that hit SQL Server, through ODBC.
I have SQL Server installed on a few different machines on our network.
The web pages on my server can hit all the different SQL Server machines,
except one. When the web pages try accessing that one server, I get an
error message stating
Login failed for user 'lenbean'. Reason: Not associated with a trusted SQL Server connection.
lenbean is registered as a system administrator on the server in question.
I checked the Server Properties, under the Security tab, to make sure it allows
both Windows and SQL Server authentication.
So, now I am stuck. I cannot figure out what is different about this computer
from all the others.
I hope someone has an answer to this one.
I'll be hoping, thanks.