I can successfully retreive data from SQL Server 2000 via IIS 5.0 on my personal webserver but when I attempt to use our corporate web server running IIS 6.0 I get an "HTTP 500- Internal Server Error" message.

I know IIS 6.0 is much more secure but I can't figure out which settings to change to allow this to work with SQL Server.

Need to see a more descriptive error, click on internet options, goto advanced and deselect the show friendly error messages box. Then refresh the page and post the result back here again, might be able to help...

Regards
Vince

Visit my home: www.chez-vince.com

VBScript | ASP | HTML | SQL | Oracle | Hosting

I get the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'MOC\Rmwadminservice7'.

/svba/inandoutitems.asp, line 8

Any help you can provide on this would be greatly appreciated.

I resolved this issue by setting up a SQL Server Login for the service account.

Thanks for getting me started in the right direction.