Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Cannot Connect to MSDE 2000 database across the network

Posted on 2004-09-12
7
Medium Priority
?
246 Views
Last Modified: 2012-06-27
I have MSDE 2000 installed.
I just installed the latest version yesterday from Microsofts website (so it is the latest)
Along with this, I have SQL Server 2000 developer edition installed for management of the engine.

I have it running just fine on my local machine.
I used these setup parameters when installing
setup instancename ="instancename" sapwd="mypassword" securitymode=sql

This works fantastic as long as i am connecting to the instance on the local machine.
I was inexperienced at the setup of MSDE prior to today and so when installing I left off the

disablenetworkprotocols=0 switch in the setup command line statement.
So I have effectively disabled my network support.

I am not able to connect to the instance of MSDE now across the network and I need this fixed.
Can anyone tell me how to do this paaalease?

I have ran the svrNetCN.exe utility located in C:\program files\microsoft sql server\80\Tools\Binn and enabled TCP/IP
Support on the default port (thought this would solve my issue but did not)

I stopped and restarted the service multiple times and it still does not work.
I do not have sql client tools installed on the client so i cannot try to connect using the sql client tools to the database.

Internet connection firewall is disabled on both PCs and both PCS are within 10 feet of each other (XP Pro and XP Home peer to peer)

helllllpppppp!!!
0
Comment
Question by:ferguslogic
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
7 Comments
 
LVL 1

Author Comment

by:ferguslogic
ID: 12038728
An update.

I installed Sql server developer client tools on the peer to peer computer that cannot connect to sql server and whala I am able to connect to sql server using query analyzer or enterprise manager. I simply cannot connect through the application that I have built.  Soooo any ideas.

Here is the connection string

Provider=sqloledb;Data Source=Server\[SQLInstanceName];Initial Catalog=[DBName];User Id=sa;Password=[password]

this connection string works great on my local box but fails miserably across the network.

I have tried this also
Provider=sqloledb;Data Source=\\Server\[SQLInstanceName];Initial Catalog=[DBName];User Id=sa;Password=[password]

Every time I get "invalid connection"

any help is greatly appreciated.
0
 
LVL 1

Author Comment

by:ferguslogic
ID: 12039123
And to finally answer my own question after hours of work...if you do not use the DisableNetworkProtocols=0 option when you run setup you will not be able to connect across the network.

Installing a new instance of sql server with this setup

Setup InstanceName="instancename" Sapwd="password" SecurityMode=sql disablenetworkprotocols=0

resolved the issue and the client connects just fine.

When you do not use the disablenetworkprotocols flag in the setup string query analyzer and enterprise manager will be able to connect remotely but clients will not.

Issue resolved.
Please reissue points to PAQ
0
 
LVL 1

Author Comment

by:ferguslogic
ID: 12560479
I do not understand how to get a refund but I will try
0
 
LVL 1

Author Comment

by:ferguslogic
ID: 12560668
I have posted a request for question deletion and points to be refunded. I was able to answer the question myself after a short time frame.

thank you
0
 

Accepted Solution

by:
ee_ai_construct earned 0 total points
ID: 12589489
Question answered by asker or dialog valuable.
Closed, 500 points refunded.
ee_ai_construct (replacement part #xm34)
Community Support Admin
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question