Accessing Data In Internal Production Databases From A Web Server In DMZ?
Nov 9, 2010
I'm working on an external web site (in DMZ) that needs to get data from our internal production database.
All of the designs that I have come up with are rejected because the network department will not allow a connection of any sort (WCF, Oracle, etc.) to come inside from the DMZ.
The suggestions that have come from the networking side generally fall under two categories -
1) Export the required data to a server in the DMZ and export modified/inserted records eventually somehow, or
2) Poll from inside, continually asking a service in the DMZ whether it has any requests that need serviced.
I'm averse to suggestion 1 because I don't like the idea of a database sitting in the DMZ. Option 2 seems like a ridiculous amount of extra complication for the nature of what's being done.
Are these the only legitimate solutions? Is there an obvious solution I'm missing? Is the "No connections in from DMZ" decree practical?
Edit: One line I'm constantly hearing is that "no large company allows a web site to connect inside to get live production data. That's why they send confirmation emails". Is that really how it works?
View 6 Replies
Similar Messages:
Dec 10, 2010
I built an ASP.NET 4.0 Web Site. It works perfectly on my development computer. However, when I deploy the web site to theProduction Server, which is a Win2003 Small Business with Sql Server 2000, the site can't connect to the database.
These are the different tests I've made:
I tried using Integrated Windows authentication and this connection string: Data Source=myServerAddress;Initial Catalog=myDataBase;Integratedsecurity=true; and the error I got was that NT Authority/Network Service couldn't open the database. So I added that account to my database users list and gave it the appropiate permissions. Nothing.I tried using Sql Server authentication, so I created a new database user with a password and changed my connection string toData Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;. Nothing. I still got the same NT Authority user message.I deleted the used I created in step 2 and used the same connection string, to see if this time I got an error saying something about my user, and indeed it happened. I got an exception saying that user myUsername couldn't log on. I then created the user again, ang got the NT Authority user message one more time.I created a console application that used the same connection string from steps 2 and 3, and it connected to the database witouth any problem, which made me think that my problem's got something to do with my Web.config.I tried enabling impersonation on my Web.config, and thos time I got the same error message, only referring to the user I logged in to Windows, instead of NT Authority/Network service. What else could I check? My Web.config is this in case it helps (I havn't really put anything into it other than what VS puts):
[Code]....
View 10 Replies
Oct 22, 2010
Hoping someone can point me to a solution, haven't been able to find one yet.
I'm using the standard way for send HttpWebRequest
[Code]....
As you can see from Fiddler/SOAPUI it does return the SOAP fault, however using HttpWebRequest i can't capture the response.
Returning 500 triggers my exception handling and Capturing the WebException doesn't expose the response.
Does anyone know how to capture this response xml in the case of 500 Internal Server Errors.
View 1 Replies
Jan 6, 2010
I'm very new to ASP.Net, but I've put together a reasonable site. I have used the user account and rolls which come with VS.
This all works fine for me, but I want to be able to change user's rolls and folder security when the site is live.
Is there any way of accessing the ASP.Net Web Site Administration Tool once the site has been moved to a production server?
If not is there any easy way to accomplish this other than write pages to do this yourself?
View 7 Replies
Jan 28, 2010
I want to use MYSQL database for accesssing the data in a mvc application. The connection string that i am using in web.config is:
<add name="ConnectionString" connectionString="server=localhost;user id=root;Password=abcd;database=database" providerName="MySql.Data.MySqlClient"/>
Then I have prepared a model,controller,view for accessing and displaying the data. I am using LINQ o get the data from database but getting the exception:" 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)" I have also installed the MYSQL connector. provide me the solution to access the data using MYSQL and LINQ in MVC application
View 2 Replies
Jul 8, 2010
how to transfer my data from devlopment server to production server ,i have already records exist in my database if i go for script then how can i transfor record in script i can transfor only table ,procedure and views.I am using SqlServer 2005.
View 2 Replies
Mar 8, 2011
I am developing web application using asp.net. Here i need to access two databases in which one is present on other server. I am able to connect to database present in same server but not with database present in other server.
I am using MS-access. I dont know the changes to be done and syntax for database connection.
View 3 Replies
Oct 20, 2010
I am trying to create a website that takes input from users and then updates a table in MS Access db. I have a plain html form that takes the imput and in the action I entered the asp file name. Once a user clicks on submit on the html page I get the 500 internal server error. I properly uploaded the files on the server,
I have created a DSN on the server, but cannot see the DSN under the "Select ODBC DSN" when I try to create a connection from DreamWeaver. I am using a 64 bit machine so nto sure if that might be causing the problem. Here is code form asp file :
<% @ Language="VBScript" %>
<% Option Explicit %>
<html>
<head>
<title>Form to database</title>
</head>
<body>
<%
'declare your variables
Dim name, email, comments
Dim sConnString, connection, sSQL
' Receiving values from Form, assign the values entered to variables
name = Request.Form("name")
email = Request.Form("email")
comments =Request.Form("comments")
'declare SQL statement that will query the database
sSQL = "INSERT into users_tbl (name, email, comments) values ('" & _
name & "', '" & email & "', '" & comments & "')"
'define the connection string, specify database
'driver and the location of database
sConnString=("Provider=Microsoft.Jet.OLEDB.4.0;Data Source='d:/hosting/6859771/html/access_db/Users.mdb';User Id=;Password=")
'create an ADO connection object
Set connection = Server.CreateObject("ADODB.Connection")
'Open the connection to the database
connection.Open(sConnString)
'execute the SQL
connection.execute(sSQL)
' Done. Close the connection object
connection.Close
Set connection = Nothing
response.write "The form information was inserted successfully."
%>
</body>
</html>
View 1 Replies
Jun 7, 2010
we are planning to use ASP .NET and Oracle Database, however, I don't know what are the requirements for developement/Production machine besides .NET Framework and Visual Studio 2008 Express edition.I am confused between various providers.
Developement:
.NET Framework/VS 2008 Express.
Production Server.
Win2003 Server with IIS
please correct me if I am missing any other elements required to connect to a remote DB Server or Local one. If any provider is needed how do you deploy it at production server?
View 3 Replies
May 15, 2010
[Code]....
View 1 Replies
Mar 10, 2010
what is the difference in C# between the access modifiers internal and protected internal?
View 4 Replies
Feb 1, 2010
VB.NET 2.0, windows forms applications. I have two applications, A and B. A accesses a remote Oracle database already, B needs to access a different database, but also Oracle, from the same outside source.So, I thought it would be easy; copy code to connect, change the query, and off we go. But I keep getting the old ORA-12154 error that it can't resolve the connect identifier.First, I developed the query usng sql plus connecting to the target database. So, I know the machine has appropriate entries in tnsnames.ora.Second, I cut-and-pasted the block of code from B into A and gave A a test. It successfully connects and runs the query. So, I know that the data source, user id, password and sql are o.k.Third, I looked in the registry (HKEY_LOCAL_MACHINESOFTWAREOracle) and found the all ORACLE_HOME paths that were set up. Went down all those paths to insure the tnsnames file had my new connection defined.Fourth, I'm able to find the database B is trying to get to via tnsping from the command prompt.Fifth, I copied the connection string from A to B, just to see if it could connect to the database A is known to connect to. Same exception.So, everything connects everywhere except B, who cannot get to Oracle at all. I just can't find what's telling B to use a different tnsnames file (maybe?).Missing something obvious, no doubt.[Edit]I realized overnight I hadn't shown how I was connecting. (The exception is thrown trying to open the connection.) Pretty simple:
[Code]....
[Code]....
View 2 Replies
Jan 14, 2010
I'm writing an application that will be accessed by different groups of users. I have one aspnetdb for logon; then depending on which group a user belongs to, I want to point them at a different 'content' database. Each user wants similar information, but unique to each group, so the schema of each database will be the same, but the content will be different. We're probably talking a dozen or so groups here.
What's the best way to achieve this? Would roles do? I could put each user into a specific role, group1, group2 etc, then check which role a user was in and use a connectionstring in the web.config file based on that. This seems like it would work, but it seems a bit of a cludge. A dozen or so connection strings doesn't seem too much of a problem, but it doesnt' really seem the correct use for roles.
View 7 Replies
Nov 11, 2010
sorry for buther I'm a newbie in ASP.NEt MVC and I have some issue deploying my application on IIS, that use a logo image within my main master page declared as
<img src="../../Content/logo.bmp" alt="logo" />
When I use the internal visual studio web server work well but not on my other IIS Server.
What's the mean of ../../Content ? Is this directory deployed with particular rules?
View 2 Replies
Mar 28, 2011
I wanted the step by step connection details of connecting Oracle 10g express edition to a ASP.net MVC application.
Please let me know .. if at all I have to install any dlls for the same and what are the pre-requisites for the same.
View 1 Replies
Apr 2, 2010
I wrote a stored procedure call with the format:
bool isValid=true;
using (OracleConnection myConn = new OracleConnection(connectionString))
{
OracleCommand myCmd = new OracleCommand("sproc", myConn);
myCmd.CommandType = CommandType.StoredProcedure;
myCmd.Parameters.AddWithValue("p1", a1);[code].....
Second format just doesn't feel right but I am not that experienced. I am curious if there is any downfall to that other than exception not being type specific.
View 4 Replies
Jan 21, 2011
I have created my site using ASP.NET Personal Starter Kits 3.5. I use Visual Studio 2008 only . .with its built-in SQL Server (2005 Express) ... my database in App_Data is ASPNETDB.MDF ...
I have created some of my tables also ....in ASPNETDB ..
In my local PC the site was running fine ...
But when I publish my site on production server it doesn't work and shows the following error
<!-- Web.Config Configuration File -->
<configuration>
<system.web>
<customErrors mode="Off"/>
</system.web>
</configuration>
Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's configuration tag to point to a custom error page URL.
<!-- Web.Config Configuration File -->
<configuration>
<system.web>
<customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/>
</system.web>
</configuration>
My hosting provider connection string ..
<add name="ConnectionString" connectionString="Data Source=69.16.253.19;Initial Catalog=usa_data;Persist Security Info=True;User Id=user;Password=pass" providerName="System.Data.SqlClient"/>
My hosting provider gave me the connection string to connect to the SQL Server 2005 but it doesn't work...
I don't understand why my site was running fine using the production SQL Server 2005 in my local PC when I include ASPNETDB.MDF file in App_Data in my local pc only ..if I remove file ASPNETDB.MDF from App_Data of my local pc ... the site stops working ...
Can anybody tell em how to fix this ... !! I am very tensed since last 3-4 days
View 1 Replies
Sep 30, 2010
I create a dynamic dropdownlist to select several values, in developer server it's everything ok but in production server, when the postback happens lost the selected value.
View 4 Replies
Jan 11, 2011
I am working on the migration of the server. Our new server is Windows server 2008 with IIS7.0 I have a great difficulty in browsing the pages hosted in virtual directories. I have followed the proper steps of creating a virtual directories and converting them into applications. But when i try to browsing the pages of the virtual directory, i get the 404 error. Note: The .Net Framework 4.0 is installed on the server and the web applications which i am trying to configure in the virtual directories are developed in Visual Studio 3.0. Even the http://localhost also don't work.
View 9 Replies
Oct 19, 2010
Im using Google Analytics Dashboard Control which are available at [URL] Issue is its working fine when im connected to internet but if im using it on a machine that doesnt have internet access then it shows Server Error in '/' Application. The remote name could not be resolved: '[URL]' I want to catch this exception and shows a friendly message to user. Im calling these dashboard control on my View in an iframe like this <iframe src="../../GoogleAnalytics/Visitor.aspx" height="275"></iframe> and if i place try catch in Visitor.aspx page it doesnot catch the exception. How should i catch this exception, Im using asp.net mvc 2 with c#
View 3 Replies
Nov 4, 2010
I have a heavy traffic aspx page calling a web service upon every user`s request as follows.
string uri = "Path.asmx";
string soap = "soap xml string";
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(uri);
request.Headers.Add("SOAPAction", ""http://xxxxxx"");
request.ContentType = "text/xml;charset="utf-8"";
request.Accept = "text/xml";
request.Method = "POST";
using (Stream stm = request.GetRequestStream())
{
using (StreamWriter stmw = new StreamWriter(stm))
{
stmw.Write(soap);
}
}
WebResponse response = request.GetResponse();
response.close();
Everything is working fine but sometimes I am getting the following error. The remote server returned an error: (500) Internal Server Error. at System.Net.HttpWebRequest.GetResponse() Does anybody have any idea about this error or can anybody tell me if I am doing wrong.
View 2 Replies
Jul 26, 2010
I have a web application runs @ Windows 2008 R2, ASP.NET v4.0.
I installed the Url Rewrite Module, and started to use it as shown in the official examples.
My problem starts when the <rewrite> tag is added to the web.config under <system.webServer> - actually when I try to browse to any page under this current application, I get 500 - Internal server error.This is the <rewrite> block I've been adding:
<system.webServer>
<rewrite>
<rules> [code]....
View 1 Replies
Feb 7, 2010
I've never had this problem before, I'm at a total loss.
I have a SQL Server 2008 database with ASP.NET Forms Authentication, profiles and roles created and is functional on the development workstation. I can login using the created users without problem.
I back up the database on the development computer and restore it on the production server. I xcopy the DLLs and ASP.NET files to the server. I make the necessary changes in the web.config, changing the SQL connection strings to point to the production server database and upload it.
I've made sure to generate a machine key and it is the same on both the development web.config and the production web.config.
And yet, when I try to login on the production server, the same user that I'm able to login successfully with on the development computer, fails on the production server.
There is other content in the database, the schema generated by FluentNHibernate. This content is able to be queried successfully on both development and production servers.
View 2 Replies
May 6, 2010
I have create a report in sql server 2005 & want to deploy on production server, in local system it deployed & works well. also if that report deploy at local system successfuly than how i see report in intranet.
View 2 Replies
Mar 22, 2010
I am wondering the best way to change my connection string based upon which server I am accessing.
Essentially, all of the development is done on our local machines - once we think it is working, we upload it to our development server. In these 2 instances, I want my application to go off of our "dev" connection string for the SQL database in the web.config.
However, once it is published to our production server (for an internal application), I would like the connection string to point to our live db.
I am using the N-Tier model by Imar Spaanjaars - and have it setup like he suggests - In my DAL I have a class called AppConfiguration -
In this class I have a public readonly property ConnectionString() which returns the connection string in the web.config.
This is in an individual class library. What I would like to do is something similar to:
If server is localhost OR devstring return devString else return productionstring
View 1 Replies