> I've been working on a WebService project with a local
> datasource. I moved the datasource to be another server.
> So now IIS and SQL Server are on different machines. And
> now i perpetually get:
> SQL Server does not exist or access denied
> Things I've tried:
> 1. Changed the <processModel> username and password
> values to:
> A. System, AutoGenerated
> B. MyUsername, MyPassword
> C. DomainAdmin, DomainAdminPassword
> D. LocalUserWithSameNameAsRemoteUser, passwordDitto
> 2. Changed to Windows Integrated Authentiaction
> 3. Used he servers IP Address instead of its name
> And many more rediculous things I won't even mention. All
> to no avail.
> And through all this I can access the same database via
> Visual Studio 2003 Server Explorer and Enterprise manager
> and Query yser and Profiler (even thought the same
> domain accounts, using Run as...., that fail from ASP).
> I've read a number of atricals say that the ASPNET
> account is local and can't authenticate remotly but
> changing the processModel info to a domain user has no
> effect. I've even been sure to restart IIS each time I
> change the values.
> I have .NET Framework 1.1 and but I'm not using the
> encrypted registry option offered for extra security.
> And I dont want to have to connect thought a COM+
> This has been driving me nuts. Any help is greatly
> Thanks in advance
> Jan Bannister