×

Loading...

Topic

This topic has been archived. It cannot be replied.
  • 工作学习 / 学科技术 / IIS account access to database?
    I am developing an intranet site which is going to used by internal employees. This site is running under an IIS service account, it is under Windows authentication. IIS setting is Windows authentication. I gave IIS account permissions to our SQL server database. But the website has problems accessing database, what reasons could cause this problem. Thanks very much.
    • Setup ODBC, config to use IIS user account to connect database, test the connection works, then in your web application access database through ODBC.
      • Odbc is for desktop DB access, this is web based app and app running within the IIS server. I guess simply check the connect string used by IIS, make sure the driver etc. match ms required.
    • up
      up.
    • post your connection string
    • post error log