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?