Last post Sep 08, 2013 04:40 AM by Apostrofix
Sep 07, 2013 04:37 PM|Apostrofix|LINK
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!
Sep 08, 2013 04:30 AM|HostingASPNet|LINK
You could install the SQL Server 2008 Express -
The other approach is to find some cheap ASP.NET hosting provider which supports
SQL 2008 hosting.
Sep 08, 2013 04:40 AM|Apostrofix|LINK
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.