problem with connecting to Sql Server 2000 from a mobile device

Hi,
I'm using SqlClient connection class to connect via IP address (wireless connection)
from: Windows CE 4.2 / .NET Compact Framework v1.1
to: SQL Server 2000/Win XP sp2

The connection string has a form like this one:
Data Source=190.190.200.100,1433;Initial Catalog=MyDB;Integrated Security=false;User ID=sa;Password=;

I succeeded to install SQL Server 2000 and to establish connection with the mobile device on my PC . But when I try to connect to SQL Server that runs on other PCs (under Win XP), the same connection doesn't work. (of course I change the IP address in the string accordingly).

I think about two possible reasons:

1. Specific configurations during SQL Server install process bring to connection failure. (although each SQL Server was configured to work in mixed mode, with default user and password)

2. Additional packages/tools must be installed for SQL Server 2000. (although sp4 was installed) .I've probably installed something on my PC that is missing on other PCs.

I have to know exactly which configurations/installs I have to do on both PC and mobile device, in order to be able to establish the connection between them.

Hope you'll help me.

Answer this question

problem with connecting to Sql Server 2000 from a mobile device

Mynor Ivan Muralles MSFT

hi SimonY,

can u tell me the error message that u r getting so i can help u
AlinaMaria
Please visit http://www.microsoft.com/sql/techinfo/administration/2000/security/winxpsp2faq.mspx for details on running SQL Server 2000 on Windows XP with Service Pack 2
coloradovista
Hi SimonY,

I think i got yr problem,
u get error when u access sql server that is not connected to device but it is in Network.

manually access any webPage of that server from internet explorer of pocket pc, it ask for username, password and domain. once u get that page open correctly, u can enjoy application without any problem.

if it doesn't work, let me lnow what is the error messege
fap99
Have you checked to see if you have TCP/IP as an enabled protocol on your database Start up the "SQL Server Network Utility" found in (default path) C:\Program Files\Microsoft SQL Server\80\Tools\Binn

Run the program called "svrnetcn.exe" it will bring up a dialog showing the available protocols and the enabled protocols. If TCP/IP isn't on the enabled side simply enable it.

Vlek
VistaGeek
bass_player, thanks for reply.
All topics, in the link you suggested, talk about SQL Server conflicting with windows firewall. My problem remains even if I turn off the firewall.
Avi harush
hi simony,

Have u solved the pbm .

If so,kindly tell me how did u solve it

B'cos i'm facing the same pbm with windows server 2003.

Apps is in Windows XP machine.

I'm developing Pocket PC apps.

I could able to connect SQL server in the same m/c where i developed my apps.But, Facing pbm when i try to access other M/c(server 2003) SQL database.

Thank You.
Isaac Strack
Let me check if my understanding is correct...you are using a Pocket PC running Windows CE that connects to your computer and the connection is perfectly running fine. When your Pocket PC connects to other machine, it cannot do so. Have you checked the IP address of the device Can you ping the IP address of the device from other computers I had this problem before but it's just the IP/connectivity between the device and another machine.
problem with connecting to Sql Server 2000 from a mobile device

Answer this question