SQL 2005 on VM Ware

  • :hehe:

    Connection Failed

    SQLState 0100

    SQL Server Error 2

    [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen(Connect())

    Connection Failed

    SQLState 08001

    SQL Server Error 17

    [Microsoft][ODBC SQL Server Driver][Shared Memory]Sql Server does not exist or access is denied

    What the heck has happened ? I used Microsoft VM at work, but the MS virtual machines are not set for Windows XP home, so I had to use the VMware software. Any ideas ?

  • I assume you are trying to connect on the same machine that is hosting the SQL Server since it is complaining about SharedMemory.

    If not,

    Go under Surface Area Configuartion and turn on allowing of remote connections

    If it is,

    Is it a named instance? It may need ServerName\InstanceName

    I'm not terribly familiar with Microsoft VM (is this VMWare maybe?)

    Can you get to the internet/network from this machine? Also, check your login to make sure that still works. It might be something like you're trying to use an Active Directory account and since the AD server is at work (but not at home) it is failing for this reason.

    Cheers,

    Brian

  • what version vmware server you using?

    have you mapped your VM's virtual NIC to the physical network or to a private virtual network, double check your config

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 3 posts - 1 through 2 (of 2 total)

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