Deployed MVC Application Does Not Connect To Database
Nov 4, 2010
My application is working correctlywhen I debug it against my sql express.
Now i have deployed on IIS on another machine with win2008 web server and changed the database connection string.I would like that the application uses always the same user to connect to the database and not to use the identity of the connected user.
Error: Cannot open database "XXXXXX" requested by the login. The login failed. Login failed for user 'NT AUTHORITYNETWORK SERVICE'
I have a ASP.Net program written in C# that uses a database stored in the AppData directory, the program works perfectly on my development (Win7SQL 2008R2) when I deploy to a Win2008R2SQl 2008 R2 server the program is unable to connect to the database. I'm using the connection string below. Several sites suggest I set the Application Pool to use 'Network Service' as this has Modify permission to the AppData directory, I have done this but it still won't work, another site suggested I Application Pool to "Load User Profile = True" but still no joy.
[code].....
I get "Object reference not set to an instance of an object." in my app and "An attempt to attach an auto-named database for file C:inetpubwwwrootADPhonebookApp_DataDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share." in the Application Event Log
I have two PC. In one pc(PC1) i have installed oracle express edition 10g (10.2.0.0 as far as i know). And in another(PC2) i have installed visual studio 2008 sp1. In PC2 the ASP.Net application is running. But i can not connect to the oracle database to PC1. PC1 and PC2 are connected by LAN(TCP/IP {Actually they are connected by wire and given two IP} ) But it was working perfectly while both ASP.net application and database were in the samae PC. ca
i have created several crystal report for my web application, i need to use my application to connect different database on the server which has no problem in the application but when i open the reports created using crystal report, it still connected to the database configured. how can i fix this, is there other way than to use another copy of the application and configure it manually at the each of the reports. i do have pass the logon information to the report using vb.net in which i get the info from the web.config
Dim A As ConnStr = New ConnStr With ConnInfo .ServerName = A.getServerName() .DatabaseName = A.getDBName() .UserID = A.getUser() .Password = A.getPwd() End With
my problem is how to make crystal report to uses all the logon info passed and not use the infor set in the report file
we are migrating existing windows form application to asp.net(3.5) intranet portal, there is a requirement whereby database connection should be made by the logged in windows user. Is it possible to achieve this functionality?
We have deployed an application in iis 6.o. We set cache for 1 hr in that application so that the updated data in the back-end will be visible by the user after 1 hr. If the requested data not available in cache it will fetch from database directly.
Is there any way that I can clear this cache in between 1 hr for some of our testing.
Resetting the website and app pool and deleting temp asp.net files didn't work, I have tested that.
I developed an application locally using the Visual Studio 2008 built-in web server and it is running nice and neat on every single browser. When we deployed it on the IIS6 and open it on IE8, there are rendering issues. The fonts are bigger than the other browsers (which are still nice and neat) and some components just moved around. The generated HTML is the same as the others.
I'm trying to deply a 3.5 Net application developed in VS Web Express and built using the asp compiler. This works fine when tested using an eval version of Win 2008 Standard server on a VM. However when installing on a production Win 2008 Standard server it fails with the message can not load assembly as it has not been signed or the signature does not match. How come this works in one and not the other? The live server has symantec AV installed and running? If this the reason? Have a bit of knowledge ( as all devlopers do) of OS's but am totally stumped by this. If I could even replicate it on the development machine would allow me to move forward. Do i need full Vis Studio? Do I need to sign the DLLs?
If same web application is deployed on three different servers, which things we need to take care of and what things should be common amonges all three?
I know there have been countless posts on these types of problems, and I have read through alot of them as well as doing Google searches, but I have not found anything that applies to my specific situation. If anyone has posted a similar question link me to the post with any appropriate derisive comments . Mods if this is the wrong forum feel free to move the post to the appropriate location.
I am a newbie C# developer. I have been getting my feet wet writing a C# web app for my department. I am using the following system:
Windows 7 Professional Visual Web Developer 2010 Version 10.0.30319.1 .Net framework 4.0.30319. IIS version 7.5.7600.16385 Internet Explorer 8.0.7600.16385CO SQL Server 2008 R2
When I run my application in the VWD debugger everything works fine and looks the way I want it to work. When I deploy to IIS (which is on the same box that I develop on) I start having some issues. Here is a breakdown of the problems I am having:
I have an asp:menu control with orientation set to horizontal. When I initially load the sitre after a deploy the menu displays correctly. But when I go to a different web page in the app the menu switches to vertical and the width of each menu item spans the width of the div that surrounds it. On the same page that causes issues with the asp:menu I also have asp:ComboBox controls that are used to filter information on the page. The combo boxes just look like text boxes. The data that should populate the boxes is not present.
I also have some ajax accordion controls contained in asp:updatepanels, neither of which work. The accordion controls are all expanded, and I cannot collapse them. If I trigger an update the entire page reloads instead of just the specific control.
I do not receive any errors when I browse to the page that causes the problems. It loads just fine everything is just jacked up. Like I said, everything works flawlessly in the VWD debugger. I know the VWD debugger does not use IIS, which makes me think this is an IIS issue, but I do not even know where to start to pinpoint the problem.
I have to design asp.net application which has to work on kiosk system. I don't know anything about the kiosk system .so, whether the asp.net application will work on the kiosk system are not I don't know. So any ideas and any sample examples will be very useful for me to start thanking on those lines.
We have an ASP.NET application running on a webfarm. When we release a new version and copy it to the production servers, occasionally it happens that after a few hours the application reverts to a an earlier code base.Have anyone else experienced something like this? Would sharing an application pool between two applications running different versions of the code make this happen?
Additional information: 3 x web servers running w2k3/iis6 ASP.NET 3.5
I have one asp.net application , when i run this application in the visul studio it run successfully But when i deploy this aaplication and run from iis its show me this error: "Operation must use an updateable query" I am using VWD 2008 express edition database: Foxpro
System.Runtime.InteropServices.COMException (0x80010001): Retrieving the COM class factory for component with CLSID {0006F03A-0000-0000-C000-000000000046} failed due to the following error: 80010001I am getting this error when I publish my Asp.net webfrom on Dev Server. The application opens Outlook 2007 to attach a file through the code. it works fine in local machine and in Dev itself ,but when publish it and try to access it fron the client machine then I am getting the error.
We have an ASP.NET application deployed on 2 Application servers with load balancer server. It is using INPROC state management. The ADO.NET connection pooling is enabled with 50 as minimum connections and 100 maximum connections.
In Load testing (using load testing tool) when the application reaches to 50 users no more users can connect (login) to application the TPS reaches zero. No errors are logged in application log related to application or database. The sessions are working fine.
I have created a web application and an SQL database using Web Developer 2010 Express. I have SQL Server 2008 and SQL Server Management Studio Express. In order to deploy the database to my hosting space I need to create a .BAK file from my new database. I think I can do this from with the Management Studio, but can't figure out how to get it to connect to the database. I have used Management Studio before to retore another SQL database and the only connection I see when I open the Management Studio is the old connection to the old database. How do I connect to my new database?