IIS Configuration :: How To Get Connection String Of Database On Shared Hosting
Apr 28, 2014What will change in connection string after upload database to hosting?
View 1 RepliesWhat will change in connection string after upload database to hosting?
View 1 RepliesI 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.
My connection string is:
<add name="DBCS" connectionString="data source=(local)SQLEXPRESS;database=LAAFOOD;Integrated Security=SSPI;" providerName="System.Data.SqlClient"/>
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 just completed my website in asp.net using visual studio 2008 with sql server 2005 express edition.
my database is mdf file based..
i have uploaded my website in godaddy with the help of cute ftp..
but the problem is that my database is not working..
Is it ok to upload complete website along with database using cute ftp? or i have to create separate database for it and make connections...
i read somewhere that file based website doesnot required any connection, database is simply uploaded along with website..
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.
View 1 RepliesI 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 an ms access db file and now i want to use it in my app. i have given like
Provider=MSDASQL.1;Password=pwd123;Persist Security Info=True;User ID=swgp;Data Source=SWGP;Initial Catalog=C:swgp BJswgp
but it is giving error to me.If anybody know how to give this connection string for password enabled ms access database,
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.
View 2 RepliesI 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...
View 1 RepliesI 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.
try
{
string Path = Server.MapPath("~");
string filename = System.IO.Path.GetFileName(fImage1.PostedFile.FileName);
string ftpfullpath = ftpurl + filename;
FtpWebRequest ftp = (FtpWebRequest)FtpWebRequest.Create(ftpfullpath);
[code]....
How i will upload the large size file through ftp.
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 hosted a website in Client's Server.
One of the functionality of the site is to create a PDF File on a Specific Shared Path.
The Shared path is mentioned in the Web.Config File.
If the given shared path exists in the same machine then the PDF File is created and stored in the shared path.
If the Shared path exists in the other shared network System then the PDF is not created and not stored in the shared path.
how I can correct an error. I've built the MVCMusicStore tutorial here:
http://mike-ciccone.com/Store/
The first time I visit the site and attempt a database connection I get this error:
Exception Details: System.Data.SqlClient.SqlException: CREATE DATABASE permission denied in database 'master'.
But when I refresh, it all works fine. I'm at a bit of a loss. I don't believe I'm attempting to create a database, but I realise that the error may not really have anything to do with that. This is hosted at GoDaddy shared hosting. The database was created and I used an SQL script to create the tables initially and populate the data. My connection string works as I can pull data from the database, but I do have
a feeling it will be a web.config setting that will correct this.
I'm wanting to use DB4o on an asp.net MVC project i'm working on but wondering if anyone has got this working on shared hosting plan, have contacted discountasp and asked them and they said go to the forum as they were not sure if they supported it or not or any configuration that would be needed. but the forum wont let my post on because its all filtered to only show comments they like the look of? anyone had any joy with this with another host and one that runs asp.net MVC as it should be run?
View 1 RepliesWhy 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")))
[Code] ....
And this is in global.asax
And in web.config
<authentication mode="Forms">
<forms loginUrl="Default.aspx" defaultUrl="~/" name="MyCookieName"
slidingExpiration="true"
timeout="43200"></forms>
</authentication>
[Code] ....
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'.
Source Error:
[Code]....
I am developing an application in which I can connect to the ASPNETDB.MDF if it is on my machine, however, when I want to put it on another machine and try to remote connect it, I get the error:
An error occurred while attempting to initialize a System.Data.SqlClient.SqlConnection object. The value that was provided for the connection string may be wrong, or it may contain an invalid syntax.
Parameter name: connectionString and my connection string is as follows:
<add name ="NewRemoteSqlServer" connectionString="Data Source=P1M1_2-HPSQLEXPRESS; AttachDBFilename=C:ASPNETDB.MDF; Integrated Security=SSPI; Username=P1M1_2-HP; Password=plus1minus1; " providerName="System.Data.SqlClient"/>
I have a database on Go Daddy and my VS2008 app can not access it via web.config connection string. Of course runs great locally in development. I copy/pasted the connection string information from Go Daddy exactly into my web.config file. Web site runs fine on the web but when I try to Login at my login page, i get :The SSE Provider did not find the database file specified in the connection string. At the configured trust level (below High trust level), the SSE provider can not automatically create the database file.
I used VS2008 to create the .sql script files and uploaded them to Go Daddy and the Go Daddy people say everything works as they and I can both Login to the database from within GoDaddy.The database i am trying to access consists of the a ASPNETDB.mdf and another Database.mdf together as one in the Go Daddy database.
here is what i used: <connectionStrings><add
name="superskin"
connectionString="Data
[code]...
I am trying to deploy crystal reports 2008 on shared server. Before publishing on the remote server i published it on the localhost while connecting it to remote sql server 2008 database. The report is shown perfactly but when i publish it on shared server it prompt me for login credentials. My hosting provider is arvixe and it support crystal report. In my popup database field is empty and locked use name field show the correct user name and password field is empty. I read somewhere it may be due to version conflict between my version and version on server.
View 9 RepliesI get another error message regarding SQL database.In my project, the database for membership and roles is under App_Data, plus another DB data i created. both DBs are .mdf"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"I have my web hosting from GoDaddy, do i need to configure anything there? or is it something to do with my web application?This is my connection string in web.config:
[Code]....
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?
have made a complete website with a db with many table and fields........i have to make a database server where only the database will reside
i have read many links, and many answers here,this is what i got installed sql server 2005!
okay on one pc which had only win xp, i installed dotnetframework 3, then installed sql server 2005 and sql server management studio express.when i open the studio express i use windows authentication and server is the default computer nameit starts and show these folder with already present dbs now what should i do, how can i ask this software to host my database file 'abc.mdf' so that i can benefit from the integrity and consistency features offered by the software for databases?
if importing this db is not possible how to make a new one?, i mean there are four folders where to make the new db in?
"how can i ask my webserver (IIS) to connect to this 'SQL Server Management Studio Express'?"
"how can i ask the debugger to connect to SQL Server Management Studio Express on the other computer"
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.
View 3 RepliesI 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.
View 2 Replies