Wednesday, August 4, 2010

Can You Put Real Hydrangeas On A Wedding Cake

WM: A new light on the problem "SQL Server not found" VS2008

After nearly four years of starting my first project with Windows Mobile ... and discover the grim reality of how difficult it can be to get the Windows Mobile emulator to connect to an instance of SQL Server running on your computer, FINALLY, I found something that seems to solve the problem definitively.

For those who are just beginning to run into this situation, or for those who already have suffered and still do not understand what the problem, here is what I learned in these four years

1. You must disable Windows Firewall or at least make sure you are not blocking the port you are using SQL Server, usually 1433.

2. Please make sure your instance of SQL Server, especially if it is an Express version, be prepared to accept remote connections. In Google's easy to find the steps to enable this.

3. If by chance you have multiple SQL Server instances running simultaneously on your computer unattained that the emulator is connected. Why? the truth even do not know, but this was my case, and was the reason why, despite having everything perfectly set up, I could not connect. The solution? stop all SQL Server instances except the need to use with the emulator. There is probably a way around this, but I have not found yet.

4. All that is needed to connect the emulator to your computer is "to put down" or "cradle" which in the case of the emulator, you can make it through the Device Emulator Manager.

5. In order to connect to SQL Server from the emulator without having to cradle, you must install on your computer the Microsoft Loopback Adapter and then configure the emulator's network card to connect to that adapter.


0 comments:

Post a Comment