Skip to main content

Tips: How to setup remote server connections

Handling the connections from other servers is completely different from the user connections. Therefore, you can allow if the server should connect to this server and how long it should take remote queries to time out. If you wish to configure the remote connections, follow the following steps.

1.    First, go to the Connections page from the server properties dialog box.
2.    If you wish to allow the servers to connect to this server, it is required to select the option Allow Remote Connections To This Server. Then, the remote servers will log on to the server to execute stored procedures remotely.  You must stop and then start the SQL Server instance to apply the change if you select this option.
Beware: Remote procedure call (RPC) connections are allowed by default. If you change this behavior, remote servers cannot log on to SQL Server. This setting change keeps SQL Server secure from remote server access.



3.    The queries will be executed by the remote servers’ time out in 600 seconds. It is required to type a time-out value in the Remote Query Timeout box on the Connections page to change this behavior. Time-out values are set in seconds, and the acceptable range of values is from 0 through 2,147,483,647. A value of 0 means that there is no query time-out for remote server connections.
4.    Stored procedures and queries executed on the server can be handled as distributed transactions by using Distributed Transaction Coordinator (DTC). If you want to execute procedures this way, select the Require Distributed Transactions For Server-To-Server Communication check box. If you change this option, you must stop and then start the SQL Server instance.

5. Then, click OK.
These options can also be set with sp_configure. The related Transact-SQL statements are:
•    exec sp_configure "remote access",
•    exec sp_configure "remote query timeout",
•    exec sp_configure "remote proc trans",
Note: A value of 0 turns a remote server connection option off, and a value of 1 turns an option on. Check out to perform the steps.

B  y

Popular posts from this blog

New Micro battery, power packed for high performance

For a size of a few millimetres, the new micro-batteries are powerful enough to jump start a car battery and then quickly charge the cell phone. Researchers from the University of Illinois have developed the micro batteries which can be used to drive compact electronic devices and new applications for radio communications. The micro batteries are so good that they can even out power the super capacitors. The results were published in ‘Nature Communications’ in the April 16 issue. The micro batteries have energy and power and with the researchers tweaking the structure of the micro batteries a little bit, its use can be for wide range applications.

The high performance of the micro battery is based on its 3-dimensional micro-structure. Based on the design of fast charging cathode by Professor Paul Braun’s group, researchers developed the matching anode and integrated it with the fast charging cathode at a micro-scale and made a complete battery with high performance. These batteries cou…

HTC Touch Diamond SmartPhone!

The phones design is an innovative in which the user has the geometric form language to make sure a clutter-free environment for screening content. The San Francisco based studio One & Co collaborated with HTC Taiwan Design team to create Diamond HTC smartphone.







The HTC phone is quite wonderful with design and the rapid development in the smartphone market the HTC has taken innovative steps to capture the SmartPhone market HTC develops these kind of new inventive designs.
Inspired

How to Automatically Convert any RSS Feed to an iPhone Web app!

For iPhone users this is another web app which converts any well formed XML RSS feed to an iPhone version. It is possible because it is worked with the typical sliding style interface to suit the iPhone optimized version. For instance if you had the iPhone right now here is the Google News Feed




Jim Liddle, one of the creators of the service, told iPhone Atlas “You can book mark the generated site and use it to host your own content and reference it from your own. It seems that these feed on your iPhone is quiet usable.