none
unable to connect from remote pc

    Question

  • I just installed SQL '12 on Windows Server 2012 (VM) and I'm able to connect to it from another pc (my sharepoint server and my local pc). I did the enabling of TCP/IP, set the ports, etc, and yet I still can't connect to it via another computer.

    When I open Server Management Studio from my PC and try to connect to the db engine, I'm getting the following error message:

    A network -related or instance specfic error occurred while establishing a connection to SQL Server. The server was not found or was not accessbile.

    What can I be missing?

    Wednesday, July 24, 2013 3:33 PM

Answers

All replies

  • Hello,

    Please configure Windows Firewall for SQL Server access on all computers as explained on the following article:

    http://msdn.microsoft.com/en-us/library/cc646023(v=sql.110).aspx
     
    Hope this helps.

    Regards,
    Alberto Morillo
    SQLCoffee.com

    Wednesday, July 24, 2013 3:36 PM
    Moderator
  • did all that and since i'm using a named instance, i used that port# and still no luck.
    Wednesday, July 24, 2013 3:46 PM
  • can you ping it?

    can you connect locally?

    is your browser running?

    if all that is ok, it will be 99% related to firewall settings.


    Geert Vanhove DCOD ------ http://geertvanhove.wordpress.com/ ----------- Please click the Mark as Answer or Vote As Helpful if a post solves your problem or is helpful!

    Wednesday, July 24, 2013 3:51 PM
  • I'm able to connect to it when i'm logged onto the server itself, I just unable to connect to it from another pc.

    Now, I have SQL 2012 running on a Windows 8 server and I'm able to connect to that remotely just fine, Im just unable to connect to SQL 2012 running in on my Windows 2012 server.

    Wednesday, July 24, 2013 3:54 PM
  • Hello,

    If you are trying to connect to a named instance, then you have to enable and start SQL Server Browser.

    http://technet.microsoft.com/en-us/library/ms189093(v=SQL.105).aspx

    Alternatively, you can configure an static IP address using the following article:

    http://msdn.microsoft.com/en-us/library/ms177440.aspx

    To connect to a named instance use the following server name:  computer_name\instance_name.
     
    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Wednesday, July 24, 2013 3:55 PM
    Moderator
  • I did that and I'm using the servername\instancename and nothing.

    I'm at a loss on this one at the moment. is there something on windows server 2012 that i have to change, check, etc. other then the firewall settings which are done.

    EDIT: I think I may have found something, I just tried pinging the server and I can't, HOWEVER, when I log onto the server, I can browse the network and connect to network drives. So I'm at a a loss for a bit.

    (time to walk away on this one for a bit and come back to it)

    • Edited by CSharpCoder1 Wednesday, July 24, 2013 4:23 PM can't ping server
    Wednesday, July 24, 2013 3:57 PM
  • After some more poking around, I was able to connect to it, however, I had to turn off the firewall inbound connections on the domain tab, which I dont' like doing
    Wednesday, July 24, 2013 5:31 PM