Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

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

Posted on 2006-10-24
5
205 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...
0
Comment
Question by:JackOfPH
  • 2
  • 2
5 Comments
 
LVL 4

Expert Comment

by:boy8964
ID: 17801079
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!
0
 
LVL 30

Expert Comment

by:nmcdermaid
ID: 17801115
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)
0
 
LVL 15

Author Comment

by:JackOfPH
ID: 17801170
Does the 4 computer need to have IP addresses?
0
 
LVL 15

Author Comment

by:JackOfPH
ID: 17801204
The Issue here is that we do not have free IP address...
Also we are using Static IP address
0
 
LVL 30

Accepted Solution

by:
nmcdermaid earned 500 total points
ID: 17801379
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.



0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Nslookup is a command line driven utility supplied as part of most Windows operating systems that can reveal information related to domain names and the Internet Protocol (IP) addresses associated with them. In simple terms, it is a tool that can …
Downtime reduced, data recovered by utilizing an Experts Exchange Business Account Challenge The United States Marine Corps employs more than 200,000 active-duty Marines with operations in four continents, all requiring complex networking system…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question