MSDE SQL Connection error

I am trying to connect to a remote MSDE SQL database. When I set up the odbc connection I get a connection denied error. The SQL server is on a windows 2003 server. Any ideas are greatly appreciated.
Thanks, LinsLoMSDE won't allow remote connections on Windows 2003 unless you apply MSDE sp3a.

-PatP|||This is currently on the server, but it is still not connecting...|||what are you using to connect? a programming language (c, c++, c#) and are they .net? If you are using .net then i would suggest trying to use the sql connection library instead of the odbc. are you on the same network as the db server? please provide more info on your situation. I can not give an accurate answer with out more information

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.

MSDE Problem - SQL Server not found or access denied

I am running the MSDE 2000 Setup off the SQL Server 2000 Developer Edition CD.

After installation is complete, there is a service under the Control Panel -> Services window
called MSSQL$GregInstance. I then start that service.

But now when I try to connect to the database using

osql -E -S GregInstance

I get told that the SQL Server does not exist or access denied. Even though the server is running. I have also tried

osql -E -S localhost

but no luck. Why can it not find the instance of SQL Server?

Note : SQL Server 2000 is not installed on the machine, only this MSDE instance.

Thanks
GregNot to worry, I forgot to add in the name of the pc with a \ before the instance name...

i.e

osql -E -S GREG\GregInstance