How Does Web App Connect To Remote Sql Server

Jan 25, 2011

I have 2 servers. the database server (DB1) which has sqlserver installed and the application server (WEB1) which has my web application. They are both on the same network and both have the same administrator login.

My web application on the application server needs to access the database on the database server. sqlserver is set to mixed mode in security. i created a random sqlserver user login that can only access my database and set it as the db owner. I use the username and password for this in my connection string. when i run my web application i can read information but i cant write to the database. My app is using windows thentication. I have set my NT AUTHORITYNETWORK SERVICE account to db_owner for my database as well... grabbing at straws!

Question 1: When my application talks to sqlserver does it use the administrator login or the NT AUTHORITYNETWORK SERVICE account which i got from using windowsidentity.getcurrent()?

Question 2: If I use ASP.Net impersonation, what does this do exactly? Because if i run the ndowsIdentity.GetCurrent() i get the username that i specified. How does this tie in with my connection string?

Question 3: If I dont use impersonation what and how do i have to configure sqlserver to accept my insert/update requests? Do i need to work with the NT AUTHORITYNETWORK SERVICE? or can i just use my user login? What do i need to add or remove from my connection string? (see below).

[code]....

View 7 Replies


Similar Messages:

ADO.NET :: How To Connect To Remote Database (SQL Server) Using C#

Feb 28, 2011

how to connect to remote database(SQL server)using c#

View 2 Replies

Connect To Remote Server IP Using MSSQL2005?

Jan 18, 2011

I have a following details provided by our mssql2005 database provider

Server IP : 100.20.255.34
Databaase name : insss
User: nas0
password : ymkv45SEv

i have the following connectionstring in my web.config file in my offline site as :

<add name="ConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|ASPNETDB.MDF;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>

I want

how to edit my web.config connection string mentioned above using the details provided above so that it connect to my MSSQl2005 hosting provider .... ?

I don't know how to edit connection string to do that !!

When i run my site www.vbi.volvobusesindia.com then the following error occurs in top of the page ...

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)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)

View 1 Replies

DataSource Controls :: How To Connect Server Explorer To A Remote SQL Server Database

Mar 13, 2010

I have created web pages using VS Web Developer that use a local Developer Edition of SQL server database on my PC with LINQ to SQL. When I deploy my website to a remote web host SQL server, I need for my web pages to be able to use the remote database instead of the local database. So, how do I get the Server Explorer to connect with a remote SQL Server database?

View 6 Replies

Read All File Names On Ftp Server / Unable To Connect To The Remote Server

May 27, 2010

I tried this code by inputting the ftp address as ftp//: and the correct username and password and I get the following error

"Unable to connect to the remote server" on line :

FtpWebResponse Response = (FtpWebResponse)Request.GetResponse();I tired this on my ftp server provided by a hosting service and an anonymous ftp located at 193.166.120.5 ?

Note: I was able to connect to both of these ftp through filezilla, via a webbrowser, and through windows command line.

View 1 Replies

SQL Server :: 2008 Connect To A Remote Server - Network - Related Or Instance - Specific Error

Aug 4, 2010

I am using Sql Server 2008 to connect to a Remote Server. Everything was working fine for the last couple of months, and i was successfully connecting to the remote server. Today it suddenly stopped connecting to the remote server. note that i did not alter any configuration settings. Did my isp block Sql Server. My ISP is using ISA SERVER? The error details are:

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) (.Net SqlClient Data Provider) I am using Microsoft Firewall Client For ISA Server for opening ports. But today nothing is working.

View 1 Replies

VS 2008 How To Connect To A Database On A Remote Server

Apr 15, 2010

We have a database on our server, here at the office. We now want to create a asp.net website that will be accessible to the public.

Say the domain of the website is [URL] and it's hosted on a webserver of HeartInternet.

When someone connects to that domain, that webpage must be able to pull data from our server that is located here in our office.

In other words the webpage cannot just load data out of the MySQL database loaded on its server, but it has to connect to our server and get data.

View 3 Replies

