No SQL server agent on SQL 2005 Express

  • Try adding a host entry in the client machine

    C:\WINDOWS\system32\drivers\etc\hosts

    192.168.1.100 hostname

    and see if you can access remotely using Server\Instance

    should resolve also when you ping Server on cmd line

  • Megistal (3/31/2009)


    Hummm from the IP you seems to be on a "home" network (Class C). DNS names are not resolved for this. If I saw it right you then need a DNS server which will resolved your machine IP, in other words a network infrastructure.

    Can explain to me in more details? Is it mean that I need to key in the DNs settings?

  • Are you using a domain? A domain using a router to your machines? or a workgroup?

    I've taken for granted that was the latter from the ip address

  • I'm not sure if anyone's mentioned this yet, but SQL Express, by default, has remote connections turned off. Go into the SQL Server Surface Area Configuration and check the Surface Area configs for Services and Connections and look at the "Remote Connections" to make sure it's not set to "Local Only".

    Tim White

Viewing 4 posts - 16 through 18 (of 18 total)

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