Can not Connect SQL Server Through a Firewall

All,
We are trying to connect one of our custom's SQL Server Database outside our firewall. Our Custom opened the Port #1433 for us. We also open the port on our side. However, we stil can not connect. We got "SQL Server Does Not Exist or Access Denied" erro
rs. Can anyone help us? We even could not figure out which side have issues. (Our side or our custom side)....
Lisa
Are you using a default instance or a named instance of SQL Server?
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||I used IP address and DB Name. Here is the connect string:
Password=xxx;Persist Security Info=True;User ID=xxxx;Initial Catalog=DBNAME;Data Source=123.456.78.90;
Anything wrong? THANKS?
|||Rand,
Forgot to tell that I also added ";Network Library =dbmssocn" in the connections string as well...
|||Test making an ODBC DSN and post the entire error message here.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
sql

Can not Connect SQL Server Through a Firewall

All,
We are trying to connect one of our custom's SQL Server Database outside our
firewall. Our Custom opened the Port #1433 for us. We also open the port o
n our side. However, we stil can not connect. We got "SQL Server Does Not E
xist or Access Denied" erro
rs. Can anyone help us? We even could not figure out which side have issues.
(Our side or our custom side)....
LisaAre you using a default instance or a named instance of SQL Server?
Rand
This posting is provided "as is" with no warranties and confers no rights.|||I used IP address and DB Name. Here is the connect string:
Password=xxx;Persist Security Info=True;User ID=xxxx;Initial Catalog=DBNAME;
Data Source=123.456.78.90;
Anything wrong? THANKS?|||Rand,
Forgot to tell that I also added ";Network Library =dbmssocn" in the connect
ions string as well...|||Test making an ODBC DSN and post the entire error message here.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

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 se
t
> to allow remote connection.
> How can I do?
>
>

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

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