Posted on 2005-05-02
Last Modified: 2010-03-19
We have a sql server 2000 machine.
we can connect to it using termila services or locally, but unable to connect to it from any other machine on the network .

The only change we made is , adding a 1 Gig NIC card to it.

Please advice!

Question by:crishna1
    LVL 5

    Accepted Solution

    Did it work before adding the card? If you have 2 cards you actually may not be able to see the SQL server, because it is configured to work with one network. Check the SQL server network utility to make sure it configured correctly (tcp/ip, named pipes or whatever) and that it is configured with the correct card.

    Author Comment

    Thanks for the quick responce!

    everything was working fine, even after adding the nic card. It was just rebooted this morning.
    we are able to work on that machine , but not able to connect to it from anyother machine on the network..:-(
    LVL 34

    Assisted Solution

    Post your SQL Log.  Do you actually see the "Listening On....." at the top of your SQL log?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now