Friday, February 10, 2012

Connect to SQL Server 2005

I have installed two SQL Server 2005. One on Windows XP SP2 and another on
Windows Server 2003 SP1. I have shut down the firewall on both machine, but
I still failed to coonect each other. Both of them can connect to SQL Server
2000.
Does anyone know what wrong?
Since SQL 2005 is still in beta, you'll want to post this in the Community
Newsgroups:
http://communities.microsoft.com/new...r2005&slcid=us
--Brian
(Please reply to the newsgroups only.)
"Ryan Chen" <sadnut@.163.com> wrote in message
news:OozzaTpuFHA.1132@.TK2MSFTNGP10.phx.gbl...
>I have installed two SQL Server 2005. One on Windows XP SP2 and another on
>Windows Server 2003 SP1. I have shut down the firewall on both machine, but
>I still failed to coonect each other. Both of them can connect to SQL
>Server 2000.
> Does anyone know what wrong?
>
|||Run SQL Server Surface Area Configuration tool and then click on
"Surface Area Configuration for Services and Connections"
Then look under Database Engine, Remote Connection and insure that remote
TCP-IP is enabled.
I always forget to do this when I setup SQL 2005, it's quite annoying that
it defaults to off but this is part of our "surface area off by default as
much as possible" initiative.
Matt Neerincx [MSFT]
This posting is provided "AS IS", with no warranties, and confers no rights.
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.
"Ryan Chen" <sadnut@.163.com> wrote in message
news:OozzaTpuFHA.1132@.TK2MSFTNGP10.phx.gbl...
>I have installed two SQL Server 2005. One on Windows XP SP2 and another on
>Windows Server 2003 SP1. I have shut down the firewall on both machine, but
>I still failed to coonect each other. Both of them can connect to SQL
>Server 2000.
> Does anyone know what wrong?
>

No comments:

Post a Comment