.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Fetch Data from sql server having different physical address or ip address

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :Sql Server


I have this sql server xxx.xx.40.221 where i am writing cursor.

I want to fetch data from xxx.xx.1.153 sql server.

But as you can see these two databases are on different physical locations, how m i suppose to do.

I m counting on u guys. Please help me!!


View Complete Post

More Related Resource Links

IP Address Blocking or Restriction in SQL Server

"is it possible to block connections to SQL Server based on IP address". As far as now there is no official way in SQL Server to block the connections in SQL Server based on IP address. However this can be done from the OS end, we have the following three options available, refer HERE for more.

.RRAS IP Filter

Error Firefox has detected that the server is redirecting the request for this address in a way tha

The page isn't redirecting properly                                                        Firefox has detected that the server is redirecting the request for this address in a way that will never complete.                            *   This problem can sometimes be caused by disabling or refusing to accept          cookies.

Get Development Server to bind to a different address


does anybody know how to tell Development Server to bind to a different address?

By default, it binds to "" and this doesn't let other computers on the same network access the web application.

I guess there should be a web.config section but I can't sort it out


Thank you!

Windows 7 socket bind behavior difference from XP/Server 2003, with reuse address socket option (WSA


I have two processes that are both listening to UDP packets and can run on the same PC.  One process binds a socket to one NIC address with port 18246.  The other process has two Socket objects, one for sending on port 18246 and one for listening on port 18246.  Both of these sockets are created, have the SO_REUSEADDR socket option set.  Bind is called for a single IP Endpoint for a common local NIC address, but a different one than used by the above app.

Under Windows XP and server 2003, both processes can bind regardless of order of startup.

Under Windows 7, if the process with only one socket starts first, the second process fails with WSAEACCES 10013 error with the second socket bind.

I wrote a sample C# app with the following method that fails when running under Windows 7 x86 and x64.  The above failure occurs when the sockets are in separate processes, but a single process using the same socket interaction also fails.  The below method is called with two IPV4 addresses that are assigned to local Network adapters on the PC.

Retrieving Global Address List from Exchange Server


Hi everyone,

This is my 3rd post, always getting great help from here.

My last two questions were about sending email through ASP.NET, and adding web form to that email body, which is working :)

This time my boss wants me to send email addresses from our exchange server global address list. :(

For example,

Dropdownlist for send from who,  Dropdownlist for recieving person...The behind values should be email addresses.

And this information should come from global address list on our exchange server.


I am very newbie to ASP.NET so please instruct me step by step, what is the steps I need to do, very specifically please.

Thank you advance!!!



WCF Service to be hosted on the server with multiple IP Address


Hello all,

I am new to WCF Service. Following is my scenario

I have got a Windows Server 2008 with two NIC ie. two IP Addresses



I have got Apache server running on 1 and IIS on 2.

Now when I publish the WCF service on my service and have explicitly set the iplisten for IIS to 2. Still I am not able to access the service.

One more observation the link which I get after publishing is "svcutil.exe http://servername/Webservice/Service.svc?wsdl "

I need to have IP Address instead of servername in above URL.

Because I think the servername is causing the confusion as both IP Address 1 and 2 point to it.

Please suggest what needs to be done

Thanks in Advance.

How to connect a remote Sqlserver 2008 r2 server with IP address and port? I use SMO and VS2010.


how to write SMO's conn.ConnectionString with IP address and port?

SQL Server Remote Access not work with Live IP Address


I have one server which has OS Windows 2003 Server I have installed SQL Server 2005 Express Edition in that I have connect my Internet with this pc directly with Live ID.


But when i try to connect SQL server from internet it give me bellow mention error.


TITLE: Connect to Server

Cannot connect to xxx.xxx.xxx.xxx\SQLEXPRESS.


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) (Microsoft SQL Server, Error: -1)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476



MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

my ip address

IP Tejji answers question like what is my ip address? find my ip addresss? detect my ip address? Best part is it also determines your local ip address as well as mac address. Further if you keen on browser specification and details regarding browser capabilities can also be found. It also help you see your geographic location. Other details that are available are Latitude, Longitude, timezone, country, region & city. In short it is one-stop-shop for very rich details about your IP and related information.

Accessing SharePoint 2010 Data with Server-Side APIs

Accessing SharePoint data in server-side solutions is one of the most common tasks that you will perform as a SharePoint developer. SharePoint 2010 provides powerful server-side APIs that enable you to retrieve, add, edit, and delete SharePoint data programmatically. SharePoint 2010 also includes the new LINQ to SharePoint technology that enables you to work with SharePoint data efficiently and easily.

Sorting Data in a GridView Web Server Control

The GridView control provides built-in sorting functionality without requiring any coding. You can further customize the sort functionality of the GridView control by using custom SortExpression property values for columns as well as by using the Sorting and Sorted events

Frequently Asked Questions - SQL Server Data Types

This is good and precise introduction and Frequently Asked Questions - SQL Server Data Types

server side does not save data when using POST data to another URL using WebRequest


 I am using a IIS 7.5 on Windows 7. I have a simple application that uses System.Net.WebRequest to POST data to another URL (in fact, the server side URL is on my local computer and it is hosted in IIS 7.5).

  1.  The problem is the server does not save data from client although on the client side codes when I debug and I see the OK message return from the code line

   response.StatusDescription; // this has value of "OK"
2. How can I debug the server code side where to receive the request from client side who posts the data ?

The following is the codes for client who posts data using System.Net.WebRequest, and codes for server side who received posted data to save to database.

Client side codes: // also run on my local computer

public string PostIntegrationXml(XmlDocument xmlSubmitDoc)




OData and AtomPub: Building an AtomPub Server Using WCF Data Services


Learn how to use the AtomPub protocol to pump up your blogs. Chris Sells includes a practical demonstration of mapping so you can expose a standard AtomPub service from a Web site and use Windows Live Writer to provide a rich editing experience against the service.

Chris Sells

MSDN Magazine August 2010

SOA Tips: Address Scalability Bottlenecks with Distributed Caching


SOA makes application scalability easier, but getting the best performance out of your SOA means paying close attention to the details. We'll give you some tips for coding your app more effectively and using distributed caching to remove data access bottlenecks.

Iqbal Khan

MSDN Magazine June 2010

Under The Table: Spatial Data Support In SQL Server 2008


New spatial data support in SQL Server 2008 opens the door to mapping and querying geometric and geographic data, allowing you to build exciting new applications.

Bob Beauchemin

MSDN Magazine February 2009

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend