Bought new VPS For Hosting ASP.Net Websites- Self Managed, Need some advice

April 29th, 2020

I have bought a godaddy VPS server (which is hosted in North America) for purely experimental and learning purposes for a Month.
Specs
2GB Ram
40GB HDD
Windows Server 2012 R2
Dedicated IP which I am using to access online, currently Default IIS page shows up
Server is all self managed (I wanted to learn so didn't go for Managed one), nothing was installed, even Roles

I am total noob at the time but thought to take a big step forward and learn while going
I need to Hosting for ASP.NET website which will be having records entered for online monitoring. I’ll be coding the website too.
Currently I have setup few roles, Like IIS, FTP server etc.
IIS is running and website is online on internet (tested and working).
Just Provide me Tips or some tricks to start on with this setup
I need FTP server running and remotely access via Filezilla or other tools
I have one year SSL standard certificate, How can I setup it with my server?
I need SQL Server 2008 R2, (As I don’t have license, will Express edition work fine for my website), will I’ll be able to access it remotely from my Desktop and Sql server management studio 2008 r2?
Setup IIS for ASP.NET 4.0 (I am using Visual Studio 2010 for development)
How should I setup SQL server express?
How to make it secure? I have SSL certificate. Remember?
Please ask anything you need to know more I’ll try to answer best of my knowledge.
I am also reading everything available on internet which I think can help me but if you can point me towards right direction, it will be immensely helpful
Note:No domain bought yet, will buy later, I have typed this all in hurry so forgive any mistakes and ask anything not clear.
Edit:- 19-12-2015
I Achieved following things
– IIS working, I can access website using Dedicated IP address provided to me, I uploaded 2 HTML pages and they were found to be and available online
– FTP worked without SSL
– Sql Server Express 2008 R2 Installed and found working remotely (added exception in Firewall)
– Site Working on HTTPS: Installed free SSL certificate provided with hosting, Now website works on both HTTP and HTTPS
-Batch file created to take regular backup of DATABASE from SQL Server express, -I can create scheduled task to take backup on regular interval, so backup process is automatic
Works I Still need to do
– Install FTP and Connect to Hosting folder (Both are different task, but I know how it may be acheived,
– Install SSL certificate with FTP server and access via FTP (filezilla preferred)

Answer #1
took your line from ‘works i still need to do’ and post it on google
Install SSL certificate with FTP server and access via FTP (filezilla preferred)
https://wiki.filezilla-project.org/FTPS_using_Explicit_SSL/TLS_howto_(Server)
good luck with your project
Answer #2
took your line from 'works i still need to do' and post it on google
Install SSL certificate with FTP server and access via FTP (filezilla preferred)
https://wiki.filezilla-project.org/FTPS_using_Explicit_SSL/TLS_howto_(Server)
good luck with your project

Thanks for the reply, I thought no one would ever reply
I did connected FTP with SSL Certificate, but whenever I tried to connect with server using Filezilla CLIENT, (I was indicating to filezilla client and NOT SERVER), Login Fails, without SSL it works great, but not with SSL. I thought someone server expert may comment,
I am also trying to FTPing locally on Remote server using ROOT account using RDP i.e. Remote Desktop Login- I have admin account
Part from that,
From my developers side I need , to Create users in SQL Server to be able to CREATE, DELETE and ALTER TABLE for database assigned to itself only but not DROP DATABASE or or anyone else’s
Answer #3
I’m not familiar with what FTPing is. (if you’re talking about using FTP in localhost than it’s pointless)
In order to connect with FTPS / SSL you need to configure the server to accept FTPS / SSL connections, after that, you will be able to login with the client configured to FTPS / SSL connection.
Answer #4
I'm not familiar with what FTPing is. (if you're talking about using FTP in localhost than it's pointless)
In order to connect with FTPS / SSL you need to configure the server to accept FTPS / SSL connections, after that, you will be able to login with the client configured to FTPS / SSL connection.

Yeah I was talking about FTP, made a verb out of noun,
And yeah I configured it, but it didn’t worked, Login Fails every time I try. Without SSL certificate configured it works flawlessly. Everything is as it should be, firewall, configuration options, etc. But it just don’t work, I might be missing something here.
I think I need to create my own certificate (however it has its own issues) for secure transactions
Answer #5
Found few:
http://www.iis.net/learn/publish/using-the-ftp-service/using-ftp-over-~ Phishing ~in-iis-7
http://windowsitpro.com/microsoft/configuring-ftp-over-~ Phishing ~microsoft-iis
https://winscp.net/eng/docs/guide_windows_ftps_server
What other goals are you planning to achieve?
edit: says phishing for no reason.. replace ~phishing~ with ‘ssl’ word.
Answer #6
Found few:
http://www.iis.net/learn/publish/using-the-ftp-service/using-ftp-over-~ Phishing ~in-iis-7
http://windowsitpro.com/microsoft/configuring-ftp-over-~ Phishing ~microsoft-iis
https://winscp.net/eng/docs/guide_windows_ftps_server
What other goals are you planning to achieve?
edit: says phishing for no reason.. replace ~phishing~ with 'ssl' word.

I already seen the tuts, at-least the second one, but I’ll take another look. Maybe i missed something
The goal it to transfer files over ftp in secure environment for dot net hosting on VPS server. Keep the site as secure as it can be (without using services of any expert as I may have to handle server myself in future) with giving minimum authorization which is required to achieve desired result. Also there is problem with SQL Server 2008 R2 Express, I want to create another user which can apart from delete database to view other user database can do anything in its own database. I need to study schema and user roles to achieve that but I am not able to achieve that too. these two things (1. FTP, 2. SQL server user creation with proper rights) are most important agendas for now
Answer #7
I believe FTP, even without SSL cert is fine. It’s already been used worldwide, without SSL.
SQL server user creation.. google\youtube a little more and you can do it.
Answer #8
I believe FTP, even without SSL cert is fine. It's already been used worldwide, without SSL.
SQL server user creation.. google\youtube a little more and you can do it.

Well Lets just say I want this functionality at any cost somehow
There is a way to create FTP Certs and Self Approve it, may be if nothing works I’ll use that method. I am sure it should work.
http://www.iis.net/learn/publish/using-the-ftp-service/using-ftp-over-*SSL*-in-iis-7
But as said in tuts, Its not taken as secure without certifying agency. And it shows warning every time we connect. But FTP is for my use only so I think Ill work with that.
Remove * from above URL
About SQL Server User creation, I have been able to create user with permission, but it either has all the permission same as database owner i.e. [dbo] or it has only limited permission like Data Reader and Writer (which doesn’t have execution power i.e. execute stored procedures). I want to give it permission to do the same and allow it not only Read and write data via normal queries in database but also Create VIEWS, Functions, triggers, Create and delete Tables, take backup of its own database
Answer #9
for SQL prem – Look up for user roles
for FTP – what about sFTP?
Answer #10
for SQL prem - Look up for user roles
for FTP - what about sFTP?

I don’t know about SFTP and how it implemented or whether it is secure enough. TLS i think is secure but certificate issues are there. Anyway I have gone for Managed services this time for an year worth account
Answer #11
Spam removed -

 

| Sitemap |