C# - SmtpClient - Unable To Connect To The Remote Server

Jul 13, 2010

I am working on a project where one of the requirements is to re-write an ASP.NET application. The old ASP.NET application was based on .NET Framework 1.1. The new ASP.NET application is based on .NET Framework 3.5.

One of the functions in the old web application was the ability to send email. The old code used the System.Web.Mail.SmtpMail class, whereas the new web application uses the System.Net.Mail.SmtpClient class.

In testing this on our development servers, everything worked fine. However, we have two beta clients testing out our software, and they both run into problems sending email in the new web application.

The specific exception is as follows:

"Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it"

Both the old and new ASP.NET application are on the same server (Windows Server 2003). They both are using the same Exchange mail server. Why is it that the old ASP.NET application can successfully send email, but the new one cannot?

I looked at the old code, and it did not use any form of authentication, it just specified the sender's email address, the recipient's email address, the subject, body, and server, and sent the message. I did the same thing in the new code, with the only difference being that I used the SmtpClient class.

Below is a code snippet from the new ASP.NET application:

System.Net.Mail.MailMessage mail = new System.Net.Mail.MailMessage();
mail.To.Add(messageTo);
mail.From = new MailAddress(messageFrom);
mail.Subject = messageSubject;
mail.Body = messageBody;
SmtpClient client = new SmtpClient();
client.Host = smtpServer;
client.Send(mail);

View 3 Replies

Unable To Connect To Remote SQL Server 2005

Jan 19, 2011

I have created my asp.net website using database ASPNETDB.MDF but when I try to host my site on server ...

The SQL Server 2005 hosting provider issue me the

database name dobriyalji
server ip : 69.112.222.220
database username : XXXX
database password : XXXX

I have imported all of my ASPNETDB.MDF tables to my server database dobriyalji ...

And I empty the Appdata.mdf and aspnetdb.log file from App_Data Folder ...

When I try to run my site the following error occurs ...

An attempt to attach an auto-named database for file UsersAshish DobriyalDocumentsVisual Studio 2008WebSitesVOLVOApp_DataASPNETDB.MDF

failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

MY LOCALHOST CONNECTION STRING :

<connectionStrings>
<add name="ConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|ASPNETDB.MDF;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
</connectionStrings>

MY REMOTE HOST CONNECTION STRING :

<connectionStrings>
<add name="vbi_india2kConnectionString" connectionString="Data Source=69.112.222.220;Initial Catalog=dobriyalji;Persist Security Info=True;User ID=XXXX;Password=XXXX" providerName="System.Data.SqlClient"/>
</connectionStrings>

View 2 Replies

C# - Unable To Connect To The Remote Server From Windows Service

Nov 9, 2010

I have got this error

Unable to connect to the remote server

when I call the web service from the windows service. But I can visit this web service through IE and I also wrote another console application to call the web service and it works fine, too.

The exception infomation is below:

A socket operation was attempted to an unreachable network 127.0.0.1:8888

Here is my code:

WebImageSVC webSvc = new WebImageSVC();
ConfigManager.LoadConfigManager();
webSvc.Url = ConfigManager.WebSvcAddress;
webSvc.Proxy = null;
webSvc.CanUpload(0, "");

I try many methods, like turn off the firewall and anti-virus software, set the web services proxy property to null. but still cannot solve this issue.

View 2 Replies

Asp - SmtpClient.Send Exception - Unable To Connect To Remote Server

Mar 6, 2011

My site sends confirmation emails from a purchase. 95% of the time, it works. The other 5% after clicking the 'Confirm' button that runs the payment and should send the email, i get the following exception:

Details:
Exception: Failure sending mail.

Inner Exception: Unable to connect to the remote server

Inner Exception(2): A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 72.167.234.197:25

The code to send the email is this:

Dim smtpClientPayPalSuccess As System.Net.Mail.SmtpClient = New System.Net.Mail.SmtpClient()
smtpClientPayPalSuccess.Host = "relay-hosting.secureserver.net"
smtpClientPayPalSuccess.Send(mailMessagePayPalSuccess)

