sql server programming: Can't connect to SQL Server 2005 remotly -- sql server programming

RE: Can't connect to SQL Server 2005 remotly

MeanOldDBA
5/16/2006 9:28:02 PM

sql server programming: 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.

[quoted text, click to view]

Can't connect to SQL Server 2005 remotly

Shimon Sim
5/16/2006 10:05:26 PM

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

RE: Can't connect to SQL Server 2005 remotly

weilu NO[at]SPAM online.microsoft.com
5/17/2006 12:00:00 AM

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/default.aspx?scid=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.

Re: Can't connect to SQL Server 2005 remotly

Shimon Sim
5/17/2006 2:17:32 PM

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
[quoted text, click to view]

Re: Can't connect to SQL Server 2005 remotly

Shimon Sim
5/17/2006 2:41:12 PM

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

[quoted text, click to view]

Re: Can't connect to SQL Server 2005 remotly

weilu NO[at]SPAM online.microsoft.com
5/18/2006 6:51:02 AM

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.

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server programming group.