Wednesday, March 28, 2012

MSDE Sp3 client connection

Hi, I am trying to connect to a MSDE Sp3 database remotely, however I always
got "server does not exist or access denied". I was told that the problem is
from sp3.
Any idea how can I solved the problem'
Met vriendelijke groet,
Guoqi Zheng
Tel: +31 (0) 23 5343545
http://www.meetholland.comMSDE has limitations on how many workloads it can accept, not what kind of
connections it can take. One question though, what kind of OS is MSDE
running on? Windows 98 does not provide Named Pipes support, so you may
have to change your connection protocol to TCP/IP sockets. Also TCP/IP
sockets runs on port 1433 by default, if there is a hardware or software
firewall blocking that port, you will be in trouble.
The biggest troubleshooting step I can suggest is to just try and map
another shared network resource from that computer -- printer, shared drive,
ipc$ (if available), whatever. Do you have any problems with that? Can you
connect after that?
Good luck. Hope that helps.
****************************************
***************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
****************************************
***************************
"Guoqi Zheng" <no@.sorry.com> wrote in message
news:%23uJUoH9zDHA.2568@.TK2MSFTNGP09.phx.gbl...
quote:

> Hi, I am trying to connect to a MSDE Sp3 database remotely, however I

always
quote:

> got "server does not exist or access denied". I was told that the problem

is
quote:

> from sp3.
> Any idea how can I solved the problem'
> --
> Met vriendelijke groet,
> Guoqi Zheng
> Tel: +31 (0) 23 5343545
> http://www.meetholland.com
>
|||Thanks a lot for your quick reply. It is running under MS 2003 server web
edition.
The server is a dedicated server, I can not put any shared driver there.
What should I do'
Met vriendelijke groet,
Guoqi Zheng
Tel: +31 (0) 23 5343545
http://www.meetholland.com
"Andy Svendsen" <andymcdba1@.NOMORESPAM.yahoo.com> ะด?
:uZPzzN9zDHA.2180@.TK2MSFTNGP12.phx.gbl...
quote:

> MSDE has limitations on how many workloads it can accept, not what kind of
> connections it can take. One question though, what kind of OS is MSDE
> running on? Windows 98 does not provide Named Pipes support, so you may
> have to change your connection protocol to TCP/IP sockets. Also TCP/IP
> sockets runs on port 1433 by default, if there is a hardware or software
> firewall blocking that port, you will be in trouble.
> The biggest troubleshooting step I can suggest is to just try and map
> another shared network resource from that computer -- printer, shared

drive,
quote:

> ipc$ (if available), whatever. Do you have any problems with that? Can

you
quote:

> connect after that?
> Good luck. Hope that helps.
> --
> ****************************************
***************************
> Andy S.
> MCSE NT/2000, MCDBA SQL 7/2000
> andymcdba1@.NOMORESPAM.yahoo.com
> Please remove NOMORESPAM before replying.
> Always keep your antivirus and Microsoft software
> up to date with the latest definitions and product updates.
> Be suspicious of every email attachment, I will never send
> or post anything other than the text of a http:// link nor
> post the link directly to a file for downloading.
> This posting is provided "as is" with no warranties
> and confers no rights.
> ****************************************
***************************
> "Guoqi Zheng" <no@.sorry.com> wrote in message
> news:%23uJUoH9zDHA.2568@.TK2MSFTNGP09.phx.gbl...
> always
m[QUOTE]
> is
>
|||Check the firewall logs with the network admin.
Verify that your client application is sending TCP traffic not SMB. (Named
Pipes)
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

No comments:

Post a Comment