• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Small SQL problem

P

PowerYoga

Diamond Member
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?
 
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.
 
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.
Click to expand...

add an alias to the client or the server?
 
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?
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top