Connect to SQL Server named instance from Windows CE

I have a working connection string I stole from my desktop application,

开发者_如何学编程

Data Source=Timber\Test2;User ID=****;Password=****;
Initial Catalog=UTIL;Application Name=Handheld Shipping;Connect Timeout=1 

which just connects to a named instance on SQL Server for testing. When I use the same connection string in my Windows CE application, I get a SqlException, Specified SQL server not found: Timber\Test2.

Is this a limitation of the SQL client in .NET Compact? Or does the connection string need to be in a different format for the Compact client?

The device I'm using is CE6.0 and my program is .NET Compact 3.5.

EDIT: I'm connecting to a SQL Server 2008, on Server 2008. Connecting to the default instance works, just not the named instance.

---

No there's no limitation on the CE connection. In fact the only thing different between the CE connection and the desktop is that a CE device can do something that a desktop can't. Pass the user name and password using Integrated Security.

Data Source=myServerAddress;Initial Catalog=myDataBase;
  Integrated Security=SSPI;User ID=myDomain\myUsername;Password=myPassword;

see Trusted Connection from a CE device

The problem is probably that the CE device can't see Timber\Test2 due to a network issue. Try Pinging Timber from your CE Device