I have an Asp.net 2.0 web application using sql server 2000 as back end. I want to deploy the web application on Web hosting company’s rented web server.
The deployment of the asp.net 2.0 is done easily using the FTP (example filezilla). But to deploy the Database is quite tricky.
(Steps using HELM control panel)
Step 1: we need to create a database on the server, by logging in to the server using the HELM control panel, (details of accessing the Helm control panel will be pro
vided by the Service provider). Login –> Domains –> select ur domain –> Click Database manager –> select Sql server 2000 icon –> click New database and give the desired database name (E.g. MyDB). It will create an empty database on the server.(Also, note down the IP address, Port Number used. if you cant see the ip address and port number(xxx.xxx.xxx.xxx,&&&&), ask your service provider to get you the detail of port number)
Step 2: Create the Database user, give the username n password that you will use to access the database from your web application / Enterprise manager (E.g. MyDBUser).
(Steps using your local development/testing machine to upload the sql server 2000 database.)
Step 3:
Open Enterprise Manager –> Select Register New Sql Server from left pane –> Registered Sql Sever Properties will popup as shown in the figure below. Key in the IP Address, Port No. (xxx.xxx.xxx.xxx,&&&&), without parenthesis. Give the username n pwd we just created in step 2
Step 4:
Once the Sql server is registered, you can use it like a local db and use DDL, DML statements very easily.
I hope the post helps people to understand deployment better.
If you like the post, please bookmark it and use friend connect to be my friend on this blog.
Happy Programming.
Posts
No comments:
Post a Comment