473,324 Members | 2,501 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Remove connection to MSDE 2000

Hi,

I am struggline to make my VB.Net windows client connect remotely to a MSDE
database. The database is accessed ok from the remote PC when i used web
forms (aspx) to access it.

Can anyone provide me with an idiots guide to make the connection work from
a windows client application?

I get the following error:
Connection failed because of an error in initializing provider.
[DBNETLIB][Connection Open(Connect()).]SQL Server does not exist or access
denied
I know the SQL Server does exist so am wondering how to resolve the access
denied. The 2 PCs are on an intranet. I need to know what i need to do on
both PCs to make the connection work. Thanks for any help! J.
Jul 21 '05 #1
2 1641
Lemme guess.. your web forms app is on the same machine as the MSDE
instance right? It seems like the MSDE instance is not setup for access
over the network. MSDE SP3 onwards has a default setting that disables
network access to the server. Did you include the
DISABLENETWORKPROTOCOLS=0 setting in the settings.ini file (or command
line) while installing MSDE. If you didnt then MSDE is not configured
to use the network protocols to allow other machines on the network to
access it. You can enable them by doing the following:

1. Run -> svrnetcn.exe using the command line. This should open the SQL
Server Network Utility dialog.
2. If Tcp/IP and named pipes are in the disabled network protocols
list, add them to the Enabled Protocols list.

After that as a safe precaution restart the SQL Server service, and try
connecting with the client again.

You can also check out this article that shows how to confiugure MSDE.
http://www.codeproject.com/database/ConfigureMSDE.asp

Hope this helps,
NuTcAsE

Jul 21 '05 #2

Thanks very much - much obliged - that did the trick!!!!
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 21 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: izzy | last post by:
I was wondering if any of you guys can kindly help me in finding all the different versions of MSDE 2000 that came out since it's first release. I expected to find something similar like Sun's...
5
by: Igor Solodovnikov | last post by:
Hi. I am trying to automatically backup transaction log when error 9002 happened. So i have created appropriate job and alert to catch this error. I have two instances of sql server under Windows...
10
by: noname | last post by:
MSDE 2000 Release A installed under windows 2000 pro will not communicate with SQL Server Manager nor MS Access on peer computer. Can someone help? Have set DISABLENETWORKPROTOCOLS=0 at install...
1
by: smahler | last post by:
Hi all, Here is my situation. I have an application that uses SQL 2000. The client has a program that uses MSDE. The client MUST have the MSDE version of the Database. What I have done is to...
4
by: William | last post by:
I am using SQL MSDE edition due to financial reasons (it's free). I have a question regarding connection strings. Almost every publication, online example or website uses some version of the...
2
by: John Blair | last post by:
Hi, I am struggline to make my VB.Net windows client connect remotely to a MSDE database. The database is accessed ok from the remote PC when i used web forms (aspx) to access it. Can anyone...
2
by: hfk0 | last post by:
Hi, I have a simple asp.net application running ok on my WinXP development server with SQL Server Express 2005 installed locally. After moving to the live server (Win 2000 server with MSDE 2000...
1
by: RobOfTage | last post by:
Hi, I've recently downloaded MSDE and have tried to create a small app to test the connection. It fails at the Connections Open() method with an error indicating an invalid server version. I'm...
9
by: HC | last post by:
Hello, all, I started out thinking my problems were elsewhere but as I have worked through this I have isolated my problem, currently, as a difference between MSDE and SQL Express 2005 (I'll just...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.