3

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?

  • What does "can't access" mean? Did you specify 1433 for the port number? Are you sure your named instance is running on that port? (That's not typical. I suspect you are connecting to the default instance when it succeeds, not your named instance.) – Aaron Bertrand Aug 29 '15 at 11:32
  • no, I am using dynamic port mode , actually i have only 1 SQL server(and that is named instance) – ramin_rp Aug 29 '15 at 13:03
  • hi, error message is: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1) – ramin_rp Aug 30 '15 at 4:31
  • and i use port number from TCP Dynamic ports field in IPALL tab on tcp/ip propertis, for example 49360 – ramin_rp Aug 30 '15 at 4:38
  • Sounds like if the port number works but no port doesn't, that SQL Browser is not, in fact, running. Did you search any of the thousands and thousands of Google hits or the many existing questions already asked here? – Aaron Bertrand Aug 30 '15 at 12:51
-1

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).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.