sql server msde: MSDE connection working with IP address but not instance name -- sql server msde

Re: MSDE connection working with IP address but not instance name

William (Bill) Vaughn
1/31/2007 8:07:53 AM

sql server msde:

Sounds like a DNS issue. Let's see the ConnectionString.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

[quoted text, click to view]

MSDE connection working with IP address but not instance name

webmaster NO[at]SPAM graphisoft.fr
1/31/2007 4:12:18 PM

I can't access to my MSDE instance from external clients if I select the
Instance name.
"this server does not exist or access is restricted"

If I use the IP adress instead everything is OK. (I always use sa account /
sql server authentication).

- Both MSDE server and clients are on XP SP2.
- I set an exclusion on XP firewall for TCP 1433 port on the MSDE server.
- I have checked that the named pipes are enabled using SVRNETCN.exe

=> can anyody find an issue about that problem.