Can't connect to SQL Server 2005 remotly

I am running SQL Server 2005 on Virtual PC.
I can connect to in VPC using SMS if I set server =win03 SQL Server
Authentication
Shimon2 and password
If I go to my host machine I can't connect the same way - time out.
I can see server. I have Team Server running on it and VS has no problem
connecting.
I made sure that Allow Remote Connections to this server is checked.
So what else did I miss?
ThanksA lot of people seem to be missing the fact that many of the versions of SQL
Server 2005 have remote connections disabled by default. Have you checked
the surface area configuration tool to make sure that you have a remote
protocol enabled for the SQL Server itself (as opposed to the server)?
If you do, and are still getting errors, run Profiler on the SQL Server and
trace for logins. That way, you will have at least leveled it down to one
layer.
Let us know how it goes.
--
MeanOldDBA
derrickleggett@.hotmail.com
http://weblogs.sqlteam.com/derrickl
When life gives you a lemon, fire the DBA.
"Shimon Sim" wrote:

> I am running SQL Server 2005 on Virtual PC.
> I can connect to in VPC using SMS if I set server =win03 SQL Server
> Authentication
> Shimon2 and password
> If I go to my host machine I can't connect the same way - time out.
> I can see server. I have Team Server running on it and VS has no problem
> connecting.
> I made sure that Allow Remote Connections to this server is checked.
> So what else did I miss?
> Thanks
>
>|||Hi Shimon,
Thank you for your post and thanks Derrick's suggestion.
Please first confirm you have enable the remote connection in the surface
area configuration tool as Derrick's suggestion.
If you still can not access the sqlserver instance, please do the following
to troubleshoot.
1. Ping the VPC machine to see if you could access it.
2. Telnet the machine on port 1433:
Telnet < machine name> < Port Number >
3. Also, please use the following KB article to troubleshoot the connection
issue:
827422 How to troubleshoot connectivity issues in SQL Server 2000
http://support.microsoft.com/defaul...kb;EN-US;827422
Hope this will be helpful.
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.|||I am not sure what is remote protocol.
I have four protocols in the surface area configuration tool and all of them
are enabled.
But still can't connect. Telnet tells me that it can't connect.
Am I enabling right thing?
Thanks
"MeanOldDBA" <MeanOldDBA@.discussions.microsoft.com> wrote in message
news:C26B8FFD-2912-4DA2-8E08-8880F0527352@.microsoft.com...
>A lot of people seem to be missing the fact that many of the versions of
>SQL
> Server 2005 have remote connections disabled by default. Have you checked
> the surface area configuration tool to make sure that you have a remote
> protocol enabled for the SQL Server itself (as opposed to the server)?
> If you do, and are still getting errors, run Profiler on the SQL Server
> and
> trace for logins. That way, you will have at least leveled it down to
> one
> layer.
> Let us know how it goes.
> --
> MeanOldDBA
> derrickleggett@.hotmail.com
> http://weblogs.sqlteam.com/derrickl
> When life gives you a lemon, fire the DBA.
>
> "Shimon Sim" wrote:
>|||Well
I found this here
http://support.microsoft.com/?kbid=914277&SD=tech
And remove access was enabled. So what do I do now?
Thanks
"Shimon Sim" <shimonsim048@.community.nospam> wrote in message
news:%23QDps4deGHA.5040@.TK2MSFTNGP03.phx.gbl...
>I am not sure what is remote protocol.
> I have four protocols in the surface area configuration tool and all of
> them are enabled.
> But still can't connect. Telnet tells me that it can't connect.
> Am I enabling right thing?
> Thanks
> "MeanOldDBA" <MeanOldDBA@.discussions.microsoft.com> wrote in message
> news:C26B8FFD-2912-4DA2-8E08-8880F0527352@.microsoft.com...
>|||Hi Shimon,
Since you can not telnet to the port, I think you need to check your VPC
configuration and to see do you enable and configure a IP address for it.
And you will need to check the Network configuration.
Please confirm you could telnet the 1433 port and then try to connect to
the SQL Server.
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.