SqlConnection and MSDE

  • Thread starter Thread starter Mark
  • Start date Start date
M

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?
 
try a smaller port number. Give 3140 a shot.
Shane Wilson said:
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
Click to expand...
 
Back
Top