In my string below, my forum setup up file, setup.asp , when run delivers an error that it is unable to connect to the database. Error: 800004005
I am running this from within IIS 5.0 aon a Windows 2000 Server, by right clicking the file in IIS and choosing "browse" I am trying to set this up so user IUSR_SERVER_NAME can "read and Write" to the database or instance I have created called rpggamerpro. The authentication in the SSSAC is set to use both Windows and SQL Authentication for the "master". I have set permissions on the folder which contains the SQL 2005 Express installation and database for IUSR_SERVER_NAME to read/write. I have created a IUSR_SERVER_NAME user in the Security/User directory for the database or instance "rpggamerpro" and gave the user read/write permissions there. So I am still at a loss as to what permissions, strings, settings, configuration or whatever the heck else needs to be done in order to get this thing to work. Please anyone willing to help a realative new commer to the SQL and DB world would be greatly appreciated.
trConnString = "Provider=SQLOLEDB;Data Source=ns\sqlexpress;database=rpggamerpro;uid=IUSR_NS;pwd=;" '## MS SQL Server 6.x/7.x/2000 (OLEDB connection)

Web Forum Setup Fails To Connect To Database Error :80004005
pemmawadu
You will have to change the connection string to use the native client drive to connect to the database.
Standard security:
"Provider=SQLNCLI;Server=ns\sqlexpress;Database=rpggamerpro;uid=IUSR_NS;pwd=;"