FYI: I have confirmed with the hosting that I don't need any credentials, or a different port number than 25. This is also running over https. why this would be happening only a small percentage of the time?

View 2 Replies

Web Forms :: How To Connect Website To PostgreSQL Database On Remote Server

May 7, 2015

I have amazon cloud aws, i am developing a website in asp, i have remote RDP access to my server..

So i have not installed postgreSQL etc.. but i am unable to connect to that database.. and when i install and run on my local system, it connect.

View 1 Replies

SQL Server :: Unable To Connect To Remote Server

Aug 9, 2010

I have a problem, my database reside on a separate server and my online website need to access that server to get some data. The server is in my office and connected with Internet.

I have configure the SQL server 2005 on the server to allow remote connections. Enabled TCP/IP and named pipeline. The port is 1433.

I give following connectionstrings.

1. <add name="DatabaseConnectionString" connectionString="Data Source=nt1111;Initial Catalog=testdatabase;Persist Security Info=True;User ID=test;Password=***" providerName="System.Data.SqlClient"/>

2. <add name="DatabaseConnectionString" connectionString="Data Source=nt1111;Initial Catalog=testdatabase; User ID=test;Password= "***"; User Instance=False" providerName="System.Data.SqlClient" />

3. The same as 2 but with IP <add name="DatabaseConnectionString" connectionString="Data Source=999.99.9.99;Initial Catalog=testdatabase; User ID=test;Password= "***"; User Instance=False" providerName="System.Data.SqlClient" />

View 13 Replies

MVC :: Executing The Command Definition And Error Is Generated Connect With Remote Server?

Oct 21, 2010

In my mvc asp.net application,I am getting error in edit function : in given code

[Code]....

I am getting this exception:

Source : System.Data.Entity

Stack Trace : at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand
entityCommand, CommandBehavior behavior) at
System.Data.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext
context, ObjectParameterCollection
parameterValues) at
System.Data.Objects.ObjectQuery

[Code]....

1 forMergeOption) at System.Data.Objects.ObjectQuery

[Code]....

