1, system structure environment: A static IP local area network environment. B All database software is SQL Server 2000 C a SQL Server 2000 Enterprise Database Server operating system is Win 2000 Server or Win 2003 Server. D Multiple users need to use clients of database server databases. E For your convenience test, the SQL Server 2000 Enterprise Database is also installed at each client, and the server database is connected to the query analyzer. 2, the problem: a, the database server uses WIN 2000 Server, the client query analyzer only needs to enter the database server, the login name, and password can be. B, the database server uses WIN 2003 Server, open the query analyzer connection server, enter the database server, login name, password connection, appears as follows: 'Unable to connect the server XXX: Server: Message 17, Level 16, State 1 [Microsoft ] [ODBC SQL Server Driver] [DBNetlib] SQL Server does not exist or access to rejection '. C. Before making B operation, log in with the client, first servers GUEST or other account, then open the query analyzer, enter the database server, login name, password, the connection is successful. And when you log in to the server with IP, you can only log in with IP in the query analyzer, and use the service name to log in to the server, you can only log in with the service name in the query analyzer. Do one IP login first, then do a machine name login, you can successfully log in in the query analyzer's IP and machine names. 3, the main reason for this result is the safety of Win 2003 Server, I would like to ask the master, what kind of settings should be done under Win 2003 Server Server, so that the client query analyzer can be like Win 2000 Server Which is directly connected?
