Connecting With Visual Studio .net

[Charles A. Lackman]

Hello,

I have MSDE Installed on a different computer (WIndows 2003) within my
network. I also have MSDE Installed on my production computer for
development.

I have successfully created databases on both computers using OSQL. What I
would really like to accomplish is a connection from the Server Explorer in
Visual Studio .NET.

I have a successful connection to the local instance of MSDE and I added my
server to the server list with no problems.

But, this is where the problem comes in.

Lets Say my Server is called Moon, The Servers Tree in Server Explorer
shows Moon, I can access the Event Logs, Message Queues, Performance
Counters and Services with on problem. But, when I click on SQL Servers
Moon is shown with a Red X, I click the Plus (+) sign, type in the Login and
Password, I receive the following Error:

{DBNETLIB}{ConnectionOpen (Connect().]SQL Server does not exist or access
denied.


Any Suggestions will be greatly appreciated,

Chuck

 

[Andrea Montanari]

hi Chuck,

Hello,

I have MSDE Installed on a different computer (WIndows 2003) within my
network. I also have MSDE Installed on my production computer for
development.

I have successfully created databases on both computers using OSQL.
What I would really like to accomplish is a connection from the
Server Explorer in Visual Studio .NET.

I have a successful connection to the local instance of MSDE and I
added my server to the server list with no problems.

But, this is where the problem comes in.

Lets Say my Server is called Moon, The Servers Tree in Server
Explorer shows Moon, I can access the Event Logs, Message Queues,
Performance Counters and Services with on problem. But, when I click
on SQL Servers Moon is shown with a Red X, I click the Plus (+) sign,
type in the Login and Password, I receive the following Error:

{DBNETLIB}{ConnectionOpen (Connect().]SQL Server does not exist or
access denied.

the most probable causes of this problem are listed in
http://support.microsoft.com/default.aspx?scid=kb;en-us;328306&Product=sql
.... please check with the Server Network Utility that the Moon MSDE instance
has enabled network protocols, as MSDE installs by default allowing local
connections only...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

 

[sloan]

Read my How to (Msde related) at:
http://spaces.msn.com/members/sholliday/

12/16/2005 entry date.

The key is the
[Options]
DISABLENETWORKPROTOCOLS=0
SECURITYMODE=SQL

stuff.

Use the KB mentioned earlier, to manually make the fix.

My stuff will teach you how to avoid the issue in the future, if you
ever install MSDE again.

(Or if you get really really stuck and need to start over)

 

[Charles A. Lackman]

Hello,

I found a way to fix the problem,

Below is what I needed to do.

Run the svrnetcn.exe on which you installed MSDE It will show you SQL Server
Network Utility Dialogbox, Make sure that TCP/IP is enabled and the port is
1433.

Chuck


Hello,

I have MSDE Installed on a different computer (WIndows 2003) within my
network. I also have MSDE Installed on my production computer for
development.

I have successfully created databases on both computers using OSQL. What I
would really like to accomplish is a connection from the Server Explorer in
Visual Studio .NET.

I have a successful connection to the local instance of MSDE and I added my
server to the server list with no problems.

But, this is where the problem comes in.

Lets Say my Server is called Moon, The Servers Tree in Server Explorer
shows Moon, I can access the Event Logs, Message Queues, Performance
Counters and Services with on problem. But, when I click on SQL Servers
Moon is shown with a Red X, I click the Plus (+) sign, type in the Login and
Password, I receive the following Error:

{DBNETLIB}{ConnectionOpen (Connect().]SQL Server does not exist or access
denied.


Any Suggestions will be greatly appreciated,

Chuck