Deploy SQL Express In App_Data Directory?
Oct 18, 2010
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.
I deployed using the package feature in VS 2010.
View 1 Replies
Similar Messages:
Oct 1, 2010
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
View 1 Replies
Jul 28, 2010
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.
View 5 Replies
Feb 6, 2010
What am I supposed to write as CategoryPath to get the file in the App_Data folder?
/// <summary>
/// Summary description for XMLHelper
/// </summary>
public static class XMLHelper
{
public static string CategoryPath = "App_Data/Categories.xml";
public static void InsertCategory(string categoryName, string moderator)
{
XElement cat = XElement.Load(CategoryPath);
View 1 Replies
Mar 28, 2011
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?
View 1 Replies
Aug 3, 2010
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?
View 1 Replies
Mar 20, 2011
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.
View 2 Replies
Jul 10, 2010
Can i use web developer express 2010 to deploy applications or is it still in Beta?
View 1 Replies
Apr 13, 2010
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.
View 4 Replies
Aug 5, 2010
Anybody know how to setup a virtual directory in IIS Express for things like Shared Resources? I can't figure out where to set it up in Web Matrix?
View 5 Replies
Apr 30, 2010
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.
View 2 Replies
May 11, 2010
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?
View 2 Replies
Mar 3, 2010
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?
View 2 Replies
May 5, 2010
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:
<identity impersonate="true" userName="enterprise ang09" password="Telcome123"/>
<authentication mode="Windows"/>
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.
View 4 Replies
Feb 18, 2011
I've noticed that ASP.NET automatically creates an App_Data folder for you whenever you make a new webforms application.
Since all of my data comes from a SQL Server 2005 database server, is there any reason to actually keep this folder?
View 8 Replies
Feb 4, 2010
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.
View 2 Replies
Jul 13, 2010
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
View 2 Replies
Apr 4, 2010
I want to write an .xml file using the following code into the App_Data/posts, why is it causing an error:
Stream writer = new FileStream("..''App_Data''posts''" + new Guid(post_ID.ToString()).ToString() + ".xml", FileMode.Create);
View 2 Replies
Sep 21, 2010
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.
View 1 Replies
Jan 30, 2011
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?
View 4 Replies
Feb 1, 2010
I used aspnet_regsql -W wizard approach to create DB for membership tables. and added script as follows in web.Config
[code]....
View 1 Replies
Jan 7, 2011
My Microsoft Access DB file is in APP_DATA folder. my server is Windows 2003 and I like to know how is the best way to protect this file.
so which one is safer ?
./wwwroot/App_data/Database.mdb
or
./db/Database.mdb
View 2 Replies
Dec 14, 2010
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.
View 1 Replies
Jan 7, 2011
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?
View 3 Replies
Mar 16, 2011
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.
View 10 Replies