Remote connection with SQL

[Analise]

[IMG]

http://img84.imageshack.us/img84/3047/conexao2.jpg[/IMG]

Uploaded with ImageShack.us
The solution to this problem is solved in five steps

1. Allow remote connections to SQL Server instance that will be accessed from another computer;
2. Enable the TCP / IP connection and traffic information;
3. Start the SQL Server Browser service;
4. Configuring the Firewall to allow SQL Server related information is permitted to pass

through it.

These steps ensure the remote connection to SQL Server. Below each step is explained in detail.

Step 1: To enable computers to access instances of SQL Server on another machine, the first

thing to do is a setting in the instance that you receive remote connections in our case, the

SQL2005 server NGRSERVER.
[IMG]

http://img696.imageshack.us/img696/4097/conexao3.jpg[/IMG]



[IMG]

http://img718.imageshack.us/img718/7180/conexao4.jpg[/IMG]

Uploaded with ImageShack.us
After accessing the Properties screen of the SQL Server instance, choose from the menu on the

left, the Connection option. The right side of the screen is on the Connection, look for the

option "Allow remote connection to this server". Leave this box checked. Click OK.
[IMG]

http://img207.imageshack.us/img207/7892/conexao5k.jpg[/IMG]


The conclusion of this procedure is to ensure that the instance of SQL Server can allow remote

access, but this is not the only step to be fulfilled. More steps must be followed to complete

the task.

Step 2: To enable the TCP / IP traffic information from SQL and connections can be established

through this protocol, we will release it in SQL Server using a tool available to the system

administration tools. "The tool is SQL Server 2005 Surface Area Configuration". This tool by

default, is in the folder Configuration Tools, SQL Server 2005. In this tool we will use the

resources of "Surface Area Configuration for Services and Connections".
[IMG]

http://img542.imageshack.us/img542/1269/conexao6.jpg[/IMG]


Acess "Surface Area Configuration for Services and Connections", expand the menu to the left of

the item instance, in this case, "SQL2005". Then expand "Database Engine", and select "Remote

Connections". On the right screen, select "Local and remote connection", and then "Using

TCP/IP" only. Click OK.
[IMG]

http://img25.imageshack.us/img25/2231/conexao7.jpg[/IMG]



How to Configure Remote Connection in SQL Server 2005


Free Surface Area Configuration for Services and Connections, expand the menu to the left of

the item instance, in this case, SQL2005. Then expand Database Engine, and select Remote

Connections. On the right screen, select Local and remote connections, and then Using TCP / IP

only. Click OK.

This configuration permits now that the selected instance receives local and remote

connections, remote connections are only for TCP / IP. The BOTH option Using TCP / IP and named

pipes could also been used without problems.

Continuing with the TCP / IP, now let's use another tool, SQL Server Configuration Manager.

This tool will use the resource SQL Server 2005 Network Configuration, which is on the left

menu. When you expand this item, find the Protocols for SQL2005. Clicking that will open up

some options on the right side of the screen. The options given, we should leave the TCP / IP

Enabled status. To do this, click the right mouse button on TCP/IP and go to Enabled. After

that, he appears set.
[img]http://d.imagehost.org/0095/conexao8.jpg

[/img]

After setting the status to Enabled, two additional checks should be made to properties of

TCP/IP. To access these settings, click the right mouse button on TCP / IP and then Properties.

A screen with two top flaps will open. The first tab Protocol should be set with the Enabled

property to Yes
[img]http://b.imagehost.org/0093/conexao9.jpg

[/img]
In the second tab, IP Addresses, we must ensure that the Active and Enabled properties are set

to Yes
[img]http://d.imagehost.org/0196/conexao10.jpg

[/img]

After securing these settings, click OK to save our changes.

The changes that were made in both these tools are useful to ensure that the selected instance

of SQL Server can allow remote access and remote connection protocol is TCP / IP.

Step 3: To start the SQL Server Browser service will use again the tool SQL Server

Configuration Manger. To access the area that controls the services of SQL Server in the left

menu, the item will be SQL Server 2005 Services. On the right of the screen, the SQL Server

related services are presented. The SQL Server Browser service meets its State set to Stopped.

To start the service, click the right mouse button on the service and then click Start. This

process will take a few moments, and former State will be Running.
[img]http://b.imagehost.org/0620/conexao11.jpg

[/img]

After starting the SQL Server Browser service, and release settings for remote access and TCP /

IP, the service of SQL Server instance must be restarted for the changes to take effect. To do

this, on the same screen where the service was started SQL Server Browser, select the service

SQL Server (SQL2005), click the right mouse button and point p ara Restart. Wait a few moments

to stop and start the service. Remember that SQL2005 is the instance of SQL Server server that

we use as an example
[img]http://d.imagehost.org/0685/conexao12.jpg

[/img]


Step 4: For remote connections work in SQL Server 2005 the firewall of the network should have

exceptions for instances of SQL Server 2005 and SQL Server Browser service. To illustrate, we

will post those exceptions in Windows Firewall itself. If you use another firewall, you must

read your documentation on the procedure for release of the software used.

The Windows Firewall is on the premises of Windows XP with Service Pack 2 or higher. To access

the Windows Firewall, go to Start> Control Panel> Windows Firewall or type firewall.cpl Start>

Run and click OK. The release in the firewall must be made for each instance that will have

your remote connections allowed. Perform these exceptions in each instance of SQL Server is

required by being allowed to install multiple instances of SQL Server on the same server. Every

installation of SQL Server instance is called, and each instance can have as many databases are

needed and can be repeated or not in one instance or another. To place an instance of SQL

Server in the Firewall exceptions, we open the Exceptions tab of Windows Firewall, click Add

Program, contact the sqlservr.exe file that by default, is in the folder C: \ Program Files \

Microsoft SQL Server\MSSQL.1\MSSQL\Binn.
[img]http://b.imagehost.org/0036/conexao13.jpg

[/img]
[img]http://b.imagehost.org/0591/conexao14.jpg

[/img]
[img]http://b.imagehost.org/0326/conexao15.jpg

[/img]
[img]http://d.imagehost.org/0334/conexao16.jpg

[/img]

The MSSQL.1 folder is the folder on the first instance of SQL Server. If you put an exception

for a second instance of SQL, the sqlservr.exe file must be located in the MSSQL.2.

To put an exception to the SQL Server Browser service, we must follow the same steps that we go

through to get exception to the instance of SQL Server, the only difference will search for the

file sqlbrowser.exe which by default is the folder C:\Program Files\Microsoft SQL Server

\90\Shared.

[img]http://d.imagehost.org/0829/conexao17.jpg

[/img]
[img]http://d.imagehost.org/0187/conexao18.jpg

[/img]

These steps in to help remote connection to the server database via client machines. We can see

that following the steps correctly, the access of applications and administrative tools to be

left alone machine Server Database, and went on to have hits released to other machines on the

LAN (Local Area Network). Recalling that, to access an instance of the database, you'll have to

put a valid username and password for connecting.

-----------------------------------------------------------------------------

Configure your config.php:

IP of dedicated\SQLEXPRESS

ex:

111.111.111\SQLEXPRESS

Credits:
http://www.linhadecodigo.com.br/arti...rver-2005.aspx

and me for translator :p (yes i'm using google translator.)

[MentaL]

[ProGunz]

i know already how but thanks ^^

[Razi]

This tut is clear and perfect. Thanks.
Put the image properly, cuz its hard as you need to look at the pic and come back here....

[Mambo]

If people would use the search option they would see it has been released already :D

[Analise]

After I clean the photos (:

[Miguelbkn]

:S it`s not working :S.
this is my problem:
http://img841.imageshack.us/img841/4186/problemm.png
i need help,i use a domain in www.nic.cl(i am from chile,sorry for my bad english)
and use the host from zobyhost.com
need help i press "Thanks"