• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 355
  • Last Modified:

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

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
starkmanDev
Asked:
starkmanDev
1 Solution
 
graham_charlesCommented:
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
 
starkmanDevAuthor Commented:
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
 
walterecookCommented:
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
 
EvolutionmarketplaceCommented:
Try downloading and installing the last MDAC version in the client computer.

Best regards,

Pablo.
0
 
PashaModCommented:
PAQed, with points refunded (20)

PashaMod
Community Support Moderator
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now