Setting up SQL Server in Windows server 2008 R2 RRS feed

  • Question

  • User-224226683 posted

    I have a web-app project by C# and SQL Server 2008 R2.
    I transferred project to a VPS that runs Win2008 R2 and set all setting for IIS7. The Project runs and I can see the HTML pages but problem begin when in Login page or Register Page has no connection to SQL Server and nothing happened.


    Tuesday, June 2, 2015 6:13 AM

All replies

  • User753101303 posted

    nothing happened

    No, you should have an exception. Make sure you are not ignoring that (have you tried the Windows log ?) Currently you are using "integrated security" so my guess is that the account used for the web application is not allowed to access to SQL Server and/or to the database.

    If using the default account, it should be webserver$  (see http://www.iis.net/learn/manage/configuring-security/application-pool-identities and scroll down to "Accessing the Network")

    Tuesday, June 2, 2015 7:34 AM