[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.dotnet.framework.odbcnet

Connecting With Visual Studio .net

Charles A. Lackman

1/13/2006 10:29:00 AM

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


3 Answers

Andrea Montanari

1/13/2006 11:00:00 AM

0

hi Chuck,
Charles A. Lackman wrote:
> 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&P...
.... 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/D... http://ital...
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

1/13/2006 5:17:00 PM

0

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

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 wrote:
> 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

Charles A. Lackman

1/15/2006 8:56:00 PM

0

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


"Charles A. Lackman" <Charles@CreateItSoftware.net> wrote in message
news:O%23rnzwCGGHA.344@TK2MSFTNGP11.phx.gbl...
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