express edition

Hi,
is it possible to connect to the sql server express edition from other
computer on the LAN or not?
I have tested connecting but doesn't work. I have used different
conditions but ..
thanks,
AliStart->All Programs->Microsoft SQL Server 2005->Configuration Tools->SQL
Server Surface Area Configuration
spelunk untill you fine it, the change is easy.
"Ali" <nikzad.a@.gmail.com> wrote in message
news:1192571122.912160.54820@.e34g2000pro.googlegroups.com...
> Hi,
> is it possible to connect to the sql server express edition from other
> computer on the LAN or not?
> I have tested connecting but doesn't work. I have used different
> conditions but ..
> thanks,
> Ali
>|||By default, Surface Area Configuration for Remote connections is turned off
in SQL Server 2005. Enable it first
"Ali" <nikzad.a@.gmail.com> wrote in message
news:1192571122.912160.54820@.e34g2000pro.googlegroups.com...
> Hi,
> is it possible to connect to the sql server express edition from other
> computer on the LAN or not?
> I have tested connecting but doesn't work. I have used different
> conditions but ..
> thanks,
> Ali
>|||I'd like to add a note to messages of my friends above.
If you are going to be connecting to your SQL Server Express Edition
instance, then you'll need to configure your TCP\IP or NP settings from SQL
Server Configuration Manager.
--
Ekrem Önsoy
http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
MCBDA, MCTS: SQL Server 2005, MCITP:DBA, MCSD.Net, MCSE, MCT
"Ali" <nikzad.a@.gmail.com> wrote in message
news:1192571122.912160.54820@.e34g2000pro.googlegroups.com...
> Hi,
> is it possible to connect to the sql server express edition from other
> computer on the LAN or not?
> I have tested connecting but doesn't work. I have used different
> conditions but ..
> thanks,
> Ali
>