Tuesday, March 20, 2012

Can not connect remote SqlServer

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.
"ad" wrote:

> 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?
>
>

No comments:

Post a Comment