Error Message 11004

Hi
Eveyone. I am having trouble connecting to my SQL Server 2005
Expression edition. I can connnect from other pc without any trouble.
The only difference between this PC and the others is this PC is
running Windows 2000 SP4. I can ping my SQL Server no problem. I can
even telnet into it. I just can't connect to it. Any help would be
greatly appreciated.
-Thanks
Thanascheck sql log to see which tcp port sqlexpress started under. then try to
connect via:
sqlcmd -S"servername,tcp_port"
--
-oj
<atsioplakis@.gmail.com> wrote in message
news:1150481091.896901.173220@.c74g2000cwc.googlegroups.com...
> Hi
> Eveyone. I am having trouble connecting to my SQL Server 2005
> Expression edition. I can connnect from other pc without any trouble.
> The only difference between this PC and the others is this PC is
> running Windows 2000 SP4. I can ping my SQL Server no problem. I can
> even telnet into it. I just can't connect to it. Any help would be
> greatly appreciated.
> -Thanks
> Thanas
>|||The trouble is that Windows 2000 OS Data Source section doesn't want to
connect to the SQL Server. I can't get that to work. Any comments on
that?
oj wrote:
> check sql log to see which tcp port sqlexpress started under. then try to
> connect via:
> sqlcmd -S"servername,tcp_port"
> --
> -oj
>
> <atsioplakis@.gmail.com> wrote in message
> news:1150481091.896901.173220@.c74g2000cwc.googlegroups.com...
> > Hi
> > Eveyone. I am having trouble connecting to my SQL Server 2005
> > Expression edition. I can connnect from other pc without any trouble.
> > The only difference between this PC and the others is this PC is
> > running Windows 2000 SP4. I can ping my SQL Server no problem. I can
> > even telnet into it. I just can't connect to it. Any help would be
> > greatly appreciated.
> >
> > -Thanks
> > Thanas
> >|||did you try to connect with explicitly specifying the tcp port#.
to determine the listening port, connect to the instance and run "exec
sp_readerrorlog". this displays the sql error log and you should be able to
find the current listening port.
also, check to see if there is a firewall between the win2k and sql2k5
express. make sure sqlbrowser is running on the sqlserver and UDP 1434 is
open.
-oj
"Thanas" <atsioplakis@.gmail.com> wrote in message
news:1150741206.158850.127400@.p79g2000cwp.googlegroups.com...
> The trouble is that Windows 2000 OS Data Source section doesn't want to
> connect to the SQL Server. I can't get that to work. Any comments on
> that?
> oj wrote:
>> check sql log to see which tcp port sqlexpress started under. then try to
>> connect via:
>> sqlcmd -S"servername,tcp_port"
>> --
>> -oj
>>
>> <atsioplakis@.gmail.com> wrote in message
>> news:1150481091.896901.173220@.c74g2000cwc.googlegroups.com...
>> > Hi
>> > Eveyone. I am having trouble connecting to my SQL Server 2005
>> > Expression edition. I can connnect from other pc without any trouble.
>> > The only difference between this PC and the others is this PC is
>> > running Windows 2000 SP4. I can ping my SQL Server no problem. I can
>> > even telnet into it. I just can't connect to it. Any help would be
>> > greatly appreciated.
>> >
>> > -Thanks
>> > Thanas
>> >
>