IIS6 - Connection to database failed?

[Olli1009]

Hi guys,

I have an ASP page that pulls data from an SQL Server database. The SQL server is on a different machine than the IIS server. Both machines are Windows 2003 server.
What happens is, unless i put the Internet Guest user account into Administrators group, i get an error message saying :

" Microsoft VBScript runtime error '800a01a8'
Object required : "
Connection to database failed ".

Of course, it's crazy to keep the IUSR_machine name user in the Admins group!

Does anyone have any idea why this keeps happening and how i can fix it ?

 

[denoxis]

Does the Internet User account have read/execute permission?

Are you using SQL authentication or Windows authentication for the database? If it's Windows, try to create a login for that database and explicitly state your login in your connection string.