Posted by Erland Sommarskog on 09/30/07 22:06

John (livingusman@googlemail.com) writes:
> I don't know as it is remotely located. I received ip and username/
> password from host which worked fine on old sbs 2000 + isa 2000 server
> but not on new sbs 2003 r2 + isa 2004. Anyway I can check?

A named instance has a name like SERVER\INSTANCE. To be able to access
a named instance you need to have its port number open. And if you also
access it one the form SERVER\INSTANCE, you need access to UDP port
1434. (You can always access it as SERVER,portnum.)

May be you should ask in a forum about ISA Server (which I'm completely
ignorant of)?

You should check with you host on which port SQL Server is listening.

--
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: Problem accessing remote sql server
• Prev in forum: Re: Problem accessing remote sql server
• Thread view: Re: Problem accessing remote sql server

[Reply to this message]