IIS Configuration :: Configuring Connection String In Shared Hosting
Mar 24, 2013
I have developed an e-comm web site in asp.net with sql server as a database. Now I want to upload that web site with DB to hosting server. This is my first web hosting and I don't know how to do it.
I've created the DB script to recreate the DB at the hosting server, but I don't know how to run it on server.
What changes need to be done in my connection string in web.config file for connecting the DB which will be on hosting server.
I also have ftp client "Filezilla" which i am able to use for uploading static html pages on server.
I have looked for ideas on this and read several posts but none of them seems to be because the problem is that web.com (my host) doesnt allow us to update web.config on their server programmatically. I can use example codes and encrypt them on my local pc but heres the error i get when I run them on the live site:
An error occurred loading a configuration file: Request for the permission of type 'System.Security.Permissions.FileIOPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. (machine.config)
My problem is that I'm going to have a SQL Server database and website that accesses that database via a hosting provider, most likely GoDaddy.com, using ASP.Net. I need to make sure the connection string in the web.config file is as secure as possible, because the database will actually be storing trivia questions for a game I'm developing, and the clients will be accessing these questions, saving specific state related details, and other details, to the database, so every player that plays the game will have their details stored in this database. I need to ensure hacking is very difficult to accomplish.
From my research it appears as though the only viable solution for your web.config when you've got a hosting account with something like GoDaddy.com is to use SQL Server security to connect to your SQL Server database and place those details in the web.config file. Is this correct? It seems that this is the most likely scenario for most users, because we don't have access to our hosting providers IIS servers in order to use Windows authentication with SQL Server access and then use DPAPI encryption from there.
I have a GoDaddy shared Windows hosting plan and I'm running into a small issue with multiple domains. Many people have previously reported such an issue, but I am not interested in trying to resolve that problem altogether; all I want to accomplish is to change the format of my ActionLinks.
Issue Let's say the domain that is mapped to my root hosting directory is [URL]. GoDaddy forces mapping of other domains to subdirectories of the root. For example, my second domain, [URL], is mapped to [URL]. I uploaded my ASP.NET MVC site to such a subdirectory, only to find that ActionLinks that are for navigation have the following format: [URL] In other words, even when I use the domain that is mapped to the subdirectory, the subdirectory is still used in the URL. However, I noticed that I can also access the same path by going to: [URL] (leaving out the subdirectory) What I want to achieve I want to have my ActionLinks automatically drop the subdirectory, as it is not required. Is this possible without changing the ActionLinks into plain-old URLs?
I have created a web site in Visual Web Developer 2008 Express Edition. I have created database using SQL Server Express. The web site works good. I have hosted the web site, then getting error in connecting to database.
The connection string is < add name="QkINDUSConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|QkINDUS.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
know what is the correction i need to make in ConnectionString ?
I have in the past used Godaddy shared hosting with .net 4.0 and had no problems viewing and logging into the administration pages of a asp.net 4.0 website, using the default ASPNETDB.MDF. I don't remember if there was any changes to the web.config file. I can view the site but can't log into the site throws a error which has no detail just the custom error message explaining to change the custom tags for a more detailed message and even then it don't work get same message.
I am using below link to upload files , the code wrking fine on my system with win 8 and studio2012 but when i put code on my hosting with shared hosting package the page giving error . my hosting runs on iis7.5. what to keep in web.config and what to remove. URL...
I am uploading file through ftp using asp.net,c#. If my file size is small(3 MB) then it is uploading file bit if my file size is large then it is not uploading all file. it is uploading only about 3500 kb. i am using the following code.
i have implemented URL Routing in asp.net website using article (URL...) and it working file offline on my local system but when im trying to run online (from my hosting site) then it is showing error..
HTTP Error 404.0 - Not Found..
The resource you are looking for has been removed, had its name changed, or is temporarily unavailable.
i have database that is stored on local.user should also be able to upload the database to online server . i am able to save it on local .But it is not saving on server.It shows request time out. Is it due to server not allowing external access.
Why remember me doesn't work? As you can see in picture below Expire date is at the end of session although I set expiration to 1 month. This is my login button codes
protected void btn_login_Click(object sender, EventArgs e) { if (!Page.User.Identity.IsAuthenticated) { if (GetMemberAuthenticate(txt_uname.Text, FormsAuthentication.HashPasswordForStoringInConfigFile(txt_pass.Text, "MD5")))
The error is mentioned below, the cssfriendly.dll is in bin, and browser file is in there app_browsers folder. And it is working in same PC (developping PC), on remote server that belong to my company (i just installed .net 3.5 on that server)
I tried uploading the same site on 2 dufferents hosting, and finally i got the same error. What could gone wrong ? I tried contacting the hosting support but they work in ticketing system and this is extremely slow.
Configuration Error Description: An error occurred during the processing of a configuration file required to service this request. review the specific error details below and modify your configuration file appropriately.
Parser Error Message: Could not load type 'CSSFriendly.MenuAdapter'.
When I first published my site, I tested it using my gmail account and worked like a charm first try (a rare feat for me ;) ). Now, I'd like to finish it up by having it send the emails from the account at the host. No joy... I asked the host if I had misunderstood the rather unhelpful info in the control panel and they advised that in my web config I should change:
I have created a ASP.NET 4 application in VS 2010 using Silverlight and RIA Services.
After finishing the first release on my development pc, I'm starting some deployment testing in a server in my local network.
After sucessfully published the web application using the Visual Studio FTP publishing option, I notice two strange things:
1 - On the IIS properties of the website I have uploaded my files to, you can see now a connection string, named as LocalSqlServer that points to the aspnetdb.mdf database file. I had a look in the web.config file and I could not find this connection strind defined there. So, where is it located? Where did IIs got it from?
2 - As the aspnetdb.mdf file is not deployed withtin the web application and I a musing SQL express in my testing server, where can I drop the mdf and ldf files so they can be attached when the applicaiton runs? I know I can perform an attach operation using management studio,but I'm wandering where is the DataDirectory folder ASP.NET looks for to attach it at runtime?
I have decrypted my connection string in web.config file of the application programatically. But after deployment under the ASP.net tab of application virtual directory when I click edit configuration the connection strings in web.config file are visible in decrypted format i.e readable form.
I have been preparing for a conversion of an old application to an ASP.NET webapplication at beginning of the year. Generally, the development version of the webapp will also be the webapp that goes into production. We here make "clones" of the database server, assign new name, etc, which is then used for development, training, and so on without any threat of changing data on the real db (sql server 2005). I know it is possible to have more then one connection string in the web.config. My question centers around if there is a simple method for allow multiple connection strings and pick the one that is to be used for dev, production, training, and so on? I originally thought about constructing some type of admin form that the connection string can be selected from.
I have an app that is a bit old and will eventiall be rewritten but until I get the time it needs to continue to be patched. THe app is desgined broken into three layers (Web, DAL, BLL) The web site uses the DAL.DLL and BLL.DLL and the Website has some dataaccess and the sonnection string is saved in the web.config. For the DAL it is stored in the app.settings. Is there a way for the DAL to use the connection string that is stored in the Web.config even thought it is in DLL for the production site?
I was reading about how it is a good idea to encrypt the connection strings for security purposes. I came up with a solution that I think may be somewhat elegant, but there may be big flaws in my thinking. I am overworked and tired :)
Basically I have a setting in the web config EncryptConnectionString. In the Global.asax. Application_Start I am checking this in the config. If it is true, I am encrypting the connection strings. If it is false, I am decrypting the connection string.
I finished my first asp mvc project and want to post it to a iis7/sql2008 server.I published the site just fine and migrated the sqlexpress database to sql2008 with no problems.However, when I run the program it still connects tp sqlexpress and opens a user instance.For the life of me I cannot get the connection string correct:
I was curious if there is a shared hosting platform for asp.net web sites that would allow me to setup a service that would do something at predetermined intervals. Dedicated hosting is not an option due to budget constraints.
So far, it looks like my solution will have to be to set an object in the cache and use the expired callback.
Has any one used the above method? and how successful was it?
