Setting up IIS and a MSSQL database RRS feed

  • Question

  • User-1463926252 posted


    I started a project with educational purposes, my point is to strenghten my knowledge in the asp.net area. For that, I took an old PC on which I installed Windows 2008 Server R2. Now I am setting up the IIS, which I believe I am done with, but I don't know how to enable the support for MSSQL databases on my server.

    The point is to have a working dedicated server that hosts my ASP.NET website and MSSQL database. 

    Do you have any guides on how to setup a MSSQL database? I have no idea which tools to use. 

    Also, if I install Microsoft SQL Studio and create a database - how can I connect it with the IIS?

    I appologise in advance for the questions, it's just I am still a beginner and a lot of things are unclear.

    Thank you for reading my post!

    Best regards

    Saturday, September 7, 2013 4:37 PM


All replies

  • User-1315512054 posted


    You could install the SQL Server 2008 Express - http://www.microsoft.com/en-us/download/details.aspx?id=1695.

    The other approach is to find some cheap ASP.NET hosting provider which supports SQL 2008 hosting.


    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Sunday, September 8, 2013 4:30 AM
  • User-1463926252 posted

    Thank you for the answer! 

    I actually spent the whole night on reading about the subject and eventually I installed the SQL Server 2008 Express.

    Then I saw the option in the IIS to set the ConnectionString to point to my database, so I guess everything should be fine.

    Although, I am not sure if this is the best way and if there are other possibilities.

    Regards. Smile

    Sunday, September 8, 2013 4:40 AM