Sql-server – Remote access to SQL Server 2008 R2 on Windows Server 2012 R2

sql serversql-server-2008-r2

I have SQL Server 2008 R2 (named instance) on a Windows Server 2012 R2:

  1. Enabled remote access to SQL Server
  2. Enabled shared memory & TCP/IP protocols & named pipes for the SQL Server instance.
  3. Created a firewall rule for TCP Port 1433
  4. Created a firewall rule for UDP Port 1434
  5. Created a firewall rule for SQLBrowser.exe
  6. Created a firewall rule for SQLservr.exe
  7. Ensured SQL Browser & SQL Server are running

I'm able to remotely access SQL Server (ip\instance name,port number) but can't access with (ip\instance name).

I tried with turning off firewall, but the problem was not resolved.

How can I fix it?

Best Answer

It is a known issue with Sql Server 2008. Happens also in SSAS. Search for Microsoft fix/ or ask support for it (fix applies on the OS site and not the DB site).

Related Question