we are trying to connect a data base which is in the server to a client in a local network.The base is built with mssql server 2000 and the problem is that the client cannot recognize the base.we followed the following steps in the msssql server
Tools-wizards-data base-create login wizard
and did all the steps in the wizard choosing sql server authentication
setting the server role : system administrators
and finally choosing the name of our data base.
After all these we are going to the client and we're choosing new sql server registration and then we're following the intructions by selecting our server.the client doesn't recognize the server.
PLEASE HELP!WE ARE DESPARATE!!!!!!!!!