Cannot connect to SQL Server 2008 R2 remotely

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server Newbies » Cannot connect to SQL Server 2008 R2 remotely...

35 posts, Page 1 of 4

1 2 3 4 »»»

Cannot connect to SQL Server 2008 R2 remotely

Rate Topic

Display Mode

Topic Options

Author

Message

emmanuel.constant

Posted Thursday, July 26, 2012 7:37 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, August 21, 2012 8:13 AM
Points: 15, Visits: 29

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?

Post Attachments

sqlserError.jpg (20 views, 39.93 KB)

sqlserError1.jpg (18 views, 47.09 KB)

Post #1335842

SQLKnowItAll

Posted Thursday, July 26, 2012 2:09 PM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 9:05 PM
Points: 2,624, Visits: 3,145

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

Post #1336113

SQLCrazyCertified

Posted Thursday, July 26, 2012 2:17 PM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 12:12 PM
Points: 320, Visits: 1,916

I have the error message attached to the this email.

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

Regards,
TA

Post #1336118

CapnHector

Posted Thursday, July 26, 2012 3:52 PM

SSC Eights!

Group: General Forum Members
Last Login: Thursday, June 06, 2013 3:00 PM
Points: 939, Visits: 1,713

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

Jeremy Oursler

Post #1336166

emmanuel.constant

Posted Thursday, July 26, 2012 3:59 PM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, August 21, 2012 8:13 AM
Points: 15, Visits: 29

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.

Post #1336167

jitendra.padhiyar

Posted Tuesday, July 31, 2012 1:14 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 1:38 AM
Points: 171, Visits: 453

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

Post #1337702

emmanuel.constant

Posted Tuesday, July 31, 2012 7:10 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, August 21, 2012 8:13 AM
Points: 15, Visits: 29

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.

Post #1337879

SQLKnowItAll

Posted Tuesday, July 31, 2012 7:19 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 9:05 PM
Points: 2,624, Visits: 3,145

emmanuel.constant (7/31/2012)

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

Post #1337889

emmanuel.constant

Posted Tuesday, July 31, 2012 8:28 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, August 21, 2012 8:13 AM
Points: 15, Visits: 29

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?

Post #1337941

SQLKnowItAll

Posted Tuesday, July 31, 2012 9:19 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 9:05 PM
Points: 2,624, Visits: 3,145

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

Post #1337975

« Prev Topic | Next Topic »

35 posts, Page 1 of 4

1 2 3 4 »»»

Permissions