"Christian Pedersen" <christian@remove.spam.prevention.miniagency.dk> wrote
in message news:braeav$200$1@news.cybercity.dk...
> Hi!
>
> I'm trying to access my SQL Server through a firewall. The SQL Server is
on
> the inside. I've opened up port 1433 in the firewall, so I should be able
to
> connect. It's SQL Server 7.0.
>
> The problem is, that I get a timeout message, when trying to connect. I
used
> Network Monitor on the server, to look through network activity. SQL
Server
> receives the connection OK, and exchanges several packets with my client,
> but starts doing strange SMB-activity, which fails. My client itself is
also
> behind a firewall/router.
>
> The SQL Server setup is pretty much standard, and I'm authenticating using
> internal SQL Server authentication.
>
> The firewall is a Cisco PIX 515E.
>
> Any hints and comments would be really helpful. Thanks.
>
> Christian
>
>

"Kevin McDonnell [MSFT]" <kevmc@online.microsoft.com> wrote in message
news:hirbnMCwDHA.3972@cpmsftngxa07.phx.gbl...
> What I would recommend is creating a TCP alias for the Server using the
> Client Network Utility. Make sure the alias name is the same name as the
> remote server you're connecting to. This will force the client to connect
> using TCP.
>
> Hope this helps.
>
> Thanks,
>
> Kevin McDonnell
> Microsoft Corporation
>
> This posting is provided AS IS with no warranties, and confers no rights.
>
>
>