Unable to connect to sql server 2008 from remote computer

  • I have enabled TCP and the Name Pipes protocols with the Sql Server manager, but, still unable to connect to the sql server 2008 instance from a client machine.

    Both computers are at the same location (my home).

    The one I'm connecting from is 192.168.0.11

    The one that is running sql server 2008 is 192.168.0.12

    In my connection string I specify 192.168.0.12\WEBSERV (WEBSERV is the name of my instance)

    I specify the sql server authentication for user sa and enter appropriate password (which works fine locally)

    What else may be the problem?

    -Eugene

  • Windows firewall?

  • Some AV cause issues

    NOD32 definitely

  • Could be a FireWall.

    I have it sit on the switch.

    Which port should I allow?

  • OK, Problem solved.

    It could in fact be a FireWall, but, I also changed to connection string to be just "WEBSERV"

    Best regards

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply