Advice On Hosting Website Safely
Apr 8, 2007
Hello,
For one of my clients I have built 2 applications. The 1st one is a windows based application that is used for production and employee scheduling. The data for this application is stored in a SQL Express database. The 2nd one is a ASP.NET 2.0 site that contains the clients website and a portal page. The portal page uses forms authentication and redirects a customer to a page that shows the production schedule for this customer. So I have 2 kind of users: local (LAN) and web. Both using the same database.
For test purposes the site is currently hosted on the clients SBS 2003 server (this is the only server). However I don't think it is wise to host the public website on this server. What is the best configuration to host the public website safely? I read about putting a webserver in a DMZ. But I need a connection with the SQL Express server to retrieve the data for the portal section. As well for authenticating the customer and for retrieving the schedule data.
I'm currently using Windows Authentication on the SQL server. Can this still be used when the webserver is in the DMZ?
If I understand it correctly the webserver in the DMZ is not part of the local domain? Also could remote hosting be an option at all?
Any help and advice would be highly appreciated.
View 1 Replies
ADVERTISEMENT
Oct 5, 2006
I'm having my website hosted with webhost4life.com which is very helpful and a really great company if you are using Visual Web Developer with SQL Express. The question I have for anyone who can help me is that my site will offer member roles for customer account maintenance with login and the works. As you know, when you use memberships with Visual Web Developer, it associates all these controls with a database called aspnetdb.mdf. And you maintain this database through the asp.net configuration control. Once this database is launched, I've learned how to access it by changing my web.config file removing the LocalSQLServer and adding one with the connection string to the aspnetdb.mdf database on the server. My question is, once I've done this and connected through that string, can I still use the asp.net configuration to edit the database (e.g. the users, roles, etc)?
View 1 Replies
View Related
Sep 1, 2006
I developed my first webpage using c#, VS2005 and SQL Express and it works fine in my Computer.
Tried to upload it to a hosting company, they have SQL 2005 Server.
I can surf through the pages but nothing that has to do with the database works.
Is there anything I should have done before uploading the site?
Please help.
View 5 Replies
View Related
Aug 19, 2006
I've started with the development of a website which will use a sql server 2005 database. I want to use the asp.net membership and roles functionality. In the end the website will be hosted by a hosting company.
What is the best way to store the database? In the App_data folder or outstide the App_data folder?
Second, do hosting companies support placing sql server databases stored into the App_data folder?
View 1 Replies
View Related
Jul 13, 2004
I was thinking that this question probably comes up a lot...but my forum searches didn't turn anything up, so here goes:
I have an id field that auto increments (identity) for each record.
I insert a record.
How can I safely extract the id field of the record for use in another query, avoiding the possiblity that another record is inserted before I can get at it?
Thanks,
G
View 6 Replies
View Related
Aug 13, 2007
Techs,
Every morning I come into find my LDF is about 70 gigs. So I shrink it based on the percentage it will allow because that seems safe, because this is a critical production server, which reduces the size down to 65 gigs. However, I return the next morning to find it has grown back to the original size plus some. How can I safely shrink this monster and keep it manageable?
Many thanks in advance.
View 3 Replies
View Related
Nov 3, 2007
I have a SQL .bak generated by our existing hosting package at 1and1.com, I want to import that SQL .bak to our new hosting package at ixwebhosting.com.
ixwebhosting.com don't have a import feature in their control panel.
I have to maintain the SQL at ixwebhosting.com using Microsoft SQL Server Management Studio Express since they don't have that feature in their cp. I don't see any import features in Microsoft SQL Server Management Studio Express either.
How can I import it using Microsoft SQL Server Management Studio Express or another free GUI program?
View 4 Replies
View Related
Oct 18, 2007
Hi
We have a bunch of servers running server 2000 & 2003 along with many sql server (versions 2000 & 2005) databases in a production environment pulling transactions then doing warehousing & reporting.
An audit has shown up 1 production server using English_US 'mmddyyyy' system date formats, all others being English_Australian 'ddmmyyyy'.
Is it safe to simply change the regional settings on this English_US server to English_Australian or will it mess up the data in our SQL 2005 databases? I've not been able to get a definitive answer from anyone yet!
many thanks in advance; GaryP
View 1 Replies
View Related
Nov 14, 2006
I've hosted a website in a freehosting account which supports .net 2.0 and SqlServer 2005Express and they only gave me an ftp access which i can access my website, i found that there's the "App_Data" folder which i placed my database in.Now here's the message i get when i try to connect to the SQL Express DBAn attempt to attach an auto-named database for file I:DataWebqsh.eucipherasp_015f1bdd-1338-4a35-9873-b29232b472c9wwwApp_Datacipherasp.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC shareSo, what should i do!
View 5 Replies
View Related
May 21, 2008
Developer made website. I want to upload in sever. There is
no index.html. Linux server is not
supporting. Files & Folders are the following.
1. ADMIN 2. APP_BROWSERS 3. APP_CODE 4. APP_DATA 5. BIN 6. IMAGES 7. ADS.XML
8. CALENDARDATEINPUT.JS 9. CHKUNCHECK.JS 10. CONTACTUS.ASPX 11. CONTACTUS.ASPX.CS 12. COUNT.JS13. COUNTING CHAR.ASPX 14. COUNTING CHAR.ASPX.CS 15. DEFAULT.ASPX 16. DEFAULT.ASPX.CS
17. DEFAULT.CSS 18. LOGIN.ASPX 19. LOGIN.ASPX.CS 20. MASTERPAGE.MASTER21. MASTERPAGE.MASTER.CS 22. MYCUSTOMPAGE.HTM 23. RECOVERYFORM.ASPX 24. RECOVERYFORM.ASPX.CS
25. REGISTRATION.ASPX 26. REGISTRATION.ASPX.CS 27. SALE.ASPX 28. SALE.ASPX.CS 29. SMS.ASPX30. SMS.ASPX.CS 31. SMS1.ASPX 32. SMS1.ASPX.CS 33. SMSSERVICE.ASPX 34. SMSSERVICE.ASPX.CS
35. TERMSCONDITION.ASPX 36. TERMSCONDITION.ASPX.CS 37. WEB.CONFIG 38. WEB.SITEMAP
39. XMLFILE.XML Please suggest & support me which server will support my file. I am
waiting your answer. I shall be very grateful to you. My email address is yog2599@sify.com
Thanks.
View 4 Replies
View Related
Nov 28, 2004
I am trying to export from an SQL Server on a hosting company to my own computer using DTS. I'm new to SQL Server manipulations like this so please go easy on me...
I can't seem to manage to do this properly - If I select "Copy tables & data only" it will not copy the identity constraints and primary keys. If I select "copy all objects" it starts giving me permission issues which I cannot seem to resolve, because I guess the tables on the hosting server are owned by my username up there, but when they come to my computer they are orphant?
Isn't there an easy way to do this? It's a very simple database, tables and that's it, not even any stored procedures.
View 3 Replies
View Related
Oct 9, 2006
I told my client to use a particular host, or at least one that offers a database... they instead went with a friend of a friend that offers hosting as a reseller.
Now I'm the web developer for this huge site overhaul which requires a database with a host that doesnt offer it.
I'm new to databases... thats why I'm accustomed to using the simplicity of ipowerweb or mediatemple and their phpmyadmin interface.
Anyway... what do I do? Will a database hosted elsewhere work? If you know about this stuff, please help.. I may not be asking the right questions!
THanks!!!
View 1 Replies
View Related
Feb 22, 2008
Hi
I have experience only designing an implementing DB in sql2000 but not too much administering.
My app is a Web Service that communicate with my DB.
The DB is in a hosting company, so I don€™t have too much permissions to play with.
The application have been the same for at least one year, no changes at all but recently my users complaint that the system was not working/responding.
I immediately thought about excessive load
When I went to query analyze and execute the command (sp_who), I saw that 173 processes where sleeping €“ awaiting command
that is the only thing I can imagine was the problem(not sure yet). I investigated and found the Kill process instruction but I was not able to run it because permission.
Based in this scenario How can I give a fast CPR to drain my DB and allow my user to work?
Any link?
Any sug?
thanks
View 6 Replies
View Related
Dec 30, 2006
Does anyone use One and One Internet (UK) for their hosting?
I use them and when I published my site all membership feautures wouldn't work, I called the One and One support and they said that their servers only support SQL Databases if they were created using their own tool in their control panels.
How would I get my site to use their database, I'm really not sure.
If anyone else could help me out I'd be grateful.
Kind Regards
Mattie
View 2 Replies
View Related
Jun 24, 2007
hello guys
I am developing ASP.NET applications in order to build a portfolio, im using MS SQL EXPRESS databases, do i need a hosting account that allows multiple sql databses or does SQL express fit in to your application, eg as many as you like in as amany applications. I am asking this because i know MS SQL server is a different thing from MS SQL EXPRESS server and hosting companies say stuff like 1 MS SQL databse and stuff. I have multiple applications that wont need the real MS SQL databse because there not live just portifolio stuff.
Can somone sugest a ASP.NET hosting company please a cheap one.
Thanks
Nadeem
View 2 Replies
View Related
Feb 16, 2005
I will like to know the files i will load to a remote server if i want to host an sql database.
let's use the northwind database for example, if i want to host it on hosting server what are the files i will host i mean i need a detailed procedure on how to go about it.
View 1 Replies
View Related
Jun 11, 2006
Hi all!
One good thing about access databases is the ability to upload the .mdb file to a hosting server and not being charged for database space.
How about MSDE? Does it require SQLServer hosting or can it be done just by uploading the database file?
Thanks,Ricardo
View 1 Replies
View Related
Oct 29, 1999
How u can connect u sql database with web server ?
bye
Navnit
View 2 Replies
View Related
Feb 16, 2008
Hello
Maybe someone can suggest me some software which can be used for SQL 2005 shared hosting?
With database size limit, user number restriction and other features.
Thank you for information in advance
View 3 Replies
View Related
Sep 14, 2006
Does anyone know where I can get SQL Server 2005 witness hosting? Our primary server is in Vermont and our DR site is in New Hampshire. I would like to set up a witness server somewhere off the east coast. I don't want to have to purchase a new server and pay big prices for colo.
Is there such a thing as witness hosting? Would someone be willing to host my witness and I can host yours?
View 1 Replies
View Related
May 23, 2007
I have a hosting package with network solutions. They tell me that i can only have one sql database... In my app_data folder on my computer web site i crerated, I have three of the main folders... does that mean that i have to merge all of those into one...
Another question, Since having many tables, functions etc how could i copy and paste if i have to merge those, because my express editon, i have no idea how to do it... and in visual web developer I'm not able to copy and paste between data folders??
Can anyone please clarify...
Thanks a milion
View 4 Replies
View Related
Jan 4, 2006
Hello,
I have been attempting to locate a hosting company that offers SQL Server 2005 in addition to Analysis & Reporting Services but have been unable to find a hosting company which does so without purchasing the entire server. Anyone know of a company?
Thanks in Advance,
Garrett
View 1 Replies
View Related
May 23, 2008
Hi,
I see < SQL SERVER 2005 EXPRESS EDITION LICENSE>
it has "hosting services" (at 4.Scope of License ),(Now, English has been removed, but the Chinese Simplified were)
it refers to what ?
it is means
1. Services Host -> supply app run environment, like IIS
or 2.Server -> Waiting for the link (Server)
PS. SQL SERVER COMPACT 3.5 can also use it
thanks
View 1 Replies
View Related
Mar 14, 2007
I have a server that i would like to use as a dedicated DB Server. It is running Win Server 2k3 and SQL Server 2005. The typical upstream bandwidth is anywhere from 384Kb/s to 700Kb/s. Is this enough to host multiple SQL Server 2005 DB's?
The DB's will be used for database driven websites.
Please let me know what your thoughts are.
Thanks,
View 1 Replies
View Related
Jun 22, 2007
I am using .Net 2005 and sql 2000. While hosting time i am getting this kind of error...Should i Change any setting in sql and .net
"Sql 2005 does not allow remote connection"
View 2 Replies
View Related
Jul 22, 2007
Hi all, I'm a newbie of SQL. I built a website using SQL 2005, and the data control was using a dataset and wizard,now when I'm uploading the website + database,I learned godaddy doesn't support database uploading.I have to create an empty SQL database on godaddy's sql server, and reDir the connection in config file. my question is, where should I copy my dataset commands to godaddy's sql server?2nd, how do I invoke them in asp.net? thanks in advanceyonk
View 1 Replies
View Related
Aug 5, 2007
I have established roles to restrict access to the data
entry pages. The database is SQL Server which I've established on the hosting server. Security was previously maintained through
~/app_data/aspnetdb.mdb (MS Access). It works, but isn't too stable, so I have modified the security to use
SQL Server with an aspnetdb.mdf file, also located in the app_data
folder. Is this appropriate? Since it doesn't work, I assume not.It's now my assumption that I need to setup a SQL Server
database to support the security/roles. I have seen some reference to
using a script to build the aspnet.mdf on the hosting server. If
I do create such a database, is there anything special I need to do to
have my application read the aspnetdb? Do I need a connection string
in the membership and/or roleManager sections of my web.config.
A little guidance would be appreciated.Thanks
View 4 Replies
View Related
Aug 12, 2007
I have been reading on aspnet_regsql.exe tool and still haven't found my answer. So here we go... I am using VWD Express and I have already made many pages in many dbs within the app folder. My question is how do I use the aspnet_regsql.exe tool to know what DB that I want the tool to know AND how do I put in the name of the DB on my sql hosting server? For instance:Let say in my app folder I have a DB named testDB.mdf and my hosting sql server is named sqlHostingServer... so if I use the command line entry in accordance with the documentation, it should look like this (in the dos prompt):aspnet_regsql.exe -E -S localhost -d testdb.mdf -A all -sqlexportonly c:output.sqlbut it seems that for the DB name I can put anything I want and still gives me output... wtfark... any help? I don't work at Microsoft so please simple documentation or something like that.Thanks,MR
View 4 Replies
View Related
Dec 15, 2003
Can anyone recommend a good tool for administering my database ? It is located on a hosting service, however, they donot allow the use of the SLQ server admin tool since there are security concerns..
View 1 Replies
View Related
Mar 29, 2004
Does anyone know of a commercial hosting service that is supporting the new Reporting Services? The hosters I have talked to don't even know what it is.
View 5 Replies
View Related
Dec 29, 2005
I am currently developing an asp.net 2.0 app which uses form authenication now implemented in a sql server express mdf database file. I wonder if there will be problems when I want to deploy this app on a hosted server from a hosting provider. I have the impression that hosting a SQLexpress user instance is currently not supported by hosting companies. Is this correct? Should I revert to an msaccess database instead (we don't want to pay extra for full blown sql server storage).
Ronald
View 5 Replies
View Related
Dec 30, 2005
Hi to All,
If I create a Web Application using VWD and use an MDF file on APP_DATA, I need that my Hosting Provider have SQL Express on server where resides IIS?
Thank You!
View 1 Replies
View Related
Feb 15, 2006
If I were going to look into investing into a virtual dedicated server and wanted to save LOTS of $$$ by offerring SQLExpress (FREE) vs. SQL Server Enterprise $25,000 sticker price.
The Web sites that I build are for small businesses.
Is there an issue in using SQLExpress on the Internet? Considering it is the Web application account ID accessing the database so that is one user hitting the DB.
I am unclear on how I need to evaluate multiple calls to the system depending on how many users are on the Web site opening the connection performing SQL Commands then closing the connections all with the same user creditials.
<moojjoo />
View 4 Replies
View Related
