Setting up IIS and a MSSQL database

Question

User-1463926252 posted

Hello,

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
Apostrofix 

Answer 1

User-1315512054 posted

Hello,

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.

Regards

Answer 2

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.