Small SQL problem

[PowerYoga]

I'm new to SQL and I'd like to link 2 computers together, with one computer acting as the server with the SQL server while the other acting as a client.

I instaled SQL 2000 eval version on the server computer with everything, did databases and everything. Now I installed client tools only on the client computer and i can't figure out how to link the 2 together. When i try to add a new database for the client computer, it would just say something like "xxxx is not found or does not exist".

Are there specific steps that I can follow?

 

[Thor86]

You'll need to use Client Network Utilities to add the server "alias" so your Client Enterprise Manager can connect and manage your SQL DB server.

The built-in help is a good starting point.

 

[PowerYoga]

You'll need to use Client Network Utilities to add the server "alias" so your Client Enterprise Manager can connect and manage your SQL DB server.

add an alias to the client or the server?

 

[PowerYoga]

new update... i figured out the reason why i couldn't connect to the host SQL computer was because of the windows firewall.

now, i am trying to add the server so that it can connect to the SQL server but when it prompts for a user name and password i'm stumped, as i never did set user name and password except for the databases.

Those user name(s) and password(s) are not the ones that you use to log in to the server, and i can't log in using guest accounts.

is there a way you can create an account?