I have an ASP.NET Web Service and I’m trying to connect to a database on a remote machine (MS SQL Server on 2003 Windows Server machine). I added a ASPNET account to Windows and to SQL Server but it doesn’t work and gives me an exception: “Server doesn’t exist or access denied”.

At the same time I can easily connect to this database from a regular C# application.

Please help!!!