We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

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

JackOfPH
JackOfPH asked
on
Medium Priority
251 Views
Last Modified: 2012-03-15
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...
Comment
Watch Question

Commented:
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!
Yes.

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)

Author

Commented:
Does the 4 computer need to have IP addresses?

Author

Commented:
The Issue here is that we do not have free IP address...
Also we are using Static IP address
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.



Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.