|
|
Posted by bass_player [SBS-MVP] on 09/30/07 22:29
This was also posted on the microsoft.public.windows.server.sbs newsgroup
I did ask if this was SQL Server 2000 or 2005 as you mentioned Windows SBS
2003 R2. You have to enable remote access using the Surface Area
Configuration for Services and Connections
"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns99BC1E65262FYazorman@127.0.0.1...
> 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
Navigation:
[Reply to this message]
|