<anonymous@discussions.microsoft.com> wrote in message
news:da0f01c3ef60$69e99340$a601280a@phx.gbl...
> SQL server seems to be having problems writing to another
> sql server database server behind a firewall. The ip
> address is able to be pinged through the firewall but
> trying to access sql server gives "server does not exist
> or access is denied" message. The firewall has been
> setup to allow for this particular ip address. Port 1433
> is selected and TCP/IP is selected from Client Network
> Utility and Server Network Utility.
> The message returned says:
> Connection failed:
> SQLState: '01000'
> SQL Server Error: 10060
> Microsoft ODBC SQL Server Driver TCP/IP Sockets
> ConnectionOpen (Connect())
> Connection failed
> SQLState 08001 SQL SErver Eror: 17 SQL Server does not
> exist or access denied
>

>-----Original Message-----
>check if u can telnet the server using this port
>ex.
>from command prompt
>telnet servername 1433
>
>if this works then u should create one alias using tcp
ip protocol in client
>network utility of sql
>
>this should work
>
>if u cant telnet the server using 1433 the port is still
blocked for your
>ip/network.
>
>Regards,
>Mayur
>
><anonymous@discussions.microsoft.com> wrote in message
>news:da0f01c3ef60$69e99340$a601280a@phx.gbl...
>> SQL server seems to be having problems writing to
another
>> sql server database server behind a firewall. The ip
>> address is able to be pinged through the firewall but
>> trying to access sql server gives "server does not
exist
>> or access is denied" message. The firewall has been
>> setup to allow for this particular ip address. Port
1433
>> is selected and TCP/IP is selected from Client Network
>> Utility and Server Network Utility.
>> The message returned says:
>> Connection failed:
>> SQLState: '01000'
>> SQL Server Error: 10060
>> Microsoft ODBC SQL Server Driver TCP/IP Sockets
>> ConnectionOpen (Connect())
>> Connection failed
>> SQLState 08001 SQL SErver Eror: 17 SQL Server does
not
>> exist or access denied
>>
>
>
>.