Posted by Erland Sommarskog on 10/01/07 07:20

John (John@nospam.infovis.co.uk) writes:
> Doing telnet <remote sql ip> 1433, the isa log registers access on port
> 1433 but accessing the remote sql server using sql server management
> studio express to connect, isa log does not log any attempt on port
> 1433. I can't figure out why the management studio is not connecting on
> port 1433 or how to make it do it.

Check in SQL Configuration Manager that you have TCP/IP enabled as a client
protocol. It may be trying named pipes only.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: web database question
• Prev in forum: Alternate to cursors
• Thread view: Re: Problem accessing remote sql server

[Reply to this message]