Posted by helmut woess on 03/01/06 15:57

Am 1 Mar 2006 05:16:44 -0800 schrieb bitchanger:

> I have installed an SQL Server 2000 Developer Edition (SP4) on a
> computer that has Windows Server 2003 on it.The server is connected to
> the workgroup "WORK" and has no Active Directory. Now I cannot connect
> to that database server from other computers in the network. On the
> server itself, I can registrate the instance from the own SQL Server
> 2000 and also an instance from an other SQL Server 2000 installation on
> a Windows 2000 Server in the network.
>
> The network consists of a Windows 2000 Server (with a SQL Server 2000
> installation), some workstations (W2000 Pro, Win XP Pro) and the new
> installed Windows Server 2003.
>
> When I try to connect to that new database Server with Query Analyzer
> from an other computer I get allways the message box with the text like
> "...SQL Server doesnt exist or access denied. ConnectionOpen
> (Connect())..."
>
> Many thanks for help.
> bitchanger

Standard installation disables network protocols like TCP/IP for server
access. If you have not defined this explicit in the setup.ini before
starting the install, you have to do this by hand, using SQL Server Client
Configuration.

bye,
Helmut

[Back to original message]