Browser -> IIS/ASP -> SQL Server config

[dave755]

I am trying to configure an in-building intranet system with multiple servers and am not getting it right. Here is the situation:

The user sits at a browser and accesses an ASP page.

The ASP is being hosted by a server running IIS on [red]Windows Server 2003[/red].

The VBScript code in the ASP uses a DNS to reference a SQL Server that is running on a second (separate) server, which is running [red]Windows 2000 Server[/red].

Here is the error reported to the browser:

Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

When I test the DNS on the IIS server, it checks out OK.

What do I need to do to make this run?

Dave Gee

 

[DreXor]

look on msdn.microsoft.com for more details on this ... i cant rememebr the EXACT accounts to add, but you need to add to the web server, and to the SQL server the IWAM?? accounts to each machine so that when they try to access each other, for data or results being returned, that they have permissions/bridgeway to go thru.

DreX
aKa - Robert

 

[jmaddone]

Are you using SQL Server Users or Windows Authentication?