can I access the server? Discussion and of course if possible how?

I have four computers which is not member of a domain and a server which is member of a domain...

The server has an sql server 2000 installed...

the four Computers (not part of the domain) has a software installed which needs to connect to the sqlserver 2000 that is in the server (that is member of the domain).

Is it possible for the software that was installed in the four computer (that is not part of the domain) can connect to the sql server 2000.

Can this be done? Can the four computer connect to the sqlserver 2000 in the server which is part of the domain? If so, How can I set it up?

Please help...
LVL 15
Who is Participating?
nmcdermaidConnect With a Mentor Commented:
Yes having an IP address is part of having TCP/IP connectivity (point 2)

>> we are using Static IP address

That is not a problem as long as you have TCP/IP connectivity.

To test conenctivity go to a command prompt on one of the clients and type

PING <SQL servers IP address>

This verifies that you can see the host.

The next test is

TELNET <SQL Servers IP address> 1433

A balck screen indicates that you can connect to the SQL Server service and you should be fine.

I am assuming they are in smae LAN... It is quit easy! Install SQL Server 2000 Enterprise Manager on other computers and then you can use it to connection your SQL Server!

You simply

1. Use SQL Logins (as Windows logins are a little more difficult with domain/non domain setup)
2. Ensure you have TCP/IP connectivity (which can doesn't have to be an issue with domain/non domain setup)
3. Ensure port 1433 is open on the server (assuming SQL is on the default port)
JackOfPHAuthor Commented:
Does the 4 computer need to have IP addresses?
JackOfPHAuthor Commented:
The Issue here is that we do not have free IP address...
Also we are using Static IP address
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.