CIRCUTOR SQL Data Export User Manual

Page 14

Advertising
background image

SQL Data Export for PS/PSS

14

1.1.- Enable remote connections of the SQL Server

To connect to a database server installed on a machine other than the

one where we have installed the application, you will need to configure SQL

Server for it to accept the connection. Perform the following steps:

1. Enable remote connections in the SQL Server instance to which you

wish to connect from the remote machine.

- Click on “Start  Programs  Microsoft SQL Server 2005 

Configuration tools  SQL Server surface configuration”.

- In Surface configuration of SQL Server, select the surface

configuration option for services and connections.

- Expand the option “Database Engine  Remote connections” and

select local and remote connections and the TCP/IP protocol and

channelling by name

- Click on service, click on Stop, wait until it stops and the click on Start

to restart the service.

-

Advertising