Can't connect to SQL 2005 in Vista

Hi. I hope someone can give me some ideas.
I have a SQL 2005 dev installed in my Vista and I tried to register it from
my Win 2003 server which also has SQL 2005. I get a time out message, it
seems the server cannot connect to my vista sql server. I already set my
vista sql server remote connection and restarted. Any idea? I don't have
issue to connect my server SQL from my vista. Is it something to do with
vista?
Thanks
KLWhat does "set my vista sql server remote connection" mean? Did you use the
surface area configuration tool to ensure that outside connections via
TCP/IP would be enabled? Also, is it a named instance or a default
instance? Are you using the correct instance name while trying to register
from Windows Server 2003? Are you inside a domain or a workgroup? Is it
possible that Windows firewall (or hardware firewall(s), or a program like
ZoneAlarm etc.) is blocking you from connecting? Is SQL Server using the
default port (1433) or is it custom? Can you ping the Vista machine from
Windows Server 2003? If so, can you telnet to the Vista machine on port
1433?
Aaron Bertrand
SQL Server MVP
"KL" <KwanLoonLai@.msn.com> wrote in message
news:C5507C7F-DAAC-4102-A510-201C3C4E247F@.microsoft.com...
> Hi. I hope someone can give me some ideas.
> I have a SQL 2005 dev installed in my Vista and I tried to register it
> from my Win 2003 server which also has SQL 2005. I get a time out
> message, it seems the server cannot connect to my vista sql server. I
> already set my vista sql server remote connection and restarted. Any idea?
> I don't have issue to connect my server SQL from my vista. Is it something
> to do with vista?
> Thanks
> KL|||- I use surface area configuration to enbled the remote connection with
both TCP/IP and name pipes
- It is a default instance
- Yes I use correct instance name to register the server, in this case I
use my computer name
- This is within a domain
- There is no third party firewall program running in my Vista, and I do
suspect vista built in firewall may block it, anyway I can find out ? I read
an article from
http://support.microsoft.com/defaul...kb;EN-US;914277 I follow
the step and add the sqlbrowser to exception list. still not working.
- I don't think I change any port when I installed sql server, if 1433 is
default it should be it
- I cant telnet to my vista with port 1433, but ping is fine
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in mess
age
news:ORzmx630HHA.4184@.TK2MSFTNGP06.phx.gbl...
> What does "set my vista sql server remote connection" mean? Did you use
> the surface area configuration tool to ensure that outside connections via
> TCP/IP would be enabled? Also, is it a named instance or a default
> instance? Are you using the correct instance name while trying to
> register from Windows Server 2003? Are you inside a domain or a
> workgroup? Is it possible that Windows firewall (or hardware firewall(s),
> or a program like ZoneAlarm etc.) is blocking you from connecting? Is SQL
> Server using the default port (1433) or is it custom? Can you ping the
> Vista machine from Windows Server 2003? If so, can you telnet to the
> Vista machine on port 1433?
> --
> Aaron Bertrand
> SQL Server MVP
>
>
> "KL" <KwanLoonLai@.msn.com> wrote in message
> news:C5507C7F-DAAC-4102-A510-201C3C4E247F@.microsoft.com...
>|||> - I cant telnet to my vista with port 1433, but ping is fine
Sounds to me like 1433 is blocked. It may be Windows firewall... you will
have to go into the config and make sure SQL (port 1433) is allowed at least
from the Windows Server 2003 IP.
A|||Thanks. It works after I put port 1433 in vista firewall exception.
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in mess
age
news:OAix3d40HHA.536@.TK2MSFTNGP06.phx.gbl...
> Sounds to me like 1433 is blocked. It may be Windows firewall... you will
> have to go into the config and make sure SQL (port 1433) is allowed at
> least from the Windows Server 2003 IP.
> A
>