You are here: Re: Cannot connect to a new installed SQL Server 2000 « MsSQL Server « IT news, forums, messages
Re: Cannot connect to a new installed SQL Server 2000

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

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация