?
Solved

SQL server does not exist or access denied. ConnectionOPen(COnnect())

Posted on 2003-03-09
5
Medium Priority
?
351 Views
Last Modified: 2012-05-04
I am trying to install sql server 2000 MSDE on a PC that is on a workgroup -- not a domain. The install goes fine, however the name of the server (the local machine name that i just installed to) doesn't show up when i open Enterprise Manager and try to add a new sql server registration. Arghh. When i enter the local machine name and try to register with sql server authenification, it gives me:
"SQL server does not exist or access denied. ConnectionOPen(COnnect()). Basically this computer is in a workgroup on a Peer to peer network, so i am wondering if this server will ever even be able to be accessed from a client machine on the network. Do I have to somehow create a domain to make this work? Thanks in advance for any help.

Stark
0
Comment
Question by:starkmanDev
[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
5 Comments
 
LVL 6

Expert Comment

by:graham_charles
ID: 8101866
You don't need a domain, but you might need some registry entries on the client to make it connect to the server. Try using the Client Network Utility to explicitly define the target server and network library and associate it with an "alias"; that may solve the problem. If not, here are a couple more ideas:

If you're using TCP/IP and the standard port, then the most likely issue is that the server name isn't resolving; try

ping ServerName

from a command prompt to see if you get the IP of the server. (Connecting to the fixed IP is ideal, in this situation.)

If you've got a firewall, make sure port 1433 (or whatever port you've configured SQL Server to use) is open by trying

telnet ServerName 1433

to see if it's blocked.

Let me know how it goes and good luck,

g.
0
 

Author Comment

by:starkmanDev
ID: 8103837
After looking at the ms knowledge base and other forums i have solved my problem -- I only installed the client tools and not the MSDE fully. Once i got the msde installed i got another error like "not associated with a trusted sql connection" from ent manager, but from http://support.microsoft.com/default.aspx?scid=kb;EN-US;285097  kb article 285097  i just reinstalled msde with the switch they recommend (SECURITYMODE=SQL) in order to get the sql authentication. That worked.  Thank you for your comment above though charles, it is still helpful and i will absorb it.

Stark
0
 
LVL 17

Expert Comment

by:walterecook
ID: 10337084
No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:

PAQ with points refunded

Please leave any comments here within the next four days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

walterecook
EE Cleanup Volunteer
0
 

Expert Comment

by:Evolutionmarketplace
ID: 10344200
Try downloading and installing the last MDAC version in the client computer.

Best regards,

Pablo.
0
 

Accepted Solution

by:
PashaMod earned 0 total points
ID: 10364742
PAQed, with points refunded (20)

PashaMod
Community Support Moderator
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In this article, I’ll look at how you can use a backup to start a secondary instance for MongoDB.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

752 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