sql server msde: The MSDE can't be connected from other workstations? -- sql server msde

The MSDE can't be connected from other workstations?

zhaounknown
3/29/2005 9:31:04 PM

sql server msde:

I have SQL Server 2000 (installed first) and MSDE(named instance) both
installed in Workstation A, and be accessed by .Net applications in
Workstation B.

I can open the SQL Server in the server explorer and ADO.net, but can't
connect to MSDE. Also, I notice that the port listend by the MSDE is 1127.
Workstation A and B both installes XP SP2.

Each time, I connect to the named instance of MSDE in Workstation B, and get
the error of "[DBNETLIB]...doesn't exist or login denied".

Re: The MSDE can't be connected from other workstations?

Andrea Montanari
3/30/2005 11:43:40 AM

hi,
[quoted text, click to view]

please have a look at
http://support.microsoft.com/default.aspx?scid=kb;en-us;328306&Product=sql
for the most coomon causes of that kind of exception
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply