March 10, 2009 at 10:34 pm
: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 ?
March 12, 2009 at 2:36 pm
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
March 12, 2009 at 3:14 pm
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