Despite using many sql databases before, I've never actually tried to develop an app with a database in the App_Data directory.
It's a small WCF service project, which has a sql express 2008 r2 database.
Working in VS there are no problems, I thought it would be as easy as deploying to a server (win 2008 with sql 2008 r2 installed) and it would just work. But it would appear not.
In the web.config, the connection string which uses |Data Directory| in the connection string.
I read here that |Data Directory| only works in VS, but looking at other articles on the web that doesn't seem to be the case.
I have (for the sake of this) given everyone modify rights on the app_data dir on the server.
If i have a server with ASP.NET 3.5 installed, where no one explicitly installed SQL Express. Can my web application still connect to an MDF file in the App_Data folder
I am confused as to what to do with these. I have .cs files in App_Code. I also have other files in App_Data, and Bin. Could I just create these folders, make them virtual directories and upload my files as normal? Or do I need to do something special with these folders/files? Im really stuck on this. Also, this is a "shared hosting" account.
I have visual studio 2010 at home and have developed a web application. I am now at another computer in another location. All I have is the project folder on my usb drive and all this computer has installed is IIS express. Is there any way I can somehow get my web application up and running?
I am a newbie. First time, I am going to deploy the web application to a host? Few questions, do you know any free asp.net hosting with FTP capability? Secondly, how do I ensure the data-base is secure, so that the hosting site cannot access the database or open without a password?
for the last couple of days i've been trying to deploy an application that uses a sql express db on to my iis.up until now i was trying to upload it onto iis 5.1, but now i a brand new iis7.5 but i still get this annoying error:An attempt to attach an auto-named database for file C:application_nameApp_DataDatabase1.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.needless to say that there is no database with this name on my computer. i've set the application pool to .net framework 4.0.
I'm currently writing a website in ASP.NET MVC, and my database (which doesn't have any data in it yet, it only has the correct tables) uses SQL Server 2008, which I have installed on my development machine. I connect to the database out of my application by using the Server Explorer, followed by LINQ to SQL mapping.
Once I finish developing the site, I will move it over to my hosting service, which is a virtual hosting plan. I'm concerned about whether using the SQL Server setup that is currently working on my development machine will be hard to do on the production server, as I'll have to import all the database tables through the hosting control panel. I've noticed that it is possible to create a SQL Server database from inside Visual Studio. It is then stored in the App_Data directory.
Does it make sense to move my SQL Server DB out of SQL Server and into the App_Data directory as an .mdf file? If so, how can I move it? I believe this is called the Detach command, is it not? Are there any performance/security issues that can occur with a .mdf file like this? Would my intended setup work OK with a typical virtual hosting plan? I'm hoping that the .mdf database won't count against the limited number of SQL Server databases that can be created with my plan.
I know the question has been submitted previously. I am a newbie to those tools. If I access to the database by way of management studio both under the windows integrated authentication and sqlserver authentication, everything works like wonder, but VWD just pop up a warming when I tried to log in the DB, you know, I was not allowed to sign in under sqlserver mode. then it alarmed me that it failed in connecting to the default DB file with my windows account.
I have been using VWD2010 Express for a website that I am working on. Due to a delay in implementing the 4.0 framework at the hosting service that I use, I need to finish up with VWD2008 Express. Is there a simple way to save my project so that it is compatible with 2008?
I'd like to learn more about MS Business Intelligence Development Studio. I'm doing this on my own, so I'd like to keep my software costs down. It's my understanding that BIDS comes with the download for SQL Server, but is used in Visual Studio (by creatign a BIDS project). Is this accurate? My question is - Is it possible to get a working copy of BIDS by downloading SQL Server Express and Visual Studio Express?
I am using System.directory services namespace in framework 2 to query active directory. I have used fixed user account impersonisation in the web.config file, find the code:
I have disabled anonymous access in IIS. Also i have given Read & write access to the account tang09 for the website virtual directory and Microsoft.NET folder located in windows folder. But still i get prompted for the domain username and password to access the website.
If there is a self contained web app, let's use the Screw Turn Wiki as an example, that utilizes the App_Data to store the MDF, is there any way another web app, living in the same domain, can also use that MDF?
Example IIS Setup:
http://wiki.domain.com | c:webwiki | port 80 http://www.domain.com | c:website | port 80
My WWW web app would like to pull some data from the WIKI app. Without moving the MDF to a full fledged SQL Server is there a way to do this? Also note, the WIKI app is an installed app so I don't have access to its source.
i tried to add sql/server database file to app_data and i got this error
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)
im using sqlserver 2005 and VS2008 +i tried to amke remote cpnnection and restart the services but with no use
I'm using VS 2008 web developer express and SQL Server 2008 express. I created a few dbs using management studio and then created an App_Data Folder in the Web Developer. However, I cannot add the DBs that i created to the App_data folder. I navigated to C:Program FilesMicrosoft SQL ServerMSSQL10.SQLEXPRESSMSSQLDATA and tried to add the DB to the App_data folder. I get the following error:
"The File cannot be added because its being used by another process.
Pardon if this is a very dumb question, but I was trying to migrate an existing ASP application to asp.net MVC, and followed the procedure from the music store tutorial (http://www.asp.net/mvc/tutorials/mvc-music-store-part-4), which involves adding the database to the App_Data folder. (I had to restart my machine before it would work, since otherwise, Visual Studio thought the database was being used by another application.)
Now when I check in Windows Explorer, it looks like the database file was literally copied into the App_Data folder, and now I have two mdf files on my hard drive with the same name. What is going on there?
Will my MVC app ignore the original (real) database and use it's own private copy instead? (That would be bad.) Or is the new copy just for reference when using wizards that generate entity classes etc.? If the latter, what is the procedure when the real database is modified, to update the application code?
I'm taking Microsoft's walk through on MVC 2 Forms Authentication - [URL]According to the walk through, when I register a user, ASP.NET creates the ASPNETDB.MDF file and it is supposed to show up in my APP_DATA folder upon refreshing in the solution explorer. The problem is, for me it is not and I want to have a look inside so I can understand it's structure.I can continue to run the project and login as the user I created, yet the ASPNETDB.MDF file is still not visible under the APP_DATA folder.
I am currently developing a website currently in ASP.NET. I need to give the current ready website to another collaborator to continue with the work. But how do I send the database along with the website?
If this is done, what steps do I need to follow to use the database on the new machine? Do I need to change web.config or what more?
Unable to add 'App_Data/Database.mdf' to the Web site. Could not find a web server at 'Mysite.com' on port 21. check to make sure that the web server name is valid and your proxy settings are set correctly. If you are sure that everything is correct, the web server may be temporarily out of service.
I have publishing my website at least 1 a week for a year and latelly i am getting this error.When i check the web server everything fines.