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
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...
> 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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment