Solved

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

Posted on 2006-10-24
5
219 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
[X]
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
  • 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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

A brief overview to explain gateways, default gateways and static routes OR NO - you CANNOT have two default gateways on the same server, PC or other Windows-based network device. In simple terms a gateway is formed when a computer such as a serv…
Many of us in IT utilize a combination of roaming profiles and folder redirection to ensure user information carries over from one workstation to another; in my environment, it was to enable virtualization without needing a separate desktop for each…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

707 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