Link to home
Start Free TrialLog in
Avatar of mainrotor
mainrotor

asked on

I need assistance with my ASP.Net application

I just built an ASP.Net web application on my local machine.  My app saves data to my SQL Server database that is also on my local machine.  I am ready to go live with this app (i.e. put it on the web).  What do I have to do to make sure that the application still save data to the SQL Server DB on my machine?  Or do I have to use the MySQL databases that are provided by the web hosting company?

Thanks in advance,
mrotor
Avatar of quizwedge
quizwedge
Flag of United States of America image

Your best bet would be to use the SQL database on your web host's computer. Your solution will be faster that way.
ASKER CERTIFIED SOLUTION
Avatar of COBOLdinosaur
COBOLdinosaur
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mrRany
mrRany

If you take SQL out of intranet where is your IIS then you reduce performance and security.
Anyway you will need to change connectionString in your web config "Data Source=you_pc_ip;Initial Catalog=..".
You can find some info about connect via IP address here.