We have just installed a SQL Server 2000 (SP 3A) onto a computer that
has Windows-2003 Server on it. Now, we cannot get access to that
database server from other computers. Seem like this may be an issue
with Active Directory.
Our network consists of Windows-2000 Servers (SP 4) and Windows-2000
workstations and Windows-XP workstations. We also have SQL Server 2000
(SP2) in three Windows-2000 servers. All work fine. Recently, we get a
new server that has already had Windows-2003 Server pre-installed.
After we have installed SQL Server 2000 (SP 3A) on the new server, we
find that we cannot get access to that new database server from other
computers.
I have tried connecting to that new database server using Query
Analyzer (using both the sa account and Windows Authentication), and I
get this error message:
Unable to connect to server NEWDBSRV:
Server: Msg 17, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not
exist or access denied.
I have tried connecting to that new database server using ISQL (using
both the sa account and Windows Authentication), and I get this error
message:
DB-Library: Unable to connect: SQL Server is unavailable or does not
exist.
Unable to connect: SQL Server does not exist or network access
denied.
Net-Library error 53: ConnectionOpen (Connect()).
I have also tried to register the new database server using Enterprise
Manager (again, using both the sa account and Windows Authentication),
and I get this error message:
NEWDBSRV - SQL Server does not exist or access denied.
ConnectionOpen(Connect())
The only way that I can get access to the new database server is to
open Enterprise Manager directly on the new server.
I have compared the properties of the new database server and those of
the other existing database servers. The only differences are:
- Other database servers are running Windows-2000. The new database
server is running Windows-2003.
- The new database server is missing the "Active Directory" page-tag
when I check its properties using Enterprise Manager. We use Active
Directory in our network, and the Active Directory is being run from a
Windows-2000 server (that is currently also a database server).
According to our network administrator, he has already put the new
server into our Active Directory. He doesn't know why it is missing
the Active Directory page-tag. He believes this has something to do
with its having Windows-2003 that is different from other servers
(that have Windows-2000).
Thanks in advance for any info.
Jay Chan