Configuration :: Deploying A Web App With Sql Server Database?
Apr 19, 2010
i've written a small application using asp.net and sql server express.
my question is after checking the application in the visual studio environment how can i get it to work in a way that
users that are working on the same network as me could use it to?
i've changed the user instances option in the web.config file to false, and from the info i found so far i understand that security measures are to be applied, but i just couldn't get it to work...
On my local machine I have created a database driven website. All is working well on my local machine.
Now I want to upload it to my Arvixe Hosting. How do I do that from Visual Studio 2010 Keeping in mind I have a Database too ?
Do I need to manually create a Database on the Server ? Do I then create all the tables Manually ? Do I then populate the tables manually ? Or is it a 1 button click ?
I have just developed a website with VS 2008, ASP.NET 3.5. It contains a long range of pages and one contact page. The contact page is connected to a SQLExpress database, where details about all the visitors' requests are stored. The website works fine at the development environment, but when I deploy it to the internet host, the Contact page will not open any longer, due to all sorts of problems with the database. I have the database files located in the App_Data folder under the main directory for the website.
I have tried with all kinds of connection strings, setups, etc. - to no avail. I have also tried using the ISP's tool for creating a new database with the intention of copying the original database to it. But when I use the Publishing Wizard and generate a SQL script, then the Web Administration Tool for the remote database won't run the script. Now my question is, plainly: Is there any step-by-step procedure I can use, if I want a data-enabled website. It seems incredible that it has to be so frustratingly difficult. Basically, what I need, is:
* A database, located in the App_Data folder, to store all information received via the Contact.aspx page. * All visitors of the site should be able to post messages on the Contact.aspx page. * I have got the information from the ISP that I can connect to MSSQL via the server "host55.nethotel.ccSQLEXPRESS".
If a general procedure can be advised, and some directions about how exactly the database should be set up with authentication, rights, etc., for such a - supposedly ordinary - system, then I will be grateful for any information - or somebody who could point me in the right direction of a solution.
I 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:
I developed an application using VS2010 and now when i try to deploy it on windows XP maching running IIS 5.1 i get the database version error which says:
The database '<database file path>' cannot be opened because it is version 655. This server supports version 612 and earlier. A downgrade path is not supported.
<database file path> . Create is aborted.
An attempt to attach an auto-named database for file <database file path> failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
I've added a web reference locally which looks up post codes. All works ok locally. Now I just want to deploy this to my web space. There is a app_WebResources folder with various files that were created when I added this. Basically what I want to know is How do I get all this to work online?
I've been given a virtual dev environment being windows server 2003 and I need to publish a web app to it. I've deployed apps quite easily using the publishing wizard but I'm not sure how to do deploy to a windows server.. can someone please provide a link or a guide on how to do this as I need to set it all up and I really don't know where to start.
I have deployed simple application on production server it just update sql server table via update query.
The problem is That when I run that app on development machine it updates table on remote server but after deploying it on production server and accesing the url on production server/and development machine my code doesn't execute and thus it don't update table.
I have created virtual direcotry and configured app with specific application pool which is custom based Asp.net account.
I am using LocalReport class to render reports locally and then converting reports to pdf format and displaying to user. This works fine on my local machine but gettting error 'Object reference not set to an instance of an object' when deployed to the development site. Do we need to install anything on the host server for localreports to work correctly?
I have built my site using VS.Net 2010 on my XP machine. I would like to deploy it to my server which is a Windows 2003 Server. I have tried to do it with FTP, but it keeps failing with the error that "Front Page Extensions are not installed on the web server". When I check the server the extensions were installed and I also checked IIS and the service for the extension is allowed.
I'm deploying a web site to a server I've set up for testing. The website works great in development (Running in VS 2010) as well as in production on multiple client sites. I'm simply trying to test the site in a new environment. I simply copied the complete site (pages, code, directories, everything...) to my server. In IIS7 I created a new web site pointing to the directory containing my site's files and directories. I can open my site and my initial login page loads.
Database connections are made, page and buttons all seem great. Then, I log in. In the first line of code that attempts to instantiate an instance of a class contained in my App_Code folder, an exception is thrown, 'Invalid object name'. I've messed with as many settings as I could in IIS7 but to no avail. I've searched the internet on something regarding this, but nothing seemed to apply. At this point I'm about ready to install Visual Studio on my server to get it to run (this was the route one of the other developers took).
I need to deploy an asp.net 4 website on a windows server 2003 remote server. I have updated the server's .net framework to 4.0 and installed IIS 7. how to deploy the website because I have no idea how to.
I have a website build with .Net 2.0 Framework, I tried to deploy it in iis 7 ( Windows Server 2008 ). I get the following error when i browse the project. Server Error in '/' Application. Security Exception Description: The application attempted to perform an operation not allowed by the security policy. To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file.
Exception Details: System.Security.SecurityException: Your application is not running with full trust. Please call AspxLab.WebControls.Runtime.Initialize to manually initialize AspxLab Controls runtime environment. Source Error:
[Code]....
Stack Trace:
[Code]....
[SecurityException: Your application is not running with full trust. Please call AspxLab.WebControls.Runtime.Initialize to manually initialize AspxLab Controls runtime environment.]
a..ctor() +540 az..cctor() +140
Version Information: Microsoft .NET Framework Version:2.0.50727.4927; ASP.NET Version:2.0.50727.4927
I am using XAMPP to publish my a .net application. The server is working fine. I created a sample login.aspx file, and it works fine. I deleted the sample login file, and I build and copy all the files to the XAMPP directory. When I tried to acces the page, it gave an error message "Access forbidden! You don't have permission to access the requested object. It is either read-protected or not readable by the server. If you think this is a server error, contact the
I've been using a standard web site in Visual Studio for my site, using the Plesk file manager interface to upload files either singly or in total as a .zip file.Recently I've changed the project to a VS web application.All the documentation that I see refers to using IIS to deploy a web app; if I wanted to just FTP all the source code, I may well have stayed with web site.I've not been able to find any Plesk specific deployment info.
Is there any way possible when my site is hosted to some how attach the process so I can debug the errors. Obviously as they are different environments what works in dev doesn't always work in.
my ASP.NET app works fine on my development PC, but when I deploy it on the server, the Forms Authentication won't work. The page is being redirected to the "login.aspx" page, but when I enter a valid username/password and hit the login button, it also goes to the login.aspx page (with no errors and no throw, it keeps like this forever).
I am using the default ASP.NET Membership provider, I have setup the hosting server to be exactly as my PC, so both have same settings of IIS, ASP.NET 4.0 Global Configuration (in IIS), and SQL Server 2005 Express Edition.
I searched for this problem in google and tried several suugestion (like removing the clear() in web.config, manually add the membership/role provider in web.config, change security in the physical folders, etc...) but with no luck.Below is my web.config (which is working fine in my development PC): [Code]....
I have a web site that has always run fine for years and years under 3.5. I converted it recently to run under 4.0, and it runs on Cassini fine. When I attempt to deploy the app to an IIS7 server that has 4.0 installed, all I get is "internal server error", and no error messages in the Event log, and nothing in the http logs.
I've double checked that the application pool I've deployed to is running 4.0.
It's an x64 web server and app (always has been while it was under 3.5.
I have developed a website using visual studio. Now i want to deploy the same on server having windows server 2008 o.s. and IIS 7. When i copy the website and paste it into wwwroot folder of iis its not working. What settings need to be done so that website can be accessed from iis.
I have created "DotNetNuke SQL Database Application" from the WebMatrix Gallery. Now I want to deploy it on the remote server using Web Deploy method. Without selecting SQL database, application is deployed successfully but when I select SQL database it gives following error: Publish : Error - Make sure the database connection string for the server is correct and that you have appropriate permission to access the database. (Web Deploy provider is dbFullSql).
I have a question regarding deploying a database on a MS SQL Server. I am planing to build a website using ASP.NET technology. I want to implement some administration functionality for the website such as updating images, changing logo, update text information on the website. I am going to build a database that I should deploy on a MS SQL Server. As I understand if I want to keep a database on a MS SQL Server I should pay for it.
I have created a ASP.NET MVC 2 application in VS2010. It runs in integrated development server fine. But when i deploy that in IIS it gives me "The Web server is configured to not list the contents of this directory." error. Anybody know what went wrong?? There is no default.aspx page when creating a MVC2 project in VS2010. is that the problem? I can assure the routes are configured correctly in global.aspx.