1 source) at
System.Data.Objects.ELinq.ObjectQueryProvider.b__0[TResult](IEnumerable

[Code]....

1 query, Expression queryRoot) at
System.Data.Objects.ELinq.ObjectQueryProvider.System.Linq.IQueryProvider.Execute[S](Expression expression) at System.Linq.Queryable.First[TSource](IQueryable`1
source) at admin.com.Controllers.DocsGridController.Edit(Int32 id) in
c:DataFinalCodeAC015acomMVCSourceCodeadmincomControllersDocsController.cs:line
307

Message : An error occurred while executing the command definition.See the inner exception for details.This error is generated when I connect with remote server.

View 2 Replies

Can't Send Smtp Email From Network Using C# Error / Unable To Connect To The Remote Server

Apr 1, 2010

I have my code here, it works fine from my home, where my user is administrator, and I am connected to internet via a cable network.

But, problem is when I try this code from my work place, it does not work. Shows error:

"unable to connect to the remote server"

From a different machine in the same network:

"A socket operation was attempted to an unreachable network 209.xxx.xx.52:25"

I checked with our network admin, and he assured me that all the mail ports are open [25,110, and other ports for gmail].

Then, I logged in with administrative privilege, there was a little improvement, it did not show any error, but the actual email was never received.

note that, the code was tested from development environment, visual studio 2005 and 2008.

try
{
MailMessage mail_message = new MailMessage("xxxxx@y7mail.com", txtToEmail.Text, txtSubject.Text, txtBody.Text);
SmtpClient mail_client = new SmtpClient("SMTP.y7mail.com");
NetworkCredential Authentic = new NetworkCredential("xxxxx@y7mail.com", "xxxxx");
mail_client.UseDefaultCredentials = true;......

View 4 Replies

File Upload Error/exception Details: System.bet .webexception. Unable To Connect To The Remote Server

Mar 2, 2010

I had this one working a while back i try to upload file to my root folder it works locally but when i try it from my website i get the following error: exception details: system.bet .webexception. unable to connect to the remote server

the code bomb at the following line

requestStream = uploadRequest.GetRequestStream() 'This is where the exception occurs
fileStream = File.Open(localFile, FileMode.Open)
[code]....

View 2 Replies

About "Unable To Connect To Remote Server." Using HttpWebRequest?

Aug 24, 2010

about "Unable to connect to remote server." using HttpWebRequest?

View 4 Replies

Web Forms :: Request.GetResponse Error Code 10060 "unable To Connect Remote Server"?

Aug 3, 2010

When i try to execute the code below i get the error "unable to connect to remote server".

The internet connection is set and if i copy and paste the serviceurl directly on the browser it works.

public string GeoCode(string address)
{
if (String.IsNullOrEmpty(address)) throw new ArgumentNullException("address");
string ServiceUrl = "http://maps.google.com/maps/geo?output=xml&q={0}&key={1}&oe=utf8";
string url = String.Format(ServiceUrl, HttpUtility.UrlEncode(address), MyApiKey);
System.Net.HttpWebRequest request = (System.Net.HttpWebRequest)System.Net.WebRequest.Create(url);
request.Method = "GET";
using (System.Net.WebResponse response = request.GetResponse())
{
return response.ToString();
}
}

View 2 Replies

Trying To Connect To A Remote Debugger For VS2008-SP1?

Jun 28, 2010

I'm having problems trying to connect to a remote debugger for VS2008-SP1.I'm trying to debug an ASP.NET application on a Win2k8 VM. The host PC (WinXPsp3) running Visual Studio is connected to an AD domain, and is logged in with a domain account. The VM is not connected to the domain and is logged in with the local Administrator account.The VisualStudio remote debugger requires authentication in both directions, so I would normally add my domain account as a local admin on the VM and allow debug permissions for that user.Since the VM is not on the domain, I can't add my domain account as a local admin. What can I do to get remote debugging going between my PC and the VM?

View 3 Replies

C# - How To Connect To A Remote Oracle Database

Feb 20, 2010

I have Oracle (10g Express Edition) installed on one pc.

Visual Studio 2008 SP1 is installed on another pc.

I want to run an ASP.NET web app that uses the remote database. The two PCs are connected by a LAN (wired) connection. How can I connect to the database? What will the connection string be? The operating system on both PCs is Windows XP.

View 2 Replies

Is It Possible To Connect To A Remote Desktop From Application

Dec 3, 2010

Is it possible to connect to a Remote Desktop from my ASP.net application,If so can you guide me through it.

View 1 Replies

Databases :: Connect With Mysql On Remote Pc

Jan 18, 2010

I am trying to connect asp.net with mysql on remote pc. When i am connecting asp.net with localhost mysql it is working properly but when i change "localhost" with IP address it show error.

View 4 Replies

C# - Cant Connect To Remote MS Access Database

Mar 17, 2011

I keep getting a

InvalidOperationException: ExecuteReader requires an open and available Connection. The connection's current state is closed.]

It is because my connection is closed. What is wrong with my connection string? Why won't it open.

[Code]....

View 2 Replies

Databases :: MySQL - Can't Connect From Remote Client Code

Sep 29, 2010

I have a MySQL data at a web hotel. I can connect to the database from my web application hosted at the hotel . But trying to connect from a client application running on my PC fails using the same ConnetionString. The error is: Unable to connect to any of the specified MySQL hosts

In fact the method below (the method is protected in the web application) fails in my client application but works in my web application.

[code]....

I just tried to download WorkBench 5.2 and HeidiSQL, both connects to the database from my PC when supplying server and password information.

View 1 Replies

Databases :: How To Connect To A Remote Oracle With Visual Studio

Jul 30, 2010

How to connect to a remote oracle database with Visual Studio?

I know how to create the connectionSting in web.config. I wonder if I can connect to an oracle database when creating a LINQ class so that tables will show in the Server Explorer.

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved