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.