Re: Can't connect remotely to SQL Server Express
  Home FAQ Contact Sign in
microsoft.public.sqlserver.setup only
 
Advanced search
POPULAR GROUPS

more...

microsoft ... sqlserver.setup Profile…
 Up
Re: Can't connect remotely to SQL Server Express         


Author: Ekrem Önsoy
Date: Aug 5, 2008 16:14

I suggest you to use a static port instead of a dynamic one.

--
Ekrem Önsoy

"Roger Withnell" discussions.microsoft.com> wrote in message
news:C129F916-32C0-4439-9B1C-D98D8593BCD6@microsoft.com...
>I have installed SQL Server Express on a Windows 2003 platform....
Show full article (1.05Kb)
2 Comments
Re: Can't connect remotely to SQL Server Express         


Author: Roger Withnell
Date: Aug 8, 2008 11:18

Thanks for your help, but I don't understand what you mean.

Could you elaborate, please?

Many thanks.

Roger

"Ekrem Önsoy" wrote:
> I suggest you to use a static port instead of a dynamic one.
>
> --
> Ekrem Önsoy
>
>
>
>
> "Roger Withnell" discussions.microsoft.com> wrote in message
> news:C129F916-32C0-4439...
Show full article (1.26Kb)
no comments
Re: Can't connect remotely to SQL Server Express         


Author: Ekrem Önsoy
Date: Aug 8, 2008 10:53

As SQL Server 2005 Express Edition is installed as a Named Instance by
default (unless you change it during SQL Server Setup), it must be using a
Dynamic Port for TCP protokol now.

In some cases I witnessed people experienced conneting remotely and they
were using Dynamic Ports. When they change it to a Static Port, they
successfully connected.

I've an article about remote connection settings, however it's in Turkish.

You can configure your port settings through SQL Server Configuration
Manager. Simply, to use a Static Port for your SQL Server Instance:
- Open up SQL Server Configuration Manager
- From the left side...
Show full article (3.65Kb)
no comments

RELATED THREADS
SubjectArticles qty Group
Why connecting to remote JMS glassfish server is soooo slow?comp.lang.java.programmer ·