sql server connect: Hi All

I am running a website on one server and need to be able to connect to
SQL 2000 on another server. When I try to connect to the SQL server
in an asp.net application I get the following error:

Login failed for user 'Domain\Server$'

How do I configure SQL to allow the other IIS server to connect.


TIA

Tony,
please can you post up your connectionstring that the SQLConnection object
is using. Also, do you want to use SQL authentication or Trusted, and what
is your SQL Server configured to allow - Mixed or Windows.
TIA,
Paul Ibison

From the error message it appears that the machine account is attempting to
connect to SQL Server, not a user account. You can get the connection to
work by adding a login for the machine account: Domain\server$. This is a
AD accounta nd many application use it to connect to SQL Server. It is
basically the machine system account.

Rand
This posting is provided "as is" with no warranties and confers no rights.