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 went to the server properties in Microsoft SQL Server Management Studio and checked the "Allow remote connections to this server" under Connections section. I also went to SQL Server Configuration Manager and under SQL Server Network Configuration I
enabled the TCP/IP Protocol. The ...
Go to the complete details ...