SQL Server and IIS 6.0
I am having trouble accessing my MSDE instance that I have on Windows Server 2003 box.
The error message I get is :-
Exception Details: System.Data.SqlClient.SqlException: Login failed for user '[Domain]\[MachineName]$'.
I was initially getting an error that Network Service was could not log in. I fixed this by adding the NETWORK USER to the access list in MSDE and the required database. On doing this I now get the current error. I tried adding this user/machine account in the same way as all others that I had done but this does not work.
Does anyone know where there is a guide or instructions on how to use MSDE/SQL Server 2000 on Windows Server 2003/IIS 6.0 ?