1

Can't connect to named SQL Server 2008 R2 instance remotely

view story
linux-howto

http://serverfault.com – I have a Windows Server 2008 R2 machine with SQL Server 2008 R2 Enterprise installed. The SQL Server is setup as a named instance, so its full name is "ATLANTA3\FOO" ("Atlanta3" being the machine name, and "Foo" being the instance name). I have set up a Windows Firewall with Advanced Security rule to allow all incoming connections to sqlservr.exe, and this is what is set in Configuration Manager: Shared Memory: Enabled TCP/IP: Enabled Protocol: Enabled: Yes Keep Alive: 30000 Listen All: Yes IP Addresses: (Most of these are IPv6 addresses assigned ()