January 20, 2006 at 2:50 am
Hi..
I have written a program on a x86 based CE.Net computer that connects to a SQL server 2000 to get some data. The program works fine as long as the database is running on a Windows 2000 machine, but when trying to connect to a database running on a XP Professional, I'm getting the 'SQL Server does not exist or access denied' message. I am able to connect to the XP database from my W2K through the Query analyzer, so everything regarding firewalls and networkprotokols should be correct. But as I wrote, my CE client is unable to connect when the database is on a XP Professional. I'm using mixed mode and are supplying a username and password in my connection string.
I believe it has something to do with security, but has anyone any idea to what I need to set up or change on the XP machine to make the database accessable from my CE client? Or maybe I need to do something differently in my CE program when connecting to SQL server on a XP host.
Regards
Trond Lind
January 20, 2006 at 9:49 am
just to make sure you have everything right on firewall settings http://support.microsoft.com/kb/839279
What is your current connectionstring? Does it use a name or an ip-address?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply