SqlConnection and MSDE

[Mark]

I use SqlConnection to connect to a MSDE on a sesktop-PC.
I tried it with two different desktop-PC's. With the first
(OS: Windows 2000 Professional) everything works fine, but
with the second (OS: Windows XP Home) I get an error: 'SQL
Server dosn't exist or the access is denied'
I can ping both desktop pc's from my pocket pc device.
Are there some special network settings for Win XP?

Can anybody help me?

 

[Bob]

That's a great one Mark,

I've been having no end of problems with this.

Bob

 

[Sai]

try a smaller port number. Give 3140 a shot.

I use this all the time from my pcoket pc to both msde and
sql server to a number of differant operating systems.

Couple of things to check are if the msde install has a
instance name in which case you need to put it on the
connection string. Other thing I found handy is to change
the default listening port in sql to something other than
14333 and then put that on the connection string

ie

server\vsdotnet2003,3044

For a server called server instance name vsdotnet2003 port
number 3044