Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Cannot connect to SQL Server 2008 R2 remotely


Cannot connect to SQL Server 2008 R2 remotely

Author
Message
emmanuel.constant
emmanuel.constant
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 43
I've attempting to create a Development box that host a SQL Server 2008 R2; however, I'm unable to connect to it remotely. I can't create an ODBC connection as well.

My setup is this:
Windows Server 2008 R2 Standard 64-bit

Sql Server 2008 R2:
Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
Microsoft Analysis Services Client Tools 2007.0100.1600.022 ((SQL_PreRelease).080709-1414 )
Microsoft Data Access Components (MDAC) 6.1.7601.17514 (win7sp1_rtm.101119-1850)
Microsoft MSXML 3.0 6.0
Microsoft .NET Framework 2.0.50727.5456

I’ve installed SQL Server 2008 on the machine and did the following:

1. I went to the server properties in Microsoft SQL Server Management Studio and checked the "Allow remote connections to this server" under Connections section.
2. I also went to SQL Server Configuration Manager and under SQL Server Network Configuration I enabled the TCP/IP Protocol.
3. Then went to Windows Firewall with Advanced Security and created an inbound rule for the Database Engine to allow connection for port 1433.

I would imagine that doing all of this would grant me access remote access to the box and create ODBC connections but this is not the case.

I have the error message attached to the this email.
Is there something I’m forgetting to enable? Setup?
Attachments
sqlserError.jpg (24 views, 39.00 KB)
sqlserError1.jpg (23 views, 47.00 KB)
SQLKnowItAll
SQLKnowItAll
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2798 Visits: 3681
Did you make sure the proper services are running; i.e. SQL Server and SQL Server Browser?

Thanks,

Jared
SQL Know-It-All

How to post data/code on a forum to get the best help - Jeff Moden
SQLisAwE5OmE
SQLisAwE5OmE
Mr or Mrs. 500
Mr or Mrs. 500 (558 reputation)Mr or Mrs. 500 (558 reputation)Mr or Mrs. 500 (558 reputation)Mr or Mrs. 500 (558 reputation)Mr or Mrs. 500 (558 reputation)Mr or Mrs. 500 (558 reputation)Mr or Mrs. 500 (558 reputation)Mr or Mrs. 500 (558 reputation)

Group: General Forum Members
Points: 558 Visits: 3062
I have the error message attached to the this email.

Did you forget to attach the error message? I cannot find it.

Regards,
TA

Regards,
SQLisAwe5oMe.
CapnHector
CapnHector
SSC Eights!
SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)

Group: General Forum Members
Points: 917 Visits: 1789
have you configured the windows firewall to allow SQL Server traffic? I have had that issue my self.

http://msdn.microsoft.com/en-us/library/ms175043.aspx


For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden for the best way to ask your question.

For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw

Need to Split some strings? Jeff Moden's DelimitedSplit8K
Jeff Moden's Cross tab and Pivots Part 1
Jeff Moden's Cross tab and Pivots Part 2
emmanuel.constant
emmanuel.constant
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 43
I've attached the error messages sorry about that.
The inbound firewall rules were added already.
All service running has also been confirmed.
Same results.
jitendra.padhiyar
jitendra.padhiyar
SSC Veteran
SSC Veteran (248 reputation)SSC Veteran (248 reputation)SSC Veteran (248 reputation)SSC Veteran (248 reputation)SSC Veteran (248 reputation)SSC Veteran (248 reputation)SSC Veteran (248 reputation)SSC Veteran (248 reputation)

Group: General Forum Members
Points: 248 Visits: 669
I have seen your attached error snapshot and have assumed two possiblities:

1. TCP\IP Services seems to be disabled. Which is not allowing you to handshake with remote server.
2. Please type correct Server\instance name.


Thanks,

Jitendra
emmanuel.constant
emmanuel.constant
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 43
Thanks Jitendra.

1. TCP\IP Services seems to be disabled. Which is not allowing you to handshake with remote server.

Where would I go to enable the TCP\IP service?

2. Please type correct Server\instance name.

I have confirmed that the Server\instance name is correct; therefore, this is not an issue.
SQLKnowItAll
SQLKnowItAll
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2798 Visits: 3681
emmanuel.constant (7/31/2012)
Thanks Jitendra.

1. TCP\IP Services seems to be disabled. Which is not allowing you to handshake with remote server.

Where would I go to enable the TCP\IP service?

2. Please type correct Server\instance name.

I have confirmed that the Server\instance name is correct; therefore, this is not an issue.
SQL Server Configuration Manager is where you will go to check tcp/ip settings. his will be under the SQL Server Network Configuration. Go to Protocols for MSSQLSERVER (or your named instance) and make sure tcp/ip is enabled.

Thanks,

Jared
SQL Know-It-All

How to post data/code on a forum to get the best help - Jeff Moden
emmanuel.constant
emmanuel.constant
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 43
Thanks Jared.

Well then that has been addressed also. I made sure that was enabled as well.

I did discover that I have the Win2008 server which host the SQL Server 2008 on one domain and I'm attempting to access it from a client PC from another domain. Not sure if it matters or not; however, i reckon there should be a handshaking between the two domain security wise before the exchange of packet happen no?
SQLKnowItAll
SQLKnowItAll
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2798 Visits: 3681
If you are attempting to use windows authentication, I don't think it will work that way. They must both be on the same domain.

Thanks,

Jared
SQL Know-It-All

How to post data/code on a forum to get the best help - Jeff Moden
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search