I can not connect a SqlServer (version 2005) in remote.
I have checked there are no firewall problems, and the server have been set
to allow remote connection.

How can I do?

I got the following from another post in SQLServer Setup community.

The Allow Remote Conections is not the correct setting (it controls the
ability for remote servers to execute stored procedures on the local server
via a linked server) The easiest thing to do is on the server go to
Start>Programs>Microsoft SQL Server 2005>Configuration Tools>SQL Surface
Area Configuration and click on Surface Area Configuration for Services And
Connections. Under the Database Engine section on the left select Remote
Connections and select the Local and remote connections radio burron and
select Using both TCP/ip and named pipes and click Apply.


Show quoteHide quote

Example of binary data type in SQL Server
One large database or a few smaller databases?
How do i block SQL browse list?
Supported TDS versions in SQL 2005
Help interpreting DBCC CHECKDB output
Object Browser in Query Analyzer
Remove Non alphanumeric
Asking for a little help with sql 2000
...unable to begin a distributed transaction
SQL Sever 2005 